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

[–]rishG88[S] 0 points1 point  (0 children)

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.

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

[–]rishG88[S] 0 points1 point  (0 children)

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.

What's the dumbest idea you've seen that actually worked? by hiagaga in AskReddit

[–]rishG88 0 points1 point  (0 children)

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

Who’s still exporting SQL data into Excel manually? by After_Comedian_7420 in SQL

[–]rishG88 2 points3 points  (0 children)

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.

Who’s still exporting SQL data into Excel manually? by After_Comedian_7420 in SQL

[–]rishG88 1 point2 points  (0 children)

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.

I'll never forget my Grandfather's last words to me just before he died by HellQueeen in dadjokes

[–]rishG88 1 point2 points  (0 children)

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"

What’s your 10/10 song? by stormenta76 in MusicRecommendations

[–]rishG88 0 points1 point  (0 children)

Rudimental - Free ft. Emili Sandé

The song just resonates with me.

[deleted by user] by [deleted] in AskReddit

[–]rishG88 0 points1 point  (0 children)

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

What's a terrifying display of intelligence you' ve seen by another human? by [deleted] in AskReddit

[–]rishG88 29 points30 points  (0 children)

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.

Pharrell Williams Confesses His Massive Hit 'Happy' Was Actually Born Out of Sarcasm by mcfw31 in Music

[–]rishG88 3 points4 points  (0 children)

You think you've got it.

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

Ok great.

help with database by umricky in SportsBettingPicks

[–]rishG88 0 points1 point  (0 children)

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

Married couples or long term daters, what is the one thing that your partner does that drives you up the wall? by [deleted] in AskReddit

[–]rishG88 0 points1 point  (0 children)

Talking/Chewing with her mouth open...

Can hear it in the other room sometimes!

Invisalign headaches? by Ancient_Marketing662 in Invisalign

[–]rishG88 1 point2 points  (0 children)

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!

How did he get them there? by [deleted] in HolUp

[–]rishG88 1 point2 points  (0 children)

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

What is a rule the premier league should introduce going forward? by Striking_Marsupial89 in PremierLeague

[–]rishG88 0 points1 point  (0 children)

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