calculating differences in script by date

[#1]

Hi!

I am trying to create a trend line and on top of the trend line, I would prefer to have number of differences compared to the previous date.

I have used the same expression for both the bar and value on the point.

two exact same expression but one with bar and one with no visible chart but just value on the point.

so instead of the exact calculation of the number I would like to have today's number - yesterday's number.

I am currently using Date as dimension.

so I want the number of the bar to be like

+30   -20    +34  -12  +34 something like this.

Thank you!

[maxgro · Accepted solution]

maybe with the above function

Missing Manual - Above() and Below()‌

In chart, it could be something as sum(Sales) - above(sum(Sales))

[#3]

this is exactly what I needed!  thanks!!

Can I ask you one follow up question?

this is what it looks like now.

is there any way I can put a + sign in front of the positive numbers?

[MarcoWedel]

Hi,

maybe by changing the format pattern accordingly:

hope this helps

regards

Marco