Introduction
Lately I’ve been working with Google Analytics data, so I thought I’d pass on a data set to you! Our data set was created by you the audience – it’s extracted directly from our website analytics.
This week’s challenge focuses on a lot of little things coming together – dashboard design, formatting, and reference lines. The big “aha” moment for me in this challenge is working with duration/time in the format of minutes and seconds, most specifically getting the reference lines to display.
Requirements
- Dashboard Size: 1300px by 1000px
- # of Sheets – up to you
- Create 4 Metrics with Trend lines
- Total Sessions
- Trend weekly, with a weekly average reference line
- Average Session Duration (Session Duration/Sessions)
- Trend weekly, with an overall (aggregate) reference line, this must be formatted in minutes and seconds
- Bounce Rate (Bounces/Sessions)
- Trend weekly, with an overall (total) reference line
- Average Time on Page (Time on Page/(Pageviews – Exits))
- Trend weekly, with an overall (aggregate) reference line, this must be formatted in minutes and seconds
- Colors
- Purple: #7830b6
- Green: #72b966
- Yellow: #f7cc63
- Darker Blue: #628cb9
- Lighter Blue: #58b8ba
- Total Sessions
FYI: Since this is a static data set, I’ve filtered it to 12/29/2019 to 4/10/2021
Dataset
This week uses an export from Google Analytics. You can get it here at data.world
You can see full definitions of data set attributes in the GA Dimensions & Metrics Explorer
Attribute
When you publish your solution on Tableau Public make sure to take the time and include a link to the original inspiration. Also include the hashtag #WOW2021 in your description to make it searchable!
Share
After you finish your workout, share on Twitter using the hashtag #WOW2021 and tag @AnnUJackson, @ItsCandraM, @LukeStanke, @_Lorna_Brown and @HipsterVizNinja
Solution
Interactive
Thanks @AnnUJackson for the challenge.
@AnnUJackson Not quite sure why my previous comment got deleted, but your maketime formulas still contain an error.
Maketime(avgseconds/3600, avgseconds/60, avgseconds%60) would make the hours count double if the dureation is longer than 3600 seconds. Not an issue in your dataset as the outcome is well below 3600 seconds, but as a concept of how to do calculations with time, this is an issue.
To fix this, you can remove the avgseconds/3600 component, or, or you wish to use the formula in that format, you could do Maketime(avgseconds/3600, (avgseconds%3600)/60, avgseconds%60).
Actually maketime(avgseconds) would also work fine.
unable to download dataset