Stacked bar charts by values in each category

[May Tam]

Is there a way to sort stacked bars value (largest to smallest) within each category See attached JPEG. Thanks!

[Shashank Gurnalkar]

This is an existing enhancement request that is under consideration on our Ideas Portal.

https://ideas.tibco.com/ideas/SPF-I-4909

I would request you to vote for it and also add your valuable comments to it. This is the most effective way for you to interface directly with our product team and see the status of your enhancement ideas.

[Khushboo Rabadia]

You can use a workaround to achieve this requirement:

Suppose A,B,C are [Regions], next level in hierarchy is [state] and color by has [Category], then you can insert a rank expression between REGION NEST STATE

where

Count() OVER (Intersect([state],All([Category]),[Region])) - This will get you total values for each bar. As we are using Over function in X-Axis expression, do not forget to select "Current Filtering only" in X-axis > Settings, to have ranking update based on change in filters

 

DenseRank(..,"desc",[Region]) - This will rank total values of each bar in descending order for each Region

https://docs.tibco.com/pub/spotfire_server/10.0.0/doc/html/en-US/TIB_sfire_bauthor-consumer_usersguide/GUID-3E9F7F06-620A-40F5-9837-CB8997C511B8.html

Repeat( " ",..) - This will repeat blanks as per rank provided. As you know, by default barsare always in alphabetical order so rank 1 will have one blank, rank2 will have two blanks etc. and it will automatically be in order as seen in below screenshot