11 Replies Latest reply on Nov 30, 2016 10:47 AM by khalid norat

    DateDiff Question and Stack Bar Viz Help

    Kevin Sullivan

      In the attached twbx I am have 2 issues:

           1.  My "Segment_Seconds" calculation is not giving me the seconds between start and end timestamps.    DATEDIFF('second',[SEGMENT_START_TMSTP],[SEGMENT_END_TMSTP])

       

           2.  I want to create a visualization that will show by each [TSID] the [Segment_Seconds] by [Value] in the order that they happen.

                     For example:  [TSID] = "0a2868d8-0000-0f46-583d-b52482b30002"

       

                                    Connect           Hold     Connect     Hold     Connect     Wrap

                                         134               228          10           271          113          2

       

                I was thinking stack bars horizontally but every [TSID] has different starts/ends and the [Value] comes in different order most of the time.  Any help or guidance on how to build an impactful view would be appreciated.

       

       

      0a2868d8-0000-0f46-583d-b52482b3000211/29/2016 12:08:35 PM11/29/2016 12:10:49 PMConnectA571881134
      11/29/2016 12:10:49 PM11/29/2016 12:14:37 PMHoldA571881228
      11/29/2016 12:14:37 PM11/29/2016 12:14:47 PMConnectA57188110
      11/29/2016 12:14:47 PM11/29/2016 12:19:18 PMHoldA571881271
      11/29/2016 12:19:18 PM11/29/2016 12:21:11 PMConnectA571881113
      11/29/2016 12:21:11 PM11/29/2016 12:21:13 PMWrapA5718812