Page Filters and DateCard Date Filters

AmyStephen
AmyStephen ⚪️
edited January 4 in Charting

Our organization has a monthly reporting cycle where departments submit their monthly Performance Metrics for review by organizational leadership. Each department has a dashboard containing Data Cards with their metrics.

Some Data Cards measure work activity for a single month using a Data Card "Date Range" of "This Month" and a "Date range field" of "Current Presentation Begins" and a "Date filter" of "is greater than or equal to."

Some Data Cards measure work activity over time, for example using a Data Card "Date Range" of "This Year", again filtered by the "Date range field" of "Current Presentation Begins" and "Date filter" of "is greater than or equal to."

This works perfectly for displaying the Current Month Performance Metrics when using "Page Filters" set to "Date Range" "Default" and "Graph by" "Default."

A requirement of the project is to provide access to each monthly Performance Metrics submission as it was presented. Meaning, the dashboard should show what was submitted as "This Month's Metrics" and "Last Month's Metrics" and so on.

Using the Page Filters with "Date Range" set to "Previous Month" the single month Data Cards appear, as expected. But, the trending Data Cards only show the previous month. The DOMO Page Filters do not respect the Data Card "Date Range" specifications.

I'm hoping we are missing a setting that would force the application to display the trend Data Cards by setting the date back to a particular month, and then use the DataCard "Date Range" settings to display the trend as it did during the month of submission.

Any ideas?

Tagged: