Bar Chart with Variations for Date View

ShellyG — Sat, 16 Nov 2024 17:23:20 GMT

Dear All,

I will need your help and ideas with the following:

I have a simple combo chart with the following dimensions and measures:

Dimension - Report Date (which is a simple date field in the format of 'DD-MMM-YY')

Measure 1 - sum(Value)

Measure2 - count(Records)

The chart is working properly and shows correct amount. What I want to do is the following:

Instead of seeing the data for each date, I would like to:

1. See the last 14 days in the format of 'DD-MMM-YY'

2. See the last 6 weeks in average

3. See the rest in the form of monthly average

Please refer to the drawing uploaded for more clear view of what I would like to have...

Any ideas and suggestions on how to accomplish this are more than appreciated!

Re: Bar Chart with Variations for Date View

ShellyG — Wed, 17 Mar 2021 10:43:38 GMT

I believe it needs to be something like that:

sum(aggr(if([Report Date] > (vScriptStart-14), sum(Value), Avg(Aggr(Sum(Value), Weeks))),[Report Date]))

But this doesn't work properly...

Any ideas?