Show previous period’s value if current period’s value is null

Q&A
, , ,
1

Hi everyone,

I’m trying to build a simple year-over-year comparison in Quick Sight. The challenge is: if the current period has no value for a country, that country disappears from the visual when I filter to the current year. What I’d like instead is for the country to still appear and show its previous year’s value.

Sample dataset:

Country,Date,Sales
DE,2024-01-01,1000
DE,2024-02-01,1200
DE,2025-01-01,1400
DE,2025-02-01,1600
BE,2024-01-01,800
BE,2025-01-01,950
BE,2025-02-01,1000
PL,2024-01-01,600
PL,2024-02-01,700

I uploaded this dataset into Arena and created a table visual. Filtered the visual to show only 2025.

Result:

  • DE, BE show correctly (2025 + 2024 values).

  • PL disappears completely because it has no value in 2025.

You can view the mock analysis here:
:backhand_index_pointing_right: YoY show previous period value (Arena link)

How can I configure Quick Sight so that, even if the current period’s value is null, the country still shows in the table and I can display the previous period’s value?

Thanks in advance for your help!

2

for PL, it cannot show the value of year “2025” as it doesn’t exists in the data. However, you can show the month name like this.

Does it work?

image
image407×293 6.34 KB

YoY show previous period value - Analysis Copy