topic Re: Aggregation with dates having Date itself as a Dimension in App Development

Aggregation with dates having Date itself as a Dimension

Shubham_D — Tue, 20 Apr 2021 07:48:13 GMT

Hi All,
I have Date as a dimension and that same date I have to use in measure expression for calculation, how to achieve this ?

Chart : Combo
Dimension : Date
Measure : Count (if( DoJ < (date(Date)-30) , IDs))

In this case, Date is same field...

Re: Aggregation with dates having Date itself as a Dimension

tresB — Tue, 20 Apr 2021 07:51:41 GMT

Try like:

Count (if( DoJ < date(Date-30) , IDs))

Re: Aggregation with dates having Date itself as a Dimension

Shubham_D — Tue, 20 Apr 2021 09:12:17 GMT

Hi @tresB
Ohh, as I mentioned in post I was using the same you suggested but "Continuous Scale" was enabled so it was behaving differently.

Thanks !!