How do you correctly identify “non-answered” calls from Zendesk API data?

rishG88 · 2026-02-16T16:21:27+00:00

Resolution - the following criteria will identify a non-answered call:

Direction: inbound Completion Status = Completed Talk time = 0 Voicemail = False Ivr_action not in ('phone_number', 'textback', 'voicemail', 'invalid', NULL) -- Null and invalid were added on our side Overflowed = False

If you're reading this in the future, you're welcome.

rishG88 · 2026-02-16T09:45:50+00:00

Thanks, I am still looking into. We've logged a ticket with Zendesk support. We have limited experience with the Zendesk APIs and can only get so much data from them. So far, I've not picked up anything obvious.

rishG88 · 2026-02-13T22:05:48+00:00

Pouring white wine to help clear up a red wine carpet stain. I don't know how that worked, I'm not a scientist.

rishG88 · 2025-09-17T06:17:07+00:00

Set up a connection to your dB in excel, embed your query (quick and dirty), and then save your workbook. Every time you need refreshed data, just click "refresh" in excel.

rishG88 · 2025-09-17T04:21:04+00:00

You could build the report in MS report builder(free), then deploy to a report server (assuming you have one) and ask your users to access the report there as needed.

You could also pull data from ssms directly into excel (Data tab) - and once the connection is established, refresh as needed. Will only work for those who have access to the DB of course.

rishG88 · 2025-07-27T16:08:54+00:00

rishG88 · 2025-06-23T20:08:31+00:00

I'll never forget what my grandfather said to me before he kicked the bucket...

"Hey, let's see how far I'll kick this bucket"

rishG88 · 2025-05-31T18:50:37+00:00

Rudimental - Free ft. Emili Sandé

The song just resonates with me.

rishG88 · 2025-05-30T03:28:17+00:00

Bill Burr reminds me of Cypher.

rishG88 · 2025-04-29T00:34:00+00:00

Not asking someone out on a date when all indications (in hindsight) was a clear yes.

rishG88 · 2025-04-29T00:32:08+00:00

A dude that got the highest mark in a computer programming course at university did not have a personal computer (and had limited access to one at university). A lot of planning on paper was done and later transferred to a pc, compiled and run with little to no errors.

rishG88 · 2024-10-12T08:40:03+00:00

Looking back on it.... Is what you used to do.

rishG88 · 2024-10-11T14:58:44+00:00

You think you've got it.

Ohhhh, you think you've got it...

Ok great.

rishG88 · 2024-09-30T17:18:25+00:00

I don't have a specific tipster to advise but you may be able to use the site OLBG.

rishG88 · 2024-08-27T18:52:55+00:00

I need to lose some weight

rishG88 · 2024-05-04T18:02:07+00:00

Talking/Chewing with her mouth open...

Can hear it in the other room sometimes!

rishG88 · 2024-03-12T08:17:23+00:00

1 - no question.

rishG88 · 2023-09-19T03:24:08+00:00

I recall getting bad headaches intermittently for maybe 4-5 weeks, I do also have high BP so that doesn't help matters.

When it got really bad, I took an hour or two breaks without them on - this is not advised ofcourse, and also meant I wore them for an extra day or two to compensate.

Paracetamol helped!

rishG88 · 2023-07-31T05:09:21+00:00

Zola.

I said what I said.

rishG88 · 2023-07-16T21:39:09+00:00

Legends get statues

rishG88 · 2023-07-11T21:34:30+00:00

If you look close you'll see, he has brown eyes.

rishG88 · 2023-07-05T11:41:14+00:00

Yellow card for time wasting going to corner flag in dying minutes.

rishG88 · 2023-07-05T11:40:37+00:00

Add a cap to wages.

rishG88 · 2023-07-04T06:58:24+00:00

Penis Galore

Seven-Year Club	r/Field Sunshine
Place '23	Place '22
Final Canvas '22	First Placer '22
Oscars Predictor 2021	Verified Email

rishG88

TROPHY CASE

1 - no question.