Re: RangeAverage in Line Chart

arvindjha2050 · ‎2021-02-17

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 · ‎2021-02-18

Hello all,

Please assist

MayilVahanan · ‎2021-02-18

Hi @arvindjha2050

May be try like below

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

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

arvindjha2050 · ‎2021-02-18

Hello @MayilVahanan

Thanks for the response , the issue is still there

MayilVahanan · ‎2021-02-18

Hi @arvindjha2050

can you share sample app or data?

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

arvindjha2050 · ‎2021-02-18

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 · ‎2021-02-18

Hi @arvindjha2050

Try like below

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

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

arvindjha2050 · ‎2021-02-18

Thanks a lot @MayilVahanan

RangeAverage in Line Chart

General Question

SaaS