Why does the "Previous Year" time function still return current year data?

govindakarisma

I would like to understand why, when I enable the Previous Year time function on the cube, the result still shows the current year's data. For example, I only have data for 2024. However, when I activate the function, the values returned are still from 2024 — instead of returning nothing (since 2023 data doesn't exist) or possibly returning 0.

As additional context, the time range in my setup is configured from 2024 to 2045

Helmut Heimann

Hi @govindakarisma ,

first of all, you've set the block's data to previous year and previous period value, which would make it to be previous previous year (the year before last year).

If you don't see any values, it's probably because you've switched "show all" off.

The next thing is (and this often leads to cconfustion) the somewhat odd behaviour that applied time-functions are not directly referred to in the layout's header. So, if you have data for 2024 only, apply the PY function to that, you'll still see "2024" in the header (supplemented by any additional header text), which is a bit misleading.

Best,
Helmut