I am trying to accomplish a chart similar to the visual pasted below. My data does not have a master date so I'm trying to figure out if there a way to derive one in Tableau using a calculated field.
What I want to show is the number of work orders that need to be worked over time, decreasing as they get completed, but still showing the to-be completed as an area chart trending down over time and completed trending up. I have a WO Complete Date field, but that doesn't serve to the WOs without a complete date and still in the queue to be worked.
Does anyone have any tips/tricks on how to do this if you don't have a master date field in your date? I've attached a sample workbook with the data structure.
Thank you for any help/guidance.
Best,
Katelyn
Hello Katelyn,
You can join your data with every possible date, and create a formula to test if the completed on date is less than the new date that was joined in.
if [WO COMP Date] <= [Date] then "Complete" else "Not Complete" END
Hope this helps! See Attached.
Please mark this answer as correct or helpful if it helps solve your question.
Robert Breen
