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 c...
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.

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!