Hi all,
Facing following problem in a Crosstab report.
Report shows following data,
Alerts - Rows
Weeks - columns
Measure - Alert Count & Open Duration.
Open Duration is calculated in model and a calculated Query Item is created by subtracting 2 date/time values.
The dataype of this in Framework manager is "time Interval".
In Reportnet, we pull Open Duration from model and put it in measures area.
when I run the above report,
If my time interval is 21 03:19:43:000
The measure is shown as 33,602,000
How can I show the this value as xx days, yy hrs, zz minutes in Report???
I tried formatting the data in Reportnet it didnt work.
Since the value reprasents the time diff in milliseconds... I tried calculating days, hrs and mins from it but for that
if i do (33,602,000 ie,OpenDuration)/1000 to get secs in reportnet Item, I get result as 1.
I am clueless on this and struggling to get any solution.
Pls pls Help me!!!!
Need this ASAP!
Thanks in advance
Sharu