How do I create an ‘Other’ group when ranking
18 October, 2012
A problem I have been struggling with for a while. Hopefully there is an easy answer I have missed!
I wish to split a pie graph into 6 categories. One slice for each of the top 5 stores and the sixth slice for everything else ('Others').
Basically I want to show what proportion of sales is made up by the top 5 stores.
Store ID Sales
123 $900,000
135 $800,000
099 $760,000
230 $730,000
111 $500,000
Others $850,000
Obviously the top 5 are not static so I can't group store IDs manually.
Any help would be appreciated.
Thanks
I wish to split a pie graph into 6 categories. One slice for each of the top 5 stores and the sixth slice for everything else ('Others').
Basically I want to show what proportion of sales is made up by the top 5 stores.
Store ID Sales
123 $900,000
135 $800,000
099 $760,000
230 $730,000
111 $500,000
Others $850,000
Obviously the top 5 are not static so I can't group store IDs manually.
Any help would be appreciated.
Thanks
Hi,
that sort of functionality is not supported in Yellowfin at the moment so I have raised an Enhancement Request for it (task ID = 120097). Things are very busy here at the moment as we work our way towards the YF 6.2 release in late-November, but certainly after the release this request will be investigated to see how feasible it would be to implement it.
Regards,
David
that sort of functionality is not supported in Yellowfin at the moment so I have raised an Enhancement Request for it (task ID = 120097). Things are very busy here at the moment as we work our way towards the YF 6.2 release in late-November, but certainly after the release this request will be investigated to see how feasible it would be to implement it.
Regards,
David
Thanks for the response. Look forward to seeing the new release!
Maybe you can try subquery. In the master report get the top 5 stores and in the subquery (union) get others.
Regards
Rahul
Regards
Rahul
+1 I am eager to see this too.