maxOver Function?

[Phillip_Le]

I have this Tableau calculation I am trying to mimic. I think I have to use maxOver in this case. I’ve tried this.

maxOver(traffic,[{marketplace_id},monthending, {page_type},{device_type}],PRE_FILTER)

However, my number is off from the Tableau calculation. Any help would be appreciated!

[Ying_Wang]

Do you mind to provide your dataset and expected calculation results? Thanks!

[Tatyana_Yakushev]

maxOver is not a replacement for FIXED LOD in Tableau.
I believe we just enabled the new functionality for all accounts that allows user to specify partitions as the second argument for many of the simple aggregation functions. Can you check if the following works in your account already?

max(traffic_o,[marketplace_id, monthending, page_type, device_type])

[yingkz]

what is the difference between

max(traffic_o,[marketplace_id, monthending, page_type, device_type])
and

maxOver(traffic,[{marketplace_id},monthending, {page_type},{device_type}],PRE_FILTER)

[David_Wong]

Hi @yingkz,

maxOver is a type of window function and max is a type of aggregate function. This article explains the difference between aggregate and window 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…