Hi how can i calculate the difference between the values highlighted same color?
in the end it should a week over week difference. I tried with nexel but the result doesn't make sense.
The date in columns is changing everyday fyi.
thanks maik
Hello Maik, I assume right now you are using one block.
Did you considered to use 2 blocks (2nd one is shifted by 7 days)? Then you can use an algortihm.
Without knowing details about the DataModel and the Layout it is hard to say, how to do it in the best way
Regards
Björn
Hi Bjoern, these are individual algorithms.
I thought there is a way with Nexel ?!
Hi Maik, it appears you're using a vertical layout there, correct? In which case I'm afraid Nexel isn't supported on a vertical layout.
As Bjorn mentioned, adding a block replicating the value of block b but for -7 days should enable you to do the calculation.
An alternative way to achieve what you're doing there might be to create those different calculations you want to display as values in an entity and to use a rule to calculate the different rows, that way you could use an offset rule to reference the data set from -7 days and the like.
