Hi everyone, I’m trying to build a custom analytics dashboard and am having a hard time figuring out how to aggregate a list of data into a single value to display in a text object.
I’ve defined a custom type called ‘Alert’ with fields ‘Triggered Time’ and ‘Claimed Time’. Given a list of alerts, I’d like to calculate Resolved - Claimed time for each item in the list, and then take the average of the list. The final aggregated value should be shown in a text object.
This is the closest that I’ve gotten, but this just computes the difference between the Resolved and Claimed times for a single value:
Is there a way to calculate this for all values and then take the average of them all? It seems like most solutions on this forum involve repeating groups, but I don’t think those will help me here since I’m not looking to actually display any of the intermediate values.