Does Domo support pyramid charts?

DataSquirrel

Still exploring Domo's chart types, and I'm not finding "pyramid" charts. I think that these were invented, or at the least popularized by, the US Census Bureau. They're commonly used to split some relevant measure by gender and age, like this example from https://www.businessinsider.com.au/demographics-china-2030-vs-japan-2013-2013-11?r=US&IR=T

 

Comparing two pyramid charts

That's the classic use of the chart, but they're pretty spectacular for other purposes as well. Instead of male/female, switch out any other two groups for comparison. It might be countries, regions, facilities - or anything else. For the bars section, you can have whatever categories you like, say components of economic output (primary industries, service, etc.), source of death (hospital-based infection, gunshot, road accidents, cardiac events, etc.) It's pretty limitless.

 

Another use is to show not only relative differences across the dividing line, but degrees of overlap. (This requires another series and a third color.) For example, imagine bars for all of the bird families in Australia and the Lower 48. Many families are in both, some are only in one or the other. You can see at a glance how similar the two regions are, how different, and where. Here's an old mock-up of such a graph linked to a list display. (Sorry, I implemented this all with D3  a year ago but am not on a machine with a working configuration.)

Am I just overlooking pyramid charts, of whatever kind?

 

Thanks!

 

Godiepi

True , There are no pyramid charts but you can turn a single bar chart into a pyramid chart doing a calculation around the series percent of men vs women

 

for example, you can say , case when genre = men then percent of men value - 1

                                           case when genre = wome then percent of women value

 

this will force the percent value for men to display to the left of the zero line and the percent value for women to the right.  Note the percent for men will show always as -20%, -30% ....but as long as your users understand the concept then you'll be fine..  thats my workaround

 

I also suggest to take a look at the Nested bar charts, it works good for that type of comparisons

 

 

 

Godiepi

True , There are no pyramid charts but you can turn a single bar chart into a pyramid chart doing a calculation around the series percent of men vs women

 

for example, you can say , case when genre = men then percent of men value - 1

                                           case when genre = wome then percent of women value

 

this will force the percent value for men to display to the left of the zero line and the percent value for women to the right.  Note the percent for men will show always as -20%, -30% ....but as long as your users understand the concept then you'll be fine..  thats my workaround

 

I also suggest to take a look at the Nested bar charts, it works good for that type of comparisons