Does Domo support pyramid charts?

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 chartsComparing 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.)

sketch.png

Am I just overlooking pyramid charts, of whatever kind?

 

Thanks!

 

Best Answer

  • Godiepi
    Godiepi Coach
    Answer ✓

    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

    Screen Shot 11-01-17 at 11.14 AM.PNG

     

     

     

    Domo Arigato!

    **Say 'Thanks' by clicking the thumbs up in the post that helped you.
    **Please mark the post that solves your problem as 'Accepted Solution'

Answers

  • Godiepi
    Godiepi Coach
    Answer ✓

    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

    Screen Shot 11-01-17 at 11.14 AM.PNG

     

     

     

    Domo Arigato!

    **Say 'Thanks' by clicking the thumbs up in the post that helped you.
    **Please mark the post that solves your problem as 'Accepted Solution'
This discussion has been closed.