4 Replies Latest reply on Apr 25, 2016 7:28 AM by Julio Moyano

    two parameters hours start hours end

    Julio Moyano

      Hi everyone,

       

      I have two variables "start hour" and "end hour". I want to filter with this variables.

       

      For instance, I need to chose only cases between 21:00 PM to 22:30 PM

       

      I have built two parameters ("Start hour" and "End hour") but I do not know how can filter when I have only "start hour" and "end hour"

       

      can I help me?

        • 1. Re: two parameters hours start hours end
          Sankarmagesh Rajan

          Hi Julio,

           

          first create start hour and end hour sets and add only relevant hours.

           

          Create start and end calculation.

          Refer start date and end date.

          Re: how to display the data in Range of Dates

          Thanks

          sankar

          • 2. Re: two parameters hours start hours end
            Julio Moyano

            Thank you Sankar

             

            I didn´t understand. I am working with only "start hour" and "end hour", I will like making filter to range hours:minute because I need to know ¿how many minute exists in this range?

             

            When I read "Re: how to display the data in Range of DatesThere is a "date" variable, but I don't have this variable

             

            I am sending file with examples:

             

            Date    Channel    Minute    Start    End

            01-01-2014    TNac    8    00:00    00:08

            01-01-2014    Chv    12    00:00    00:12

            01-01-2014    TNac    29    00:00    00:29

            01-01-2014    TNac    70    00:00    01:10

            01-01-2014    Mega    1    00:00    00:01

            01-01-2014    Chv      1    00:00    00:01

            01-01-2014    TNac    1    00:00    00:01

            01-01-2014    TNac    1    00:00    00:01

            01-01-2014    TNac    1    00:00    00:01

            01-01-2014    TNac    1    00:00    00:01

            01-01-2014    TNac    1    00:00    00:01

            01-01-2014    TNac    4    00:00    00:04

            01-01-2014    TNac    9    00:00    00:09

            01-01-2014    TNac    9    00:00    00:09

            01-01-2014    TNac    11    00:00    00:11

            01-01-2014    Canal 13    11    00:00    00:11

             

             

            thank you!

             

             

            julio

            • 3. Re: two parameters hours start hours end
              Sankarmagesh Rajan

              Hi Julio,

               

              looking for minutes

              Create datediff('minute',[start hour][end hour])

               

              Thanks

              sankar

              • 4. Re: two parameters hours start hours end
                Julio Moyano

                Thanks Sankar,

                 

                I need to filter minute between different time. For instance: 00:00 to 00:04 then I will need to sum of minute on the range and cross with other variable.

                 

                This is a examples because I am working with 20 million register like this and I need to filter to many hours range. for instance: 20:00 to 21:30; 18:05 to 19:10, etc.

                 

                 

                I want filter one to one different range hours

                 

                regards