Data Not Showing

[nikhilgarg]

Hey,

My data is not showing in the staright table.

Please help.

[its_anandrjs · Accepted solution]

Use this expression

Interval( -(Date([Event Start Time]) - Date([Event End Time])))  as Diff_DownTime

Regards

Anand

[MK_QSL]

Use something like below in script

LOAD [Event Start Time],

     Date([Event Start Time], 'DD.MM.YYYY') as StartDate,

     [Event End Time],

     Date([Event End Time], 'DD.MM.YYYY') as EndDate,

     Time(Frac(Timestamp([Event Start Time])), 'hh:mm:ss') as StartTime,

     Time(Frac(Timestamp([Event End Time])), 'hh:mm:ss') as EndTime,

     [Event Duration],

     [EventState Type],

     [EventState Information],

     Interval([Event Start Time] - [Event End Time],'hh') as Diff_DownTime