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.
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?
Hello, 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
Thankyou so much. I must have somehow missed this feature. Very useful. By 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
Flossing was not a habit engrained in me as a child and it's taken many years before I could make it one. Originally, I had tried marking my progress every day similar to what's suggested by the X effect. Unfortunately, I couldn't keep steady progress for longer than a month, especially after January when my resolutions faded. I was finally able to build a stronger habit by making two changes. 1) [Make it simple and less of a chore] Placing the floss in my shower so I could save time and effort. Previously, I flossed right before brushing my teeth but often skipped it because it felt like a tedious step. 2) [Find a method that increases your motivation] Changing up my scorecard to use stamps instead of drawing a pattern or highlighting. The stamps gave me extra motivation as they had a cute design and made me happy to see :) In the end, after 6 months of the "revised" system, I was able to build up the habit and no longer needed the scorecard to keep track. ...
Earlier this year, I created one of my first Makeover Mondays on Spacewalks . This post walks through my data preparation steps and considerations I made while creating the visualization. Preparing the data set 1. Examine the data set for completeness I sorted each column to find missing data. The Spacewalkers column had some "n/a" fields so I filled in these values manually. 2. Add extra information to data set I wanted to add the nationalities of the Spacewalkers and countries of the spacesuits to the data set. For the nationalities, I used a vlookup to append the data based on the name. However, I did have to be careful about different name spellings used in the data set compared to Wikipedia . As for the spacesuits used in a spacewalk - I entered this manually based on the footnote symbols in Wikipedia . American spacesuits and Russian spacesuits were used depending on where the mission took place. 3. Final check I recreated the ori...
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