Forum Discussion

jirazazabal's avatar
jirazazabal
Cloud Apps
02-04-2022
Solved

Calculate value from same period last month

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!

dashboards & reporting
  • Konrad's avatar
    Konrad
    02-07-2022

    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.

3 Replies

Replies have been turned off for this discussion
  • Konrad's avatar
    Konrad
    Cloud Apps
    02-07-2022

    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's avatar
    jirazazabal
    Cloud Apps
    02-04-2022

    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!