periodOverPeriodDifference function not giving values

[kanzhao]

Hi Team,

I am trying display the week over week change value for the “Q1 Production…” column using the calculated field

"periodOverPeriodDifference(avg({Q1 Production goal = 0.85}),date,WEEK,1). "

For this table, I also have a filter set on the date.

But I am not seeing the values? Could you please advise?

[kanzhao]

this is the final product I am aiming for, to have the rolling dates in the columns, and week over week change.

There will be a parameter to accept user input, and in the database I have a column “week” for all the week number and a “date” column for the date of each week.

[ErikG]

Hi @kanzhao
what if you disable the filter?
BR

[kanzhao]

Hi Erik,

Thanks,

It did work, now I am getting the values on the periodoverperiod calculated field. But when I apply a filter to speficy a date, then it’s not working again. Could you possibly share if there is way to work around with this?

[ErikG]

HI @kanzhao
please have a look at

Creating period comparisons with QuickSight's periodOver and periodTo functions

This article uses the SaaS-Sales Dataset that you can download as part of the QuickSight Author Workshop. We will update the data to the current date so your calculations are realistic. If you do not have a QuickSight account please follow the instructions in the Initial Setup. Instructions to create the dataset can be found in Exercise 1 of the Build your first dashboard. Create an analysis for the dataset. The following steps show you how to create visuals to show data from the current year,…

maybe the part “Filter the data” will help.
BR