IntervalMatch issue

Wed, 24 Oct 2012 09:21:45 GMT

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.

Re: IntervalMatch issue

whiteline — Wed, 24 Oct 2012 19:24:17 GMT

Hi.

You can try to create another expression =1 and make it invisible.