Exploring, modeling, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

SAS VA : Creating graph

Reply
Contributor
Posts: 26

SAS VA : Creating graph

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

 

Regular Contributor
Posts: 173

Re: SAS VA : Creating graph

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

 

Contributor
Posts: 26

Re: SAS VA : Creating graph

Thanks Peter,

will check if that works for me

 

Rgds,

AbhiD

Ask a Question
Discussion stats
  • 2 replies
  • 320 views
  • 0 likes
  • 2 in conversation