Calculate value from same period last month

[jirazazabal]

Hi,

I need to solve this scenario: I can calculate the current month sales, from 01/02 to 04/02, but I need to compare the same period last month, this case, 01/12 to 04/12 last year. In order to check how the value it's going. Do you know how to solve it?

Thanks!

[jirazazabal]

In order to clarify, I've got this:

I need to get the totals as indicators, in order to calculate the current sales (3.250.235.989,69) vs the same period last month (1.535.220.400,57) to calculate the diff% in order to add an arrow to indicate the trend. It's not only to calculate the past value, it's to get it in an indicator view.

Thanks!

[Konrad · Accepted solution]

Hi @jirazazabal ,

You can create custom column on Elasticube level with following query ifint(getday([DELIVERED_AT]) <= getday(now()),1,0) and use it as a widget level filter to limit the scope of days from last month.

[jirazazabal]

Thanks! Seems to be a valid approach!