Forum Discussion
Disconnected Date table filtering
Hello,
Need a little help. This seems so simple but despite hours of reading I can't quite figure it out. I have a report with 3 pages, each page contains a table, and each table contains a date value. Rather than use a separate date filter on each page, I'd like to create one date filter. Then, each of the tables on each page will filter a specific column using that date. I"m simplifying things here - but an example of my table structure is below:
Table1
Record ID
Date Submitted
Table 2
Record ID
Date Closed
Table 3
Record ID
Date Created
I am looking for a dropdown filter that asks the user to select a "reporting period". Once that period is selected (usually, a month and year) - I want all 3 of those tables to use that date the user selected, then filter the table using that value. So for example, if the user selects August 2024 as the reporting period - use that selection to filter table 1 on Date Submitted, Table 2 on Date Closed, and Table 3 on Date Created.
Any help is appreciated!
2 Replies
- lbendlinSuper User
Use a calendar table
Put the month and year fields in the filter pane ("Filter on all pages")
wire your datamodel with the three connections from the calendar table to the fact dates
Use USERELATIONSHIP to calculate the measures for each table visual
- AnonymousNot applicable
Thanks! I have a calendar table with relationships. Can you elaborate on how to use USERELATIONSHIP to calculate each table visual? I think this is where I am stuck due to lack of knowledge...