My boss has asked me to analyze the demographical changes across time at my company. I have three variables (among others) that I'm trying to create a visualization for: Hire Date, End Date, ethnicity
What I'd like to do is show how the percentage of ethinicities have changed over time (say, in 1999 our company had 14% Asian-Americans, and today it's gone up to 20%). I can create a calculated field for percentages.
Hi Nathan! Do you have the flexibility to reshape your data? If you can create a data set that has either one record per employee per year or that has a record for when the employee was hired and one for when he left, then this will be a lot easier to do.