Histograms in Looker

Looker Q&A Looker
21

+1 with a strong desire for histograms! I’d love to use Looker for more EDA but the lack of histograms makes it cumbersome.

22

+1 for histograms

23

+1 for histograms

24

+1 on histograms!

Important to be able to set a lower and upper bound and bin size. Ideally we should be able to histogram on the complete data, and not only on the visible rows.

1 Like
25
  • 1 for histogramss
26

+1 for histograms without having to make a tier dimension.

27

Hey patient Lookers,

Histograms are here! We now have a custom viz (built by Looker) available in the marketplace to install:

Just go to: https://.looker.com/marketplace/view/viz-histogram

You can see the README here: https://github.com/llooker/viz-histogram-marketplace/blob/master/README.md

Let us know what you think, or hey— make a pull request if you have any tweaks. It’s open source
:grinning:
.

2 Likes
28

The 5,000 row limit makes this not very useful for us, I would love to see a histogram visualization that handles aggregating arbitrarily large datasets, similar to what you can do with tiles in a map chart.

In fact there is a whole category of visualizations of distributions (histograms, density plots, heatmaps, scatterplots, etc) which would be really great to have as custom visualizations

29

Thanks for the add. I think this should be available without install a viz since making a histogram is one of the first things you do when exploring a dataset. The 5000 row limitation is also a limitation that would be very helpful to overcome.

I’ll add that when I first switched to simple_histogram in the viz settings, the default color was white so the whole thing was invisible. I thought it wasn’t working until I played around with the settings.

30

Thanks for this, I’d like to use the plugin but I am having issues setting it up. I’ve added a manifest file with the following remote dependency block and updated dependencies but no histogram option has appeared. Do you know what I am missing?

remote_dependency: viz_histogram {
  url: "https://github.com/looker-open-source/viz-histogram-marketplace.git"
  ref: "master"
}
31

I use looker studio for my self, and I’d love to be able to add a histogram with the normal distribution to my report: https://lookerstudio.google.com/reporting/6a1713bb-a812-4cf9-86d4-b7524942184d/page/EM5NF?s=r5TSqtKNzcs

It looks at the weekly percentage change of 6000 stocks for the past 730 days.

I’ll probably calculate the mean and sigma in Google sheets and then just add the values in a table.