periodOverPeriodLastValue display the week period

[Jesus_Castillo]

I am using a calculated field with the periodOverPeriodLastValue function but when using the week period as a filter in the date dimension it does not work

[RobHendriks]

Can you provide more detail?
Sample table of the data, etc…

[Jesus_Castillo]

[Jesus_Castillo]

It works with the period of year, month, day, quarter but not with the week as shown in the image

[RobHendriks]

Are you seeing this issue in a ‘table’ ?
What visual type are you using in your screenshot?

[Jesus_Castillo]

I have the problem in a dynamic table or any type of graph

[Max]

Are you still facing this issue?

[Jesse]

periodOverPeriodLastValue is a table calculation, which means it is computed on the data displayed in your visual. If you were to add a filter to remove all the prior weeks, there will be no data to compare the latest week to, and will get no data.

I suggest you follow the technique in this article if you want to show Period Over Period, while only showing the most recent period (instead of keep all the other historical data in your visual).

Period Over Period and Other Date Comparison Calculations (YoY, MoM, YTD, Rolling 90 days, etc)

Often you may want to create tables and other visuals which display multiple fields that are all ‘filtered’ to different date periods, as well as period-over-period fields. However we can’t use normal filters for this since filters get applied to all fields in the visual. Conceptually in this solution we are building the filters directly into the calculated field itself (using the ifelse logic), so that each field can have a different ‘filtered’ time period. You can then do whatever math you wan…