RangeAverage in Line Chart

[arvindjha2050]

Hello Team,

We have a Line Chart with 2 dimensions and Measure ,

a>Week Ending Date(x-axis)

b>Category(Represented by multiple lines)

c>Calculation for 4 week Rolling 

RangeAvg(Above (total sum(Sales) , 0 ,4))

The above works when i select a Category but for multiple categories it doesn't work .

While trying to investigate i know that we need to have sorted by brand and then week ending date but it's not working for line chart , the same works in Table chart.

Thanks,

Arvind

[arvindjha2050]

Hello all,

Please assist

[MayilVahanan]

Hi @arvindjha2050 

May be try like below

Avg(Aggr(RangeAvg(Above(sum(amount), 0, RowNo())), Category, Week))

[arvindjha2050]

Hello @MayilVahanan 

Thanks for the response , the issue is still there

[MayilVahanan]

Hi @arvindjha2050 

can you share sample app or data?

[arvindjha2050]

Hello @MayilVahanan 

Thanks for the response , attached is sample data , the Table chart is the data we want to see in Line Chart.

The same can be done by having multiple measures one for each Category but it requires enhancement on inclusion of new Category in future.

[MayilVahanan · Accepted solution]

Hi @arvindjha2050 

Try like below

(Aggr(RangeAvg(Above(sum(Value), 0, 3)), Category, (Week_Ending_Date,(NUMERIC, ASCENDING))))

[arvindjha2050]

Thanks a lot @MayilVahanan