I am trying to create some analytics (KPI) in Excel using a data model. I am having trouble figuring out what combination of events sets a status to OPEN or CLOSED. CLSDDATE and COMPLETED? If they are both NULL is the ticket open?
If anyone knows, I would appreciate the insight
Both are required to determine the closed status. If either field is null then the work order is still Open.