Subscription to a dashboard with dynamic date ranges
Hi,
I have an application with ticket stats data spread across a few sheets. I want to create two subscriptions to the same set of sheets, one with a date range of the previous month and the second with a date range of the previous quarter.
How can this be achieved in general so the date is dynamic and Is there a way to achieve this without duplicating the app to get two different dynamic date ranges?
I found a way to approach this and most charts work well beside one based on a particular measure.
Here is what I did I created two dimensions and two filters based on these dimensions then selected each filter and created separate subscriptions. First thing I don't understand is that the filters show values -1 and 0 when -1 is selected the filter is active and charts are adjusted to proper values.
Dimensions Last Month =([sd.created] >= MonthStart(AddMonths(Today(), -1)) AND [sd.created] <= MonthEnd(AddMonths(Today(), -1)))
Last Quarter =[sd.created] >= QuarterStart(AddMonths(Today(), -3)) AND [sd.created] <= QuarterEnd(AddMonths(Today(), -3))
Second thing I don't understand is that one measure doesn't follow the conditions or I'm missing something.
The measure expression is count(distinct{<resolved = {">=$(=Min(sd.created)) <=$(=Max(sd.created))"},[sd.created]= >} key)
seems like the [sd.created]= is not taken in to consideration cause this measure count(distinct{<resolved = {">=$(=Min(sd.created)) <=$(=Max(sd.created))"} >} key)
shows exactly the same amount and I know there should be more based on SQL's that I run on the source.
When I ignore all the filters with 1 like this count(distinct{1<resolved = {">=$(=Min(sd.created)) <=$(=Max(sd.created))"},[sd.created]= >} key)
