Universe Design Question

[Former Member]

Hi,

Please help me with universe design question here.

I have to make line graph

Y- axis time dimension hh24:mi:ss

y - axis Date dimension YYYYMM

The data is like this

progname end_date

abcd 2011/01/23 13:01:20

abcd 2011/01/24 13:30:20

abcd 2011/01/25 13:34:20

abcd 2011/01/23 13:34:20

abcd 2011/01/25 13:45:20

abcd 2011/01/2614:34:20

I need to take time portion of each month and take average of it and that is printed on graph.

Please help me with this one.

[afzal_kar]

Hi,

First of all you need to segregate the data from variable for both the axis . e,g for X-axis you need to take the time part from it by using appropate function like mid . left i with exact length of the object .also similarly we need to take the Y-axis part from it.

Thanks & reagrds

Afzal kar

[Former Member]

Hi Afzal,

I know how to segregate the date part and the time part. I just wonder how I get average of time. The tool seems like can not get average of time as this is not a number.

Then I converted time portion into seconds and did the average but my requirement is to show time on line graph not in seconds.

Please give some idea.

Thanks.

[former_member262009]

Can you try creating an object in designer which has formula sum(time)/count(time) for each month