Pie chart question on slicing

Question & Answer
,
1

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 different labels - ‘Top 10’ and ‘Rest’ and then using this field as a Group but as expected it errors saying custom aggregations can’t be used as dimensions.

Any insights on this?

2

Hi @ajio,

Can you show your calculated fields?

3

ifelse(

rank([sum({totalorder}) DESC],[{plant_no}]) < 21, ‘Top 20 order’, ‘Rest order’

mainly is it possible to acheive this is pie chart?

4

Can you try this?

ifelse(
	denseRank([sumOver({totalorder}, [{plant_no}], PRE_AGG) DESC], [], PRE_AGG) < 21, 'Top 20 order',
	'Rest order'
)
5

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.

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 - QuickSight Arena