Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
gz
Creator

values ​​cumulatively

Hi, I would like to show the value dynamics for several months. 

gz_0-1721724445712.png

at the moment I can show you day by day. I need to show subsequent days cumulatively, so that it is the sum of the previous days

This is the expression for the previous month:

Sum({<data_przyjecia={">=$(=date(floor(monthstart(addmonths(Today(),-1))), 'YYYY-MM-DD'))<$(=date(Addmonths(today(),-1),'YYYY-MM-DD'))"}>}saldo_przyjecia_pln)

 

Labels (2)
1 Solution

Accepted Solutions
lennart_mo
Creator

HI @gz,

Have you tried using the modifier for your expression? It should be directly under your expression when you edit the visualization and gives you the ability to accumulate your values.

lennart_mo_0-1721734858223.png

 

View solution in original post

2 Replies
lennart_mo
Creator

HI @gz,

Have you tried using the modifier for your expression? It should be directly under your expression when you edit the visualization and gives you the ability to accumulate your values.

lennart_mo_0-1721734858223.png

 

gz
Creator
Author

thanks a lot for your help, that's exactly what I wanted