Forum Discussion

Minakshi's avatar
Minakshi
Resolver I
6 years ago
Solved

table relations

Hi all, I have one base table and other is reference table of its. I want to use mutliple slicer with this. I created a relation ship between them and all the slicer works other than Date.   Kindl...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Minakshi 

    Please try the following:


    1. Create a another calendar table with Calendar(), enter the earliest date from the 2 table as start date, and use latest date from the 2 tables as end date.

     

    Calendar table = Calendar(Date(),Date())

     

    2. Relation both tables to the calendar table using [Date] column, you should have a many to one relationship, where both tables on the many side, and the calendar table on the one side.

     

    3. Then, use the Date column in the new calendar table as slicer to filter visuals.


    Paul Zheng _ Community Support Team
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

Pragati11's avatar
Pragati11
Super User
6 years ago

Hi Minakshi ,

 

I think the issue might me in your calculations against FACTOR measure.

Try sharing it here.

 

Thanks,

Pragati

Minakshi's avatar
Minakshi
Resolver I
6 years ago

Pragati11 Factor is just for value, instead of 0 I want to write Non Compliant and insted of 1 , I want to write Compliant.

Factor = IF(value = 0, "Non COmpliant", "Compliant")

 

I think some other issue is there as I faced same issue with last time also and couldn't solve it.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Minakshi 

    Please try the following:


    1. Create a another calendar table with Calendar(), enter the earliest date from the 2 table as start date, and use latest date from the 2 tables as end date.

     

    Calendar table = Calendar(Date(),Date())

     

    2. Relation both tables to the calendar table using [Date] column, you should have a many to one relationship, where both tables on the many side, and the calendar table on the one side.

     

    3. Then, use the Date column in the new calendar table as slicer to filter visuals.


    Paul Zheng _ Community Support Team
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.