CountDistinct Response Time in Seconds
Hi
I am trying to produce a graph by month for tickets which have met my Response SLA. I have a Countdistinct already on ID as there are duplicates annoyingly but I have a field Response time in seconds and I want to work out which tickets have <=900 and which have >900.
Response Time in Seconds is my field and ID is my ticket ID.
I tried working with some things on the other posts but I think using this Case Count Distinct it is counting the distinct times as opposed to the IDs? I had two different calculations one with the less than equal then another with greater than,
count(distinct
CASE
WHEN `stats_first_resp_time_in_secs` <= 900 then `id`
END
)
I hope I have given enough info to understand what I am trying to get, I have my month by month graph using Created At and YOY but I cannot get the bar to match the total number of incidents, because I am almost certainly doing that wrong
Best Answer
-
Why do you need Count Distinct?
To categorize your performance you could write
WHEN `stats_first_resp_time_in_secs` <= 900 then 'Under SLA' else 'Over SLA'
ENDthen take Ticket out of the access and do a row count as your aggregate function.
That should answer how many you had under and over SLA.
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0
Answers
-
Why do you need Count Distinct?
To categorize your performance you could write
WHEN `stats_first_resp_time_in_secs` <= 900 then 'Under SLA' else 'Over SLA'
ENDthen take Ticket out of the access and do a row count as your aggregate function.
That should answer how many you had under and over SLA.
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0 -
Would this work the same for strings please?
CASE
WHEN `custom_fields_incident_severity` = 'Severity 5 (Non-Critical Alert or False Alert) ' then 'Non Actionable' else 'Actionable'
ENDIt returns them all as opposed to any Actionables
0
Categories
- All Categories
- 1.4K Product Ideas
- 1.4K Ideas Exchange
- 1.4K Connect
- 1.2K Connectors
- 284 Workbench
- 4 Cloud Amplifier
- 4 Federated
- 2.9K Transform
- 88 SQL DataFlows
- 555 Datasets
- 2.2K Magic ETL
- 3.3K Visualize
- 2.3K Charting
- 566 Beast Mode
- 9 App Studio
- 27 Variables
- 577 Automate
- 140 Apps
- 414 APIs & Domo Developer
- 22 Workflows
- 1 DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 350 Distribute
- 90 Domo Everywhere
- 258 Scheduled Reports
- 2 Software Integrations
- 91 Manage
- 88 Governance & Security
- 9 Product Release Questions
- Community Forums
- 42 Getting Started
- 28 Community Member Introductions
- 85 Community Announcements
- 4.8K Archive