Ok, Couple of Suggestions
- Join your data
- Create Initial View with that
- Let's know then where are you Stuck
- Paste a workbook to Help you.
In this workbook I can get to the point of adding 24 hours where needed if Job ID is on the column. However, I need everything based on date. So basically I need to perform calculations using each individual row/job ID but display it based on date when it comes to using count(missed)/count(total) for that day. In the attached workbook missed jobs and total jobs are coming up as the same so the percentage is just 0.
Note in the real data there are many more lines and I cannot have tableau even use Job ID as a column entry because there are too many unique options. In this smaller example is can be seen though.
End Goal: once the 24 hour correction is added to the appropriate rows in sheet one, then I would like to count how many jobs have elapsed hours>48 and calculate COUNT([jobs over 48])/total jobs for a specified date
Book2.twbx 26.7 KB