Boxplot & Histogram Charts

CesarSancho
CesarSancho Member
in Charting

Hello

I am just reopening an old issue reported here ( https://community-forums.domo.com/main/discussion/19106/boxplot-histogram-charts ) and closed some years ago:

The current limitation of 100k records for boxplots and 25k records for histograms makes those visualizations useless when dealing with sizable data, which is what these are meant to be for. The "Not all the data is shown" warning is appearing as soon as the source data passes those limits, making the cards dangerously misleading.

I can easily produce a table with grouped data showing min and max for each group, even if the data behind as some million rows. I'd expect boxplots not to be much more complex than that; just replacing those "min" and "max" with quantile metrics, Domo can produce all the math needed to draw the boxplot.

In some thread it was suggested to precalculate those quantile metrics in a previous ETL, either though SQL functions or with python or R code. This solves the problem for a static snapshot of data, but it lacks all the flexibility of interactive Domo filtering. At the end of the day, I don't need Domo to manipulate a static photo of my data, I want Domo to give final users all the analytical power to drill the data.

Answers

Categories