2 Replies Latest reply on Dec 21, 2016 3:24 AM by gyani anand

    Activity map

    gyani anand

      Activity map

       

      i am stuck in a critical situation

      i am trying to develop an activity map with the following data

          

      examid

      examstarttimeutc

      examendtimeutc

      examduration

      537935_2016-05-02_02:30:38

      5/2/2016 2:30

      5/2/2016 3:32

      3720

      537935_2016-05-02_03:54:35

      5/2/2016 3:54

      5/2/2016 5:36

      6120

      537935_2016-05-02_05:39:26

      5/2/2016 5:39

      5/2/2016 5:39

      0

      537935_2016-05-02_05:51:52

      5/2/2016 5:51

      5/2/2016 6:55

      3840

      41455910_2016-05-02_07:14:46

      5/2/2016 7:14

      5/2/2016 7:22

      480

      537935_2016-05-02_07:19:34

      5/2/2016 7:19

      5/2/2016 9:37

      8280

      41455910_2016-05-02_07:32:15

      5/2/2016 7:32

      5/2/2016 9:25

      6780

      54912052_2016-05-02_08:28:56

      5/2/2016 8:28

      5/2/2016 9:52

      5040

      537935_2016-05-02_09:38:47

      5/2/2016 9:38

      5/2/2016 14:04

      15960

      41455910_2016-05-02_09:56:44

      5/2/2016 9:56

      5/2/2016 9:56

      0

      54912052_2016-05-02_10:07:04

      5/2/2016 10:07

      5/2/2016 11:01

      3240

      41455910_2016-05-02_10:08:47

      5/2/2016 10:08

      5/2/2016 11:39

      5460

      54912052_2016-05-02_12:10:24

      5/2/2016 12:10

      5/2/2016 12:37

      1620

      41455910_2016-05-02_12:26:53

      5/2/2016 12:26

      5/2/2016 13:48

      4920

      54912052_2016-05-02_12:38:46

      5/2/2016 12:38

      5/2/2016 13:49

      4260

      41455910_2016-05-02_14:18:30

      5/2/2016 14:18

      5/2/2016 16:24

      7560

      54912052_2016-05-02_14:37:19

      5/2/2016 14:37

      5/2/2016 15:26

      2940

      54912052_2016-05-02_16:21:28

      5/2/2016 16:21

      5/2/2016 16:21

      0

      54912052_2016-05-02_16:21:38

      5/2/2016 16:21

      5/2/2016 18:04

      6180

       

       

      the graph which i have to looks  as below

       

       

      as per the requirement  count of exam id should include all exams that are running at that specific minute

       

      for eg consider the below data set

       

                        examstarttimeutc   examendtimeutc
      5/2/2016 7:195/2/2016 9:37
      5/2/2016 7:325/2/2016 9:25
      5/2/2016 8:285/2/2016 9:52

      so when i plot the graph at 8:28  the count should be 3

      as the above two exam are also active at 8:32

      basically we have to plot total no active exam at every minute

       

      kindly help