topic Re: RangeAverage in Line Chart in App Development

RangeAverage in Line Chart

arvindjha2050 — Sat, 16 Nov 2024 00:35:20 GMT

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

Re: RangeAverage in Line Chart

arvindjha2050 — Thu, 18 Feb 2021 06:32:17 GMT

Hello all,

Please assist

Re: RangeAverage in Line Chart

MayilVahanan — Thu, 18 Feb 2021 08:58:23 GMT

Hi @arvindjha2050

May be try like below

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

Re: RangeAverage in Line Chart

arvindjha2050 — Thu, 18 Feb 2021 09:15:00 GMT

Hello @MayilVahanan

Thanks for the response , the issue is still there

Re: RangeAverage in Line Chart

MayilVahanan — Thu, 18 Feb 2021 09:20:30 GMT

Hi @arvindjha2050

can you share sample app or data?

Re: RangeAverage in Line Chart

arvindjha2050 — Thu, 18 Feb 2021 10:09:14 GMT

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.

Re: RangeAverage in Line Chart

MayilVahanan — Fri, 19 Feb 2021 00:57:48 GMT

Hi @arvindjha2050

Try like below

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

Re: RangeAverage in Line Chart

arvindjha2050 — Fri, 19 Feb 2021 02:39:34 GMT

Thanks a lot @MayilVahanan