Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
I've got a table with "StartTime" as dimension and "if(below(startTime)>$(Time),SignalDescription,null()) as expression.
the outout is like:
02/12/2011 15:31:13
02/12/2011 15:32:02
02/12/2011 15:32:34
02/12/2011 15:33:00
02/12/2011 15:33:07
02/12/2011 15:33:47 SignalDescr1
02/12/2011 15:34:01 SignalDescr2
02/12/2011 15:34:24
02/12/2011 15:35:16
02/12/2011 15:36:10
02/12/2011 15:36:33
02/12/2011 15:39:02
02/12/2011 15:39:55
02/12/2011 15:40:08 SignalDescr3
02/12/2011 15:40:16 SignalDescr4
but i want:
02/12/2011 15:33:47 SignalDescr1
02/12/2011 15:34:01 SignalDescr2
02/12/2011 15:40:08 SignalDescr3
02/12/2011 15:40:16 SignalDescr4
Have you got any suggestions?
Regards
-Davide
Message was edited by: maha1985
with above o below function i must use only 1 dimension