Hi Community.
I have a unique situation in my dashboard which has me stomped:
I have data flowing in on an aggregated basis which populates one of the tabs i.e. YTD Sales = $XX. On another tab, I have a weekly view of this sales figure i.e. Week of 9/8/18 = $XX.
The issue is that when no week is selected, the YTD $XX is being doubled and in some cases tripled if that particular item has more than one weeks worth of data.
How can I distinguish the aggregate YTD data to show only the unique $XX and disregard other weekly values?
My aggregate expression is as follows:
=Count({<[Issue Category], [Issue Category]={'UnContained'},Reference_Only={'No'}>} [Issue Category])
Any help provided will be greatly appreciated.