Hi! I am creating a report that shows a metric value on a monthly basis (i.e
Metric Value), along with:
Value in the previous month (i.e.
Metric Value (Prev. 1m))
% change from the previous month (i.e.
Metric Value (% change))
To get only data from the last 5 months (including the current month), the following condition was applied:
The results of the report for the condition above:
However, I noticed that the value of
Metric Value (Prev. 1m) for the last entry (i.e. Mar 2023) changes if the condition is changed to
last 4 months until today:
The expectation is that
Metric Value (Prev. 1m) should be 1,281 for Mar 2023. However, the results show 1,258. Why is this the case? Do I need to ensure that complete months are selected in order for Period-over-Period Comparison to work as per expectation?