I have a data set (attached) where I'm trying to calculate SLA (Due Date - Time of Offer). Unfortunately, early in the data (the first ~178k entries) the due date are blank. This converts the dimension to a string, and is messing with my count functions.
Does anyone know of the best way to deal with this?
Thanks,
David
David:
I just came across a similar situation where I had to find 'How long it took to resolve a ticket?'. In the system, resolved date is not required and we had nulls. Every case will be different on what should be used for NULL values.
If you can use Due Date same as the Offer Date when Due date is null, then use the following for your calculated field for SLA;
IFNULL([Due Date], [Time of Offer]) - [Time of Offer]
NOTE: When Due Date is null, your SLA will be 0
Hope this helps.
KK Molugu
