11-23-2015 10:54 PM
I want to create a graph which will be represent average landing times for files, i have a dataset which contains data for each file as below
Module FileName LandingTime
A A_F1.csv 22:00:05
A A_F2.csv 01:15:37
B B_F1.csv 11:13:05
B B_F2.csv 11:40:34
i wish to have a line graph which will represent the Modules on X-axis whereas the Average Landing times for each module on Y-Axis
I tried to do the same but VA graph does not allow to add the LandingTime as a measure.
11-24-2015 01:22 AM
I would advice you to start using Industry hours definition. (Almost a standard in industry time registration)
This means that you recalculate the time into a number that can be summed.
Example 1:15:37 would be 1.00 hour + 15/60 minutes fraction --> 1.2500000 (Leaving seconds out.)
11:13:05 --> 11.216666
Now you have a number that can be summed, averaged etc.
This should also fit into a graph showing the average using a aggregated measure.
Maybe this works out.