[Screen Shot 2022-06-21 at 4.51.29 PM] 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. …

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(traf…

maxOver Function?

Question & Answer

David_Wong February 28, 2024, 4:56am 5

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.