Hi all I need help with a count if expression. I’m creating a dashboard for help desk incident tickets to show how long it took to close the ticket. I’ll have 5 different columns for different timeframes but once I get one expression working I can replicate the others. I’m trying to count the number of incidents that took 24 hours or more to close. I have a time to close calculated field formatted “hh:mm”. If the incident didn’t close in 24 or more hours I want it to be blank showing nothing. Here is what I have that’s not working: count(if([timetoclose]>=‘24’),distinct [incidentID],[“”])
