Error periodOverPeriodLastValue periodo week

Question & Answer
,
1

Hello, good afternoon, can you please help me, I got an error in quicksight when filtering the date dimension by the week period, it simply does not show me the result and it is with the periodOverPeriodLastValue function.

Note: The only problem is with that period, by day, month, year, quarter I have no problem.

2

Can you please share your calculation?

3

periodOverPeriodLastValue(sum(MONTOVENTA),FECHA,“YEAR”,1)

4

Take out quotes from your period.

periodOverPeriodLastValue(sum(MONTOVENTA),FECHA,YEAR,1)

5

I don’t understand your question, I use a date field to filter by period but when I integrate the YoY last year calculated field, it doesn’t show information only with the week period

6

Is this still an issue?

Here are broader discussions on the week.