7 Replies Latest reply on Aug 28, 2015 1:59 AM by Rajeev Pandey

    Partitioning Time (day) into custom intervals

    Babar Iftikhar

      Hello Everyone:

       

      I am building analytics on time series data.  I have "Time" as my dimension. And it has a time range of last two months. I want to set time on column shelve, which is easy and I can see time  as YEAR, MONTH, DAY, HOUR etc on X Axis.

       

      The challenge is to define custom partitions to time. i.e. I want that each Day can be divided into custom number of hours e.g. Each day has three intervals of 8 hours each. On X-axis we will have time series distributed as.

      Mon ( 8:00 am --4:00 pm), Tues (8:00---4:00 pm) ..........

       

      Mon ( 12:00 am --7:59 am), Tues (12:00 am---7:59 pm) ..........

      Tues  ( 12:00 am --7:59 am), Tues (12:00 am---7:59 pm) ..........

      Wed  ( 12:00 am --7:59 am), Tues (12:00 am---7:59 pm) ..........

       

      Mon ( 8:00 am --3:59 pm), Tues (8:00 am---3:59 pm) ..........

      Tues ( 8:00 am --3:59 pm), Tues (8:00 am---3:59 pm) ..........

      Wed ( 8:00 am --3:59 pm), Tues (8:00 am---3:59 pm) ..........

       

      Mon ( 4:00 pm --11:59 pm), Tues (4:00 pm---11:59 pm) ..........

      Tues (4:00 pm --11:59 pm), Tues (4:00 pm---11:59 pm) ..........

      Wed ( 4:00 pm --11:59 pm), Tues (4:00 pm---11:59 pm) ..........

       

      Also I can apply filter on the partition I want to do the analysis

      Mon ( 8:00 am --3:59 pm), Tues (8:00 am---3:59 pm) ..........

      Tues ( 8:00 am --3:59 pm), Tues (8:00 am---3:59 pm) ..........

      Wed ( 8:00 am --3:59 pm), Tues (8:00 am---3:59 pm) ..........

       

      Looking for your help

       

      Thanks

      Babar