Create a histogram

AvecWizard
AvecWizard Member
in Archive

So I already have all the data that I need to create a histogram. As dipicted by this Excel pivot chartHistogramHistogram

 

I am plotting NPS scores for my firm and also against competitors.

 

In excel I would use =frequency(data array, bins array) and then it would sort it into groups and from there I would do my histogram.

 

In Domo I would assume I would use some count function for a different range, but then would that then mean that I need to have distinct beast mode calculated values for each bin and each competitor?

 

Has someone solved for this?

 

Can anyone help?

 

Thanks

Comments

  • hrh514
    hrh514 Domo Employee

    Hi AvecWizard,

     

    Thank you so much for reaching out. Our histogram chart type only supports one series at a time currently. So, in this situation, this would have to be 3 separate cards. Here is more information on powering up Histograms

     

    http://knowledge.domo.com?cid=histogram

     

    If you ultimately want to keep your data grouped in one card for easier comparisons, you might want to check out the grouped bar chart. You can have multiple series here, but you may need to create your own histogram buckets using a data flow before creating the card. 

     

    Thank you for the suggestion, however, allowing histogram charts to have multiple series is a great idea! Please visit the Dojo Ideas Exchange http://dojo.domo.com/t5/Ideas-Exchange-suggest-and-vote/idb-p/Ideas. You can search existing ideas and then vote for it if it matches what you have in mind. If you cannot find it, please create a new Idea which can then be voted on by your fellow Dojo members by clicking the white arrow next to the idea.

     

    Thank you,

    hrh514

     

  • AvecWizard
    AvecWizard Member

    Thanks hrh514,

     

    I showed our Domo consultant what I was trying to do in excel and with a couple of data transformations using the beast calculation mode (one to define the bins and the other to define the sort order of the bins) I now have a perfect replication of what I need (actually better as I can filter by date more easily)  Note the pictures below have different data channels

     

    Domo Histogram (all)Domo Histogram (all)Excel Pivot TableExcel Pivot Table

     

    What would then be spectacular would be a play button that I can add data through time to see how things are changing over time...as provided by the late great Hans Rosling as shown in the link below

     

    http://www.gapminder.org/tools/#_locale_id=en;&chart-type=bubbles   

     

    Thanks,

     

    Bob

  • user05816
    user05816 Member

    Domo support,

     

    Please add Data-labels for Histogram charts, there is no option to add it in "Properties"

     

    Kindly add it as soon as possible.

  • user02143
    user02143 Member

    hi, would you please share the beast calculation, I am trying to design something like this.

This discussion has been closed.

Categories