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.

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. 

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

Hey Chantal, 

I've used the following article in the past: Setting up a requests-only (tickets-only) help center 

Not sure if it is current but there are some tips in there that might help! Good luck!

Hey Cory!

To hide the CC field I used the following:

$('.form-field.string.optional.request_cc_emails').hide();// Hide CCs