Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Need help in displaying the 90 mins as 1h 30m in charts, suppose if the data is in this way
Job Runtime
A 90 mins
B 60 mins
C 75 mins
should display as 1h, 1h 30m, 1h 45m on charts.
Thank you all
krishna
Hi,
Try like this using Interval() in script
Interval(Runtime/60/24, 'hh:mm')
Div(Runtime, 60) & 'h '& Mod(Runtime, 60) & 'm'
Regards,
Jagan.
Try this
table1:
LOAD * INLINE [
Job, Runtime
1, 60 mins
2, 90 mins
3, 75 mins
];
temp:
load div(subfield(Runtime,'mins',1),60) & 'h ' & if(mod(subfield(Runtime,'mins',1),60)<> 0,mod(subfield(Runtime,'mins',1),60) & 'm') as time
resident table1;
Hi
If it is just these 3 values, then
=Pick(Match(myTimeField, 60, 75, 90), '1h', '1h15', '1h30'))
Change the field to the correct name.
HTH
Jonathan
Hi,
Try like this using Interval() in script
Interval(Runtime/60/24, 'hh:mm')
Div(Runtime, 60) & 'h '& Mod(Runtime, 60) & 'm'
Regards,
Jagan.
Thanks Jagan, Finally I got it. There is one more problem where Runtime is 0 mins it is displaying as 0h 0m. I just want to rename this 0h 0m as NA. on chart while displaying
Thank you all once again....
Hi,
Just add one if condition
If(Runtime > 0, Div(Runtime, 60) & 'h '& Mod(Runtime, 60) & 'm', 'NA')
Hope this helps you.
Regards,
Jagan.
Jagan, thanks once again for your prompt reply...it executed beautifully