Hello! I need help with taking the calculated frequency from two histogram plots (that are filtered differently) to make a new histogram dividing them. I am trying to achieve a failed count divided by a total count in each bin. I have them currently using the same binning scheme (the same start point and width). Or if anyone knows what quicksight calculation the histogram uses is, so that I could put it into a calculated field that would be helpful.
Thanks!
Hi @anyssabc and welcome to the QuickSight community!
To my understanding, histograms normally provide a count of your field and then place them in buckets depending on the step count you choose. It sounds like by your scenario that you’re trying to achieve a ‘failed count’ over ‘total count’, so I would suggest looking in to the countOver function as that allows you to aggregate and account for the various filters.
Let me know if this works for your case or if you have any additional questions
Thanks Brett! This is really close to what I’m looking for 
Could you please explain if building dynamic (as in change according to datasets max and min values) buckets is something I should be able to do within the countOver function or is that something I have to do separately? I am trying to make a histogram within the clustered bar combo chart, so there is no automatic grouping I am aware of.