How to create a Top N Filter based on Calculated Field using PeriodOverPeriodDifference

Hello,

I am trying to create a Filter to isolate the Top N movers in my dataset over time (without using an Insight–those are too difficult to use and manipulate). I am creating the growth/movement function using a PeriodOverPeriodDifference function:

growth = periodOverPeriodDifference(avg({%useTotal}), {date})

It can be seen here in my variables list in my Analysis.

Screenshot 2023-11-28 at 3.42.00 PM

However, when trying to filter out servers with useTotal, I cannot select growth from the ranking options.

Is this the intended behavior? I would like to be able to filter based on this variable. Thanks.

Hi @anonymous ,

Have a look at order of evaluation ( Order of evaluation in Amazon QuickSight - Amazon QuickSight ) . The periodOverPeriodDifference is a table calculation which is the reason you don’t see the calculated field in Top/bottom N filters .

Regards,
Koushik