Forum Discussion
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!
Hi,
You will have to write measures.
3 Replies
- Ashish_MathurSuper User
Hi,
You will have to write measures.
- AnonymousNot 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?- Ashish_MathurSuper User
Yes.