How to implement mixed lod's in quicksight (Exclude (fixed))

Q&A
,
1

Hi Everyone,

Hope you are doing well.

I’m trying to implement the nested LOD in quicksight.

sum({exclude [subcategory]: sum({fixed [order_date],[region],[product category],[category]: Min([sales])})

I was able to crack the fixed LOD in qs as min({sales}, [{order_date},{region},{product category}, {category}]).

But unable to implement the exclude in QS

Expected output

image
image415×123 2.03 KB

Here - sumover ({sales}, [Region], Pre_agg) don’t work as it is taking sum at region level and we are using “Min” with Fixed LOD in Tableau

Many Thanks In Advance

2

Hi @MadhaviShirbhate ,

Welcome to the Quick Sight Community!!

For the fixed one, lets modify the calculation a bit.
minOver({sales},[{order_date},{region},{product category},{category}],PRE_AGG)

This will allow you to perform further aggregation on this.

For the exclude to work, you would need to take note of the fields you are using in visual and then write the formula to exclude the specific field from partition and add all other dimensions as you have in your visual to the partition. You would need to nest the minOver for the sumOver you write for your exclude LOD.

Thanks,
Prantika

1 Like
3

Hi @MadhaviShirbhate,
It’s been awhile since we last heard from you, did you have any additional questions regarding your post or were you able to find a work around from the suggestion provided above?

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you!

4

Hi @MadhaviShirbhate,
Since we have not heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.

Thank you!