In a pie chart i would like to make one slice with top 20 orders highest values as one slice and the remaining orders as the other slice to be able to compare between the top 20 and the rest. Is it possible , tried with calculated field using aggregation rank and ifelse together to create two diffe…

Can you try this? ifelse( denseRank([sumOver({totalorder}, [{plant_no}], PRE_AGG) DESC], [], PRE_AGG) < 21, 'Top 20 order', 'Rest order' )

Hi @ajio , Can you show your calculated fields?

ifelse( rank([sum({totalorder}) DESC],[{plant_no}]) < 21, ‘Top 20 order’, ‘Rest order’ mainly is it possible to acheive this is pie chart?

thanks @David_Wong i will test out but i believe is will still throw custom aggregations can’t be used as dimensions due dense rank aggregation.

Pie chart question on slicing

Q&A

Xclipse May 15, 2024, 12:44am 6

Hi @ajio, in case you need further assistance with your problem, please create a sample dashboard with sample dataset showing your problem state using Arena and please create a new post. (Details on using Arena can be found here - Quick Sight Arena

Topic		Replies	Views
I need to show different pie charts based on rank wise Q&A developer , embedding , quick-sight	2	70	July 16, 2024
Mismatched Aggregation Issue for Creating a Calculated Filed Q&A quick-sight , calculations , Business-Intelligence-Engineer	2	160	January 17, 2024
The calculated field I created cannot be used because "Custom aggregate fields cannot be used as dimensions" Q&A admin , error , quick-sight	4	1249	November 22, 2023
How do I create a rank to dynamically control my bar chart? Q&A formulas , charts , analysis , parameters , formatting , error , quick-sight , visuals , calculations , visual , Business-Intelligence-Engineer	14	254	June 18, 2025
Error Creating Calculated Field Q&A parameters , error , quick-sight , calculations , Business-Intelligence-Engineer	4	85	October 17, 2024

Pie chart question on slicing

Related topics