I'mlooking to combine certain data, but my SQL knowledge is lacking to do so...
I've got an employee table:
A table with subtypes:
And I've got time.
Everyday an employee will have a certain subtype. For example:
JAN 2017 week 1:
employee1 subtype 100
employee2 subtype 100
employee3 subtype 100
FEB 2017 week 2:
employee1 subtype 100 (day 1-3)
employee1 subtype 200 (day 4-5)
I need to calculate the percentage of employees that do not have subtype 200 over the selected time period (ideally over the span of 52 weeks).
How can I do this? Thanks a lot for helping!
Could you put together a small excel workbook with 3 tables that mimic your real data enough to make it useful to you and then put into a packaged workbook. 100 rows of data should be enough to allow the community to get our minds together to help.
Packaged workbooks: when, why, how
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...