Showing posts with label WOW. Show all posts
October 13, 2020
#WorkoutWednesday 2020 Week 42: Can you build a Strava Workout Calendar?
BAN
,
bar chart
,
blending
,
calendar
,
dashboard
,
filter
,
strava
,
table calc
,
table calculation
,
text
,
Workout Wednesday
,
WOW
,
WOW2020
No comments
Introduction
When Lorna asked me to be a Community contributor for Workout Wednesday, honestly, I was hesitant since I don’t participate every week. I typically only take on the challenges that I think are most beneficial to me as a teacher. I want to share work that I know the Data Schoolers are likely to use on their placements. Lorna talked me into it (she’s my favorite after all) and I have something pretty straightforward to share with you this week.
I’m a keen triathlete and track all of my activities on Strava. There are some great dashboards and visualizations that help you understand your performance. One of my favorite is the Training Calendar. It gives you an overview of an entire year at once. And that’s what you’ll build for this workout.
Requirements
- Dashboard size: 1680 x 1020
- Max 3 sheets
- Max 1 text box
- Joins are not permitted
- Data model is not permitted
- They MUST be separate data sources.
- No annotations
- No text boxes on the main chart
- No floating objects
- No Level of Detail expressions
- Remove highlighting from anything you can click
- Match formatting and tooltips
- The blue hex code is #0070A0.
- The blue bars on the upper right are the weekly number of hours spent exercising.
- The black bars in the main chart are the daily hours spent exercising.
- Any days when I did not exercise should have zero hours displayed.
- Allow scrolling through the years
Dataset
The two files you need can be downloaded here. REMEMBER: No joins or data modeling!
Attribution
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 #WOW2020 in your description to make it searchable!
Original visualization link to include on Tableau Public - https://public.tableau.com/profile/andy.kriebel#!/vizhome/WOW2020Week42-CanyoucreatedaStravatrainingcalendar/TrainingCalendar
Share
After you finish your workout, share on Twitter using the hashtag #WOW2020 and tag @VizWizBI, @AnnUJackson, @LukeStanke, and @_L orna_Brown.
Solution
September 25, 2020
#WorkoutWednesday 2020 Week 3: Orders by Day and Time
color
,
concatenate
,
date
,
dateparse
,
datetime
,
day of month
,
orders
,
parameter
,
size
,
string
,
time
,
tooltip
,
weekday
,
Workout Wednesday
,
WOW
No comments
As time permits, I'm going back through some of the Workout Wednesday challenges that I've yet to complete. I'm starting with those that will help me most as a teacher to impart what I learn on those that I have the pleasure to train at The Data School.
For week 3, Lorna Brown challenged us to create a viz that shows the number of orders by hour of the day that allows the user to swap between day of the month and weekday.
In her solution, she chose to create two sheets, one for the day of the month and another for weekdays. I didn't know that when I tackled the challenge so I proceeded down the route of doing it all in one sheet. Success!
I did a couple things differently than Lorna:
- I combined the order date and time into a string calculation and then used the DATEPARSE function to make it a date/time field.
- The size of my circles depends on the option selected in the parameter. For day of the month, the size is the number of orders. For weekday, I have them set to a fixed size. I chose to make them a fixed size because otherwise the circles become way too big for the view.
- I used only one sheet.
- I am not showing a tooltip when there are no orders.
My solution is here and below as a gif.
Subscribe to:
Posts
(
Atom
)
