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
Hi Maik, okay if that's not the standard day entity at the top then it'll be a bit more difficult since you won't be able to use the inbuilt time/date functionality. I think to do it in the format you have it there you'd need to populate a second cube with the figures for the previous date basically, so that you could compare the two blocks.
If you were doing it in a horizontal layout you'd need to create an entity containing all of those values from the left axis, you would then have that entity as part of your cube structure. You'd populate the current period value(s) into the relevant row(s) and you could then use Nexel to reference the block to the left as you wanted to do to calculate the difference.
Basically your life would probably be much easier if that was the normal Day entity you had at the top rather than a custom entity, but I understand that may not be possible 🙂
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.
Hi Robert, how would you do it in an horizontal view.
The Days at the top are not Time range entities that is a normal entity
Maik
