In my work I have a lot of high throughput omics data that gets stored in sqlite. I would be looking for something like this to quickly check the distribution of values in a column. Quick and dirty R example from a column that has a large number of measurement values around somewhat centered around 0.

Histogram

Density

Could you not create a view based on the count?

So looking at a table of hotel bookings, most people stay 1 night .. tailing off as the nights increase .. apart from 14 nights (which is expected)

You should be able to point the plot at this view?

Generally a good idea, just not very practical for floats/doubles (e.g. see example above, approx 8k unique values, hence the binning/density calculation). In the end, I can do extensive plotting in R; I just thought it would be awesome to have a quick look where you don't have to define own bins etc.