2 Replies Latest reply on Dec 20, 2016 3:04 AM by gyani anand

    Activity map

    gyani anand

      hello community,

       

      I have a challenging situation for u people

       

       

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

          

      examidexamstarttimeutcexamendtimeutcexamduration
      537935_2016-05-02_02:30:385/2/2016 2:305/2/2016 3:323720
      537935_2016-05-02_03:54:355/2/2016 3:545/2/2016 5:366120
      537935_2016-05-02_05:39:265/2/2016 5:395/2/2016 5:390
      537935_2016-05-02_05:51:525/2/2016 5:515/2/2016 6:553840
      41455910_2016-05-02_07:14:465/2/2016 7:145/2/2016 7:22480
      537935_2016-05-02_07:19:345/2/2016 7:195/2/2016 9:378280
      41455910_2016-05-02_07:32:155/2/2016 7:325/2/2016 9:256780
      54912052_2016-05-02_08:28:565/2/2016 8:285/2/2016 9:525040
      537935_2016-05-02_09:38:475/2/2016 9:385/2/2016 14:0415960
      41455910_2016-05-02_09:56:445/2/2016 9:565/2/2016 9:560
      54912052_2016-05-02_10:07:045/2/2016 10:075/2/2016 11:013240
      41455910_2016-05-02_10:08:475/2/2016 10:085/2/2016 11:395460
      54912052_2016-05-02_12:10:245/2/2016 12:105/2/2016 12:371620
      41455910_2016-05-02_12:26:535/2/2016 12:265/2/2016 13:484920
      54912052_2016-05-02_12:38:465/2/2016 12:385/2/2016 13:494260
      41455910_2016-05-02_14:18:305/2/2016 14:185/2/2016 16:247560
      54912052_2016-05-02_14:37:195/2/2016 14:375/2/2016 15:262940
      54912052_2016-05-02_16:21:285/2/2016 16:215/2/2016 16:210
      54912052_2016-05-02_16:21:385/2/2016 16:215/2/2016 18:046180

       

       

      the graph which i have to plot  is as below

       

       

      logic to apply

       

      we have to plot count of exam that are active at the given minute

      so as per above graph at 8:28 3 exam are active

       

      kindly help

        • 1. Re: Activity map
          Maciek La

          I am not sure what you are trying to achieve.. something like that?

           

          workbook attached

          • 2. Re: Activity map
            gyani anand

            thanks for reply.

             

            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