Dashboard - One Tracker (Date Range) two different queries

Hi All,

Looking for the best way forward on this one.

I have a tracker with a date range within the tracker. It’s two separate queries on the dashboard but engineering would like both queries filtered on the single tracker. I was going to take the approach of a master record being the filter but unfortunately they’re two different datasets and there is no similar record.

Any ideas on resolving this one?

Keep 2 trackers and pass the first tracker values to the Second one on value change or before the refresh in customization then hide the second tracker.

Aaron, something we do is create the tracker using an updateable query of only calculated fields. This makes it easy to use dates, nvarchars, ints, or any type of value to filter the queries. Then you can publish those values from the updateable tracker and subscribe to them on multiple queries on the dashboard.

3 Likes