I am trying to create a simple bar chart showing the headcount for the last day of each year. from 2009 to 2018.
For year 2009 to 2017 I want the headcount for the last day of the year, but for 2018 I want the latest headcount.
Attached is the excel sample data.
A null end date means that the employee is still working with the company.
I've tried so many different ways and I'm about ready to give up.
In this case you need to start from pivoting data.
Pivot Data from Columns to Rows
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...