Hi All, can someone tell me if it is possible to get an dynamic offset within the periodOverPeriodDifference function? Doenst matter if it is a calculated field or a ifelse direct in the function itself. periodOverPeriodDifference - Amazon QuickSight What we like to do is define the offset based…

Hi @duncan thx for your reply. Thats something i already tried. Calculation in a field in the formula itself. But looks like the only thing thats working is a parameter or fix value. i guess i have to build a ifelse around with the calculation for every potential diff. BR

Dynamic Offset within periodOverPeriodDifference

Q&A

duncan November 21, 2023, 9:40pm 4

Hey @ErikG!

Have you tried the solution given in this log? Looks like it might be what you are looking for:

Specifically section 6!

1 Like

Topic		Replies	Views
periodOverPeriodLastValue offset not static Q&A feature-request , calculations , how-to	4	1505	October 28, 2022
How to create a calculated field YoY with multiple controls parameters? Q&A calculations	5	384	May 8, 2023
Optional parameters in table calculation functions Q&A calculations , how-to	1	779	July 22, 2022
Formula to get difference of sales between 2 date range dynamically Q&A analysis , filters , parameters , calculations , how-to	1	1158	December 15, 2022
Period over Period difference - a way to choose the period? Q&A feature-request , calculations	2	939	September 18, 2022

Dynamic Offset within periodOverPeriodDifference

Related topics