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 h…

Can you please share your calculation?

[image] Steph: Can you please share your calculation periodOverPeriodLastValue(sum(MONTOVENTA),FECHA,“YEAR”,1)

Take out quotes from your period. periodOverPeriodLastValue(sum(MONTOVENTA),FECHA,YEAR,1)

[image] Max: Take out quotes from your period. 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

Is this still an issue? Here are broader discussions on the week. [image] Week Numbers (1-53) Articles There’s also this page but I dont think you can subscribe to it:

Error periodOverPeriodLastValue periodo week

Q&A

Max April 3, 2023, 9:35pm 6

Is this still an issue?

Here are broader discussions on the week.

Topic		Replies	Views
periodOverPeriodLastValue display the week period Q&A quick-sight , calculations	7	811	April 7, 2023
Get last year value (periodOverPeriodLastValue) in a PRE_AGG scope Q&A formulas , feature-request , quick-sight , calculations	5	1297	May 10, 2023
periodOverPeriodLastValue Function in Quick Sight works on field, not works on visualls Q&A formulas , error , period-over-period , quick-sight , calculations , Business-Intelligence-Engineer	2	194	December 11, 2023
PeriodOverPeriod formulas not showing totals and dimensions problem Q&A feature-request , quick-sight , calculations	5	425	July 27, 2023
periodOverPeriodLastValue doesn't give a result when there is any other grouping dimension along with the date parameter Q&A quick-sight , Business-Intelligence-Engineer	5	162	May 6, 2024

Error periodOverPeriodLastValue periodo week

Related topics