Donut Chart - Number of Slices Displayed based on Parameters

Question & Answer
,
1

How do I make the ‘Number of slices displayed’ follow the ‘Top’ Parameter?

quicksight Screenshot 2024-10-07 171223
quicksight Screenshot 2024-10-07 1712231672×591 47.4 KB

If I add a filter to the Chart to follow the ‘Top’ Parameter, it will not show ‘Other’ Products.

I want the user be able to adjust ‘Number of slices displayed’ by using the ‘Top’ Parameter.

2

Hi @danial ,

Welcome to the QuickSight Community!!

I can think of configuring this with the use of a calculated field.

Step 1: calculate rank of the model based on quantity
step 2: write an ifelse clause to check rank <= parameter value. if condition satisfies, return model name, else hard code the model name as Other.
Step 3 : use the newly created field instead of model in the donut visual

I have not implemented this, so you may need to check whether rank function dependent calculation throws a reference error in the visual. Please try out and let us know if this worked.

Thanks,
Prantika

3

Thanks @prantika_sinha, I will definitely try this out.

4

Hi @danial,
It’s been awhile since we last heard from you, did you have any additional questions regarding your initial post?
If we do not hear back within the next 3 business days, I’ll go ahead and close out this topic.

Thank you!

5

Hi @danial,
Since we haven’t heard back, I’ll 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!