Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try like below
(Aggr(RangeAvg(Above(sum(Value), 0, 3)), Category, (Week_Ending_Date,(NUMERIC, ASCENDING))))
Hello all,
Please assist
May be try like below
Avg(Aggr(RangeAvg(Above(sum(amount), 0, RowNo())), Category, Week))
Hello @MayilVahanan
Thanks for the response , the issue is still there
can you share sample app or data?
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.
Try like below
(Aggr(RangeAvg(Above(sum(Value), 0, 3)), Category, (Week_Ending_Date,(NUMERIC, ASCENDING))))
Thanks a lot @MayilVahanan