cancel
Showing results for 
Search instead for 
Did you mean: 

Calculate value from same period last month

jirazazabal
9 - Travel Pro
9 - Travel Pro

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!

1 ACCEPTED SOLUTION

Konrad
7 - Data Storage
7 - Data Storage

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.

View solution in original post

3 REPLIES 3

jirazazabal
9 - Travel Pro
9 - Travel Pro

In order to clarify, I've got this:

jirazazabal_0-1644009066343.png

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
7 - Data Storage
7 - Data Storage

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
9 - Travel Pro
9 - Travel Pro

Thanks! Seems to be a valid approach!

Voice of Customer
Impact Business Intelligence (BI) and Analytics Market Research

Click Here & Complete Dresner's Wisdom of Crowds® Market Study Survey Today!

Community Toolbox

Recommended quick links to assist you in optimizing your community experience:

Need additional support?:

Community Support Request

Don't miss out:

Earn a BETA Launch Challenge Badge!