periodOverPeriodLastValue calculated field

Question & Answer
1

Hi, i have a datetime field called ‘date_month’ and a interger field called ‘cantidad’ but the following calculated field result is in blank:

periodOverPeriodLastValue(sum({cantidad}), {date_month}, MONTH, 1)

also tried:

periodOverPeriodDifference(sum({cantidad}),{date_month}, MONTH,1 )
and still blank

2

Can you provide a small snapshot of your data?

Is it returning 0 in a specific visual?

3

Hi @GRAQ? Are you able to provide a screenshot as requested? Also, can you check to make sure you don’t have any filters applied that could be filtering out data for that date? If you have filters, have a look at this tip on DemoCentral to see if helps resolve your question.