DataViz.ro, Tableau

Current date progress bar in Tableau

aprilie 4, 2019

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:

Strava Progress Bar

 

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

data excel

2. Create a today calculated field in order to control the reference date and for testing

today tableau

3. Create a new calculated field in order to get the current year and put that into the filters shelf

filter tableau

4. Create a calculated field that counts the days of the year

count dates tableau

5. Create a calculated field that counts how many days have passed from the beginning of the year

count days tableau

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

Final desktop tableau

 

 

You Might Also Like

No Comments

Leave a Reply