Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
it starts to work