To make things easy for importing into Data Studio, the values should be located at the very top of your sheet, in 5 separate columns, i.e.
Next, you need to create a third table that calculate the differences between these metrics, as the differences represent the size of each segment in your box chart. If you want to follow along, you can view the sample sheet here (just make a copy if you want to plug in your own data).Īssuming your data lies in cells A1:A20, first calculate the minimum, maximum, lower quartile, median, upper quartile, and maximum for your data set using the following formulas:Īdd these formulas into a second table, to produce an output like this: We’ll do this in Google Sheets, which you can then add as a data source to your Data Studio report. The first step is to set up your source data. The method for producing this pseudo box chart is as follows. Scroll to the end to see a screenshot of the end result. It won’t look totally standard, but in a pinch can be used as a substitute. Google Data Studio currently doesn’t provide a Box Plot chart type, but you can create something similar using a Stacked Column chart type.
The box plot chart (aka box and whiskers) is a chart to visually display the distribution of a dataset: the maximum, minimum, median, and the range on either side of the median. Shopify, Harvest, Mailchimp, ActiveCampaign, Google Ads, YouTube, etc.) directly into Google Sheets. Check out my API Connector Add-on to easily connect and pull data from thousands of platforms (e.g.
0 kommentar(er)
