Calculated Field Error for Creating Yes/No Flag

[duncan]

Hello @yipk !

I would recommend moving the avgOver calculation to its own and retrying this calculated field:

avgOverCalc = avgOver({pkg_count}, [{sort_center}, {parent_stacking_filter},{stacking_location}])

ifelse(
contains({stacking_location}, ‘-FLAT’) = 'True' AND 
avgOverCalc < 250, 
‘Y’, 
‘N’)

I also recommend checking out this blog post from one of the community experts:

Level-Aware Calculations: Tips and Best Practices

[Level-Aware Calculations in Amazon QuickSight] Level-Aware Calculations (LAC) are powerful functions that allow us to perform calculations at a granularity level which is different from the granularity of our datasets and/or visuals. The sample dataset referenced by this article is a dataset of product orders placed by customers. Each order can contain multiple products and each product in an order has a unique Line Item ID. Each row of our dataset represents one line item but we want to per…

Let me know if this helps!