Jump to content

Multi-category Bar chart sorting based on one category's values

Zoltan Kis

Recommended Posts


I need to have a solution to sort the parent category of amulti-category bar chart based on the values of the child category, but Spotfire's native solution only allows me to have a flattened list sorted by the child category only (not keeping the hierarchy.

In my example I have mobile phones and readio access technologies (4G (white) and 5G (blue)). What I try to create is a list of the mobile phones sorted by their 5G values (blue) but to have their 4G values displayed too to get an overview on the share of the data volume for each RAT. The total volume is not interesting so stacking is not an option.

The desired list of the values in my example would look like this:

Samsung Galaxy S20 Ultra




Samsung Galaxy S10 5G




OnePlus 8 Pro




ZTE. Axon 10 Pro 5G




Xiaomi Mi Mix 3 5G




LG V60 ThinQ 5G





Could you suggest any solution please.


Thank you



Link to comment
Share on other sites

You dont say whether you have access to IronPython scripting or not, and what your actual data structure is.

I am assuming no scripting, and data with three columns: Type,5G,4G.

A basic (no scripting) solution could be:

1.Create a nested Hierarchy as 5G, then Type

2.Set up a side-by-side Barchart with Values 5G, 4G and Category the Hierarchy, fully expanded.

3.You see the bars sorted as 5G although the 5G values do also appear at the bottom of your Category.

Link to comment
Share on other sites

Hi Zoltan, Gaia,


I assumed the following dataset:


Samsung Galaxy S20 Ultra;5G;5

Samsung Galaxy S20 Ultra;4G;15

Samsung Galaxy S10;5G;7

Samsung Galaxy S10;4G;17

OnePlus 8 Pro;5G;9

OnePlus 8 Pro;4G;11

ZTE. Axon 10 Pro 5G;5G;3

ZTE. Axon 10 Pro 5G;4G;4

Xiaomi Mi Mix 3 5G;5G;11

Xiaomi Mi Mix 3 5G;4G;16

LG V60 ThinQ 5G;5G;3

LG V60 ThinQ 5G;4G;13


Based on that set, you can also use a combination chart, in which you are able to sort on either the value 5G or 4G (see also this post:https://community.spotfire.com/questions/sort-bars-side-side-bar-chart). The only 'drawback' with a combination chart, is that it can only show data vertically, not horizontally as in the example picture.

Kind regards,


Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...