I can use a calculation property to figure out the number of days since a ticket was opened so I can see how many days a ticket has been open. This is great! Except… I need to get the average number of days my tickets have been open.
The calculation property is formatted as a date and I can’t get an average on a date property. I need the option to turn this property into a number format. I can’t use a format action in a workflow either because calculated properties can’t be formatted (or date, not sure what the issue is).
Can you either change “time between” calculation properties to be formatted as a number and use the number of days or give us the option to format the property as a number instead of date?