Recent searches

No recent searches

Due Date Met? "Yes" or "No"

image avatar

Travis Rider

Posted Sep 29, 2021

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

0

3

3 comments

Date
    image avatar

    Rob Stack

    Zendesk Documentation Team

    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!

    1

    image avatar

    Travis Rider

    Thanks for the suggestion @...! 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. 

    0

    image avatar

    Travis Rider

    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.

    0

    Please sign in to leave a comment.

    Didn't find what you're looking for?

    New post