This content has been marked as final. Show 2 replies
I need to calculate AHT for a given business case. Please see the dummy excel data file for reference.
In the excel file AHT = Total Call Time/# of Calls. I cannot use this calculation as it gives me average of average which is incorrect.
So when i create a calculated field in tableau i have converted it to a dimension, Please let me know if this is the correct approach. There are 2 issues and analysis i need help on if this conversion of calculated AHT to dimension in correct:
Any form of visualization would work.
Thanks in advance.