Hi,
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.
Please advice.
Rgds,
AbhiD
Hi Abhi,
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.
greetings Peter
Thanks Peter,
will check if that works for me
Rgds,
AbhiD
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.