Well, that seemed to work except I need the average time to resolution in hh:mm:ss and with DATETIME at the beginning it will not let me average it....
Could you help me with that?
Maybe I have to leave it as a number and then convert it to hh:mm:ss?
This was tricky in excel too, and I had to do the calculation before formatting the numbers in the column.
I did a blog post on this topic this summer, see Formatting Time Durations in Tableau | Drawing with Numbers. Here's the Tableau Public workbook: https://public.tableausoftware.com/profile/jonathan.drummey#!/vizhome/durationformatting/AnyDuration
I am unable to format the average resolution time as hh:mm:ss no matter where I add the formatting in the calculation.
This could be me as I am very new and was actually in training last week but it seemed to stump everyone outside of converting to a string and then back which confused me.