Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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

  • 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

    • Anonymous's avatar
      Anonymous
      Not 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...