Hi,
I previously created a table card where I was able to add the beast mode below but when I needed to make an edit I was unable to save as it gave the Unable to Save your card contact your Domo Support Team. Below is the table card I am trying to save:
The beast mode for AVG SLA used. When I delete this beast mode I am able to save once again.
SEC_TO_TIME(AVG(TIME_TO_SEC(TIMEDIFF(`closedDate`,`createdDate`))))
Below is how the data looks. I just want to calculate the difference between Created and Closed dates and displaying it as hours to get the AVG SLA by Ticket Type since I am trying to create a KPI Report which reflects totals and not individual records.
Can someone please help with the beast mode... maybe an alternate way to do this?