Discussion Board for collaboration on QlikView Layout & Visualizations.
Hello to all I have a calculated field as the ratio of total ticket and the total time taken for resolution. the result is an integer that should express in hours to have a mean time to resolution. would know someone help me out For example, the ratio between the total time of taking charge and the total ticket the result is 1.3 tell me someone would know how to express this value in hours? thanks Andrea
What is your expression to get this ratio?
May be your formula will be something like this
Num(Text(Interval(TotalTime, 'h'))) / TotalTicket
TotalTime is total time of taking charge - Difference between 2 datetime.