Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have Data like this
Date Amount 1 Account
2002-08-31 5 1
2022-07-31 3 1
2022-06-30 3 1
2002-08-31 1 2
2022-07-31 2 2
2022-06-30 1 2
If i sum everything by date I have
Date
2022-08-31 Sum(Amount1)=6
2022-07-31 Sum(Amount1)=5
2022-07-31 Sum(Amount1)=4
But then I need to create a line graph with Date as a measure and with height of the bar with
2022-08-31 Sum(Amount1, In date t)-Sum(Amount1,In date t-1)
The desired output of the example woul be a line graph with
2022-08-31 1
2022-07-31 1
Thanks
Hi, if you expand the measure there is an option to set a modifier, selecting 'Difference' will do the trick.
Hi, if you expand the measure there is an option to set a modifier, selecting 'Difference' will do the trick.