neigette's blog

For this week's Makeover Monday, I created a dashboard to better explore the data set.  Here's a video highlighting how to take advantage of all the filters in the dashboard. 

For this week's Makeover Monday , I made a 4 sided radar chart in Data Studio (DS) with the built in area chart. Note: This method works well for 4 sided radar charts but may not work with more variables due to limitations within Data Studio 1. Data Preparation Date for X values An area chart in DS requires a date for the X axis and a metric for the Y axis. Since I wanted to put Spring/Fall on the Y Axis and Winter/Summer on the X axis, I had to convert the Spring/Fall percentages to dates. I did this by choosing Jan 1 2019 (an arbitrary date) to be "0" and added/subtracted by the percentage point to get the final date values. Use a top and bottom area chart My area chart is actually composed of two area charts - one for the top and bottom. The reason for this is because DS doesn't handle negative Y values well and the background colour gets affected. You'll get something like Figure 1 if you use a negative Y value and it would be a hassle to fix the ba