1 Reply Latest reply: Oct 24, 2012 3:24 PM by whiteline _ RSS

    IntervalMatch issue

      Hi guys, I got a small but important problem when plotting my graph

       

      Here is my loading script

       

      TimeInMinutes:

      LOAD * INLINE [

          MinutesStart, MinutesEnd

          00:00:00, 00:14:59

          00:15:00, 00:29:59

          00:30:00, 00:44:59

          00:45:00, 00:59:59

          01:00:00, 01:14:59

          01:15:00, 01:29:59

          01:30:00, 01:44:59

          01:45:00, 01:59:59

          02:00:00, 02:14:59

          02:15:00, 02:29:59

          02:30:00, 02:44:59

          02:45:00, 02:59:59

          03:00:00, 03:14:59

          03:15:00, 03:29:59

          03:30:00, 03:44:59

          03:45:00, 03:59:59

          04:00:00, 11:59:59

      ];

       

      LOAD CNTR_N_F,

           TIME_C_F,

           START_DT,

      FROM

      [Output Result.xls]

      (biff, embedded labels, table is Sheet1$);

       

      Event_Start_Diff_Table:

      IntervalMatch (TIME_C_F) LOAD MinutesStart as Start1, MinutesEnd as End1 Resident TimeInMinutes;

      ---------------------------------------------------------------------------------------------------------

      Basically, the table TimeInMinutes is the bucket. IntervalMatch is used to throw 'TIME_C_F' into the respective bucket in TimeInMinutes.

       

      Dimension = Start1

      Expression = Count(TIME_C_F)

       

      My problem is that if there is no records that falls into 03:30:00, 03:44:59, it will not display the particular column at all.

       

      I already tried
      (1) Unchecked 'Suppress Zero-Values' and 'Suppress Missing' under 'Presentation'

      (2) Checked 'Show all values' under 'Dimension'

      but all doesn't work.

       

      The graph below is the graph I am getting now.  Any help will be appreciated.