Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need help to create a formula to a line chart. I want to create a chart using set analysis to specify a range of the axis x (I want just a sample of the dimension I selected), and at the same time I want it to be a cumulative line graph. For example:
Month Value
November 2020 300
December 2020 150
January 2021 250
February 2021 175
March 2021 450
In this example, I want my graph to cover only between December 2020 and March 2021 and to be cumulative, with 150 for December, 400 for January, 575 for February...
How can I create an expression for a line chart like that?
Thanks a lot!
=RangeSum(Above(Sum({<Month={"*"}-{'November 2020'}>}Value),0,RowNo()))
=RangeSum(Above(Sum({<Month={"*"}-{'November 2020'}>}Value),0,RowNo()))
Thanks! It really helped me. But just another question: do you know how can I apply the same expression but in order to always represent between the range of maximum month date until the last 12 months? I try to use the max function inside the set analysis, but I got confused how apply for this case.