LAC calculation on a visual

[duncan]

Hello @mamilone !

To clarify, do you want to keep d_bucket_1 or replace it with d_bucket_2 as a LAC-W?

If you want to replace d_bucket_1 with a LAC-W you could try the following:
countOver({outb_final_quantity_requested}, [prod_product_id, order_date])

Or if you want to to do a sum of the results from d_bucket_1 as d_bucket_2:
sumOver({d_bucket_1}, [prod_product_id, order_date], PRE_AGG)

I would also recommend checking out this blog to learn more about using these types of functions:

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…