How to use: Events Industry & UN SDG Dashboard
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.
 |
Tip: Create a radar chart in DS using built-in area charts
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...
Hi, I've just seen your updated version (which looks great by the way) and I saw you added a button to toggle between metrics. How did you do this please?
ReplyDeleteHello, thanks for your interest! I used the optional metrics feature to enable the toggle. Here's the Data Studio Help Centre Article on it - https://support.google.com/datastudio/answer/9484925?hl=en
DeleteThankyou so much. I must have somehow missed this feature. Very useful.
DeleteBy the way the sunshine hours one is fantastic. Can't wait for you to publish this. Creating these is beyond me so rely on clever people like you to make them.
Thanks again and keep up the great work your doing