Subscription to a dashboard with dynamic date ranges

fhana — Thu, 03 Oct 2024 08:29:30 GMT

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?

Re: Subscription to a dashboard with dynamic date ranges

fhana — Wed, 16 Oct 2024 07:14:41 GMT

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

topic Subscription to a dashboard with dynamic date ranges in App Development

Subscription to a dashboard with dynamic date ranges

Re: Subscription to a dashboard with dynamic date ranges