Hide the first periodOverPeriodDifference Value in a visual sheet

Hi @yezhehu

Following calculations work fine without a date filter. However, period-over-period calculations cannot be used with a date filter.

For the Value - Last Month End calculation, used to get the last value of the month is explained in this community post.

Example:

Value on Last Month Same Day - periodOverPeriodLastValue(count({Customer ID}), {Reporting Date}, MONTH, 1)

Difference from Last Month Same Day - periodOverPeriodDifference(count({Customer ID}), {Reporting Date},   MONTH, 1)


1 Like