Period on period calculations donot show in Total field

Question & Answer
1

I have created a MonthOnMonth%Difference calculated field:
MonthOnMonth%Difference = periodOverPeriodPercentDifference(distinct_count({}),{<date_column>}, MONTH ,1)

In a pivot table, I have added a category in row section, date month field in column and count and periodonperiodpercentdifference in value section.

The problem is that, total section for MonthOnMonth%Differenceis shown as blank:
image

Also, when I filter on last 2 months, the MonthOnMonth%Difference is null for my previous month

Can anyone help?

Thanks in advance,
Ajinkya

2

For periodOverPeriodPercentDifference you need to have both months to compare. So for May 2023 you would need April 2023 in your table.

In regards to totals, I think that would need to be a feature request. I can mark it as one.

3

I have added filter stating last 2 months only
In that case, the period on period data for pervious month is not visible

Note: I have data for last 10 months so it is not a data related issue.
It has to do something with the default PRE_FILTER, PRE_AGG, POST_AGG_FILTER