LOD in Quicksight?

Question & Answer
1

Hi All.

Is there any cases studies where level of detail functions (of Tableau) such as FIXED, INCLUDE, EXCLUDE are mimicked inside Quicksight.

Thanks,

1 Like
2

Hi, we tried to mimic FIXED by using xxxOver functions (SumOver, MaxOver … )
It work for us in most cases

2 Likes
3

@emilyzhu , FYI. check this.

1 Like
4

Hi, we are going to launch a new suite of function called Level Aware Calculation. It allows you to create aggregate function with specified level independent of visual - similar to the use case of Tableau’s LOD function. It will be launched soon (within a few weeks), and we will announce to the community at that time.
Before that, we have a suite of window functions, as mentioned by @daniel.lazaro that you can mimic the functionality. You can try that as workaround. Using level-aware aggregations - Amazon QuickSight

4 Likes
5

Is there any update on this yet? I have tried using max/min for my use case but unable to achieve it.

6

Hi @gunthaa,

Level aware calculations are already available.

Can you describe your use case in a separate topic?

1 Like