Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
