Making the Difference between a sum of values

MartinMendina — Sat, 03 Sep 2022 15:33:47 GMT

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

Re: Making the Difference between a sum of values

rubenmarin — Sun, 04 Sep 2022 16:23:02 GMT

Hi, if you expand the measure there is an option to set a modifier, selecting 'Difference' will do the trick.