Forum Discussion
Husain
Advocate I
Advocate IBest visual to compare multiple values across 2 Groups/categories
Hi guys,
What do you think is the best visual to compare multiple values across 2 Groups/categories.
I tried with Column chart and Tornado but they look horrible becasue the 2 bars/columns to be compared are not sized according to each group of 2 values separately.
Here is the sample data. Comparing Military power of US and Russia(RU)
| Main Category | Sub Category | US | RU |
| Air Forces | Fighter aircraft: | 457.0 | 751.0 |
| Air Forces | Helicopters: | 4,889.0 | 1,505.0 |
| Air Forces | Multirole aircraf: | 2,192.0 | 526.0 |
| Air Forces | Total aircraft: | 12,304.0 | 4,441.0 |
| Air Forces | Attack aircraft: | 587.0 | 783.0 |
| General | Area: | 9,857,306.0 | 17,098,242.0 |
| General | Population: | 324,527,000.0 | 144,554,993.0 |
| Land Forces | Total artillery: | 3,269.0 | 14,557.0 |
| Land Forces | Armoured fighting vehicles: | 41,760.0 | 27,335.0 |
| Land Forces | Rocket artillery: | 1,197.0 | 4,032.0 |
| Land Forces | Self-propelled artillery: | 950.0 | 5,955.0 |
| Land Forces | Tanks: | 6,393.0 | 20,050.0 |
| Manpower | Available for military: | 73,270,043.0 | 34,765,736.0 |
| Manpower | Reserve personnel: | 811,000.0 | 2,000,000.0 |
| Manpower | Active personnel: | 1,281,900.0 | 771,000.0 |
| Military expenditures | Military budget: | 610.0 | 66.3 |
| Military expenditures | Percent of GDP: | 3.1 | 4.3 |
| Navy | Total naval: | 437.0 | 314.0 |
| Navy | Aircraftcarriers: | 20.0 | 1.0 |
| Navy | Corvettes: | 0.0 | 83.0 |
| Navy | Destroyers: | 85.0 | 18.0 |
| Navy | Frigates: | 0.0 | 10.0 |
| Navy | Submarines: | 71.0 | 59.0 |
2 Replies
- Greg_Deckler
Community Champion
It occurs to me that the problem is not the visual but that you need to normalize those numbers. Like:
Normalized = [US] / [RU]
Then put that in a graph. Note, in this circumstance you would not unpivot the last two columns.
