Due Date Met? "Yes" or "No" | Community
Skip to main content

Due Date Met? "Yes" or "No"

  • September 29, 2021
  • 3 replies
  • 0 views
T

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. :)

    3 replies

    R
    • Rob21
    • September 29, 2021

    Hi Travis Rider, I think this would work if you created a standard calculated attribute instead of a standard calculated metric using the same formula.

    Then, add your attribute to the Rows or Columns panel in your query. I hope this helps!

      T
      • Travis21
      • Author
      • September 29, 2021

      Thanks for the suggestion @Rob Stack! I switched to a standard calculated attribute and I am now getting results, but the results are all "no".

      I also might have been making the calculation more difficult that it needed to be so I switched it to the following:

      IF (AVG(Due Date Delivery)<1) THEN "Yes" ELSE "No" ENDIF

      However, I'm still getting the same results. I'm wondering if it has to do with the AVG aggregator. 

      T
      • Travis21
      • Author
      • September 29, 2021

      Ah, it looks like it actually has to do with the "computed from" field.

      In Computed from, select the attribute you are using in your query. If you do not select an attribute, the calculation will be measured against the total.

      Now I'm not sure which attribute to compute from.

      Terms & ConditionsCookie settingsAccessibility statement