PoP without parallel comparison data on a datalabel

#1

Dear all,

I have the following usecase:

  • data for whole year 2018;
  • data for 2019 until e.g. 23 april;
  • datalabel with PoP comparison with 1 year backward option;

Using the PoP function I`ve created a datalabel that calculates the difference between the selected period (year, month, quarter - as single date filter) and the PoP 1 year backward period.

I have created a metric set with both current and PoP measures and did a difference trough a formula.

The problem is that if I select in my filter 2019, the PoP comparison is made with the whole 2018 values while I was expecting that it would take only the values from the dates that are available in 2019.

So if I select 2019 in the filter, it should take the values from 1.Jan to 23.Apr 2019 and compare them with the values from 1.Jan to 23.Apr 2018 not the whole 2018 values.

The " Return All Parallel Period Comparison Data" is not selected, and does nothing if so.

Any idea how can I achieve what I desire?

Thank you so much!

2 Likes
#2

You can use a calendar range filter on the data label, that goes from the beginning of the current year until a specific date and in this case the PoP Value will go back one year and sums the same period, but one year backwards. See following image example:

image
image.png909×594 18 KB

Explanation:
The table on the left shows the sum of Valor until abr 01, 2019 and also the sum of the same period one year backwards. The middle table shows all the data I have, just to verify that the solution I appointed works. On the right, a datalabel that show the difference from the both periods, which in this case is 0.

Hope this helps,

Luis Silva

3 Likes
#3

Good idea. Thank you Luis!