Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Dates relationships for multiple table visualisations

I have data with lots of date columns. I have made a dates table and have inactive relationships hooked up so that I only need one date slicer on a page. I know how to write and use measures with USERELATIONSHIP.

 

I can't figure out how to use the date relationships when setting up table visualisations, because I don't usually add a measure to these. I want to have multiple table visualisations on the same page with each of them using a different date relationship to the dates table, so that I can adjust all of them with one slider. 

For example, I want to be able to set a date range using my dates table slicer, and display a table visualisation listing the details of my cases opened during the period, and a second table listing details of my cases closed in the same period.

Is there a clever way to write measures that I can add as a filter to the tables or something? 

Thank you!

3 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable

      Yes but how do I implement them into the table? 
      Do I have to write a measure for each column in the table and wrap it in a calculate function to add the USERELATIONSHIP?