Hello there Zendesk Community!
Using the following article I was able to create the due date delivery calculation in Explore: Explore recipe: Due date performance report (Thanks Zendesk team!)
The results of due date delivery calculation show the number of days between due date and the ticket solved day. From the article there is also color formatting to show if the due date was met.
I received a request to show a simple "yes" or "no" if the due date was met. After a bit of research, it seems like it would be best to create an additional calculation leveraging the IF THEN ELSE functions and the Due Date Delivery calculation created from the first article listed.
I've created the following standard calculation but when added to a query no results are shown from the metric, it's simply blank on each row.
I've tried using the "compute separately" option but that did not change the result.
Thanks for taking a look! Any suggestions on how to make this work would be appreciated. :)
Please sign in to leave a comment.