Where this idea?
Today I was checking my Strava account and I got an idea of a data visualization that can be done in Tableau.
So, from here my idea of a daily status bar has been started. A status bar that can be used in target reports (daily, weekly or monthly) and it shows you how many days have passed from the beginning of the year by today.
Here is the original chart from Strava:
And this is the Tableau version (with additional details)
How this has been done
1. Create an Excel file with all of the dates from the beginning of the year and add it as a data source
2. Create a today calculated field in order to control the reference date and for testing
3. Create a new calculated field in order to get the current year and put that into the filters shelf
4. Create a calculated field that counts the days of the year
5. Create a calculated field that counts how many days have passed from the beginning of the year
6. Add them both on Columns
7. Mark them as Dual Axis
8. Then use the Synchronize Axis option to align the axis
9. Mark the CountDates measure as a bar chart
10. Mark the TodayNumber as a Gantt chart
11. And then just align the Labels as per your preferences
… and that should be the final screen
