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

[Zoltan Kis]

Hi,

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

5G

4G

 

Samsung Galaxy S10 5G

5G

4G

 

OnePlus 8 Pro

5G

4G

 

ZTE. Axon 10 Pro 5G

5G

4G

 

Xiaomi Mi Mix 3 5G

5G

4G

 

LG V60 ThinQ 5G

5G

4G

 

 

Could you suggest any solution please.

 

Thank you

Best,

Zoltan

[Gaia Paolini]

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.

[David Boot-Olazabal]

Hi Zoltan, Gaia,

 

I assumed the following dataset:

Phone;Type;Count

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,

David