Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Working on the booking analysis and I need a table that shows if booking was continued or cancled like as below.
But what I'm getting is the duplicated variables of rows. For example, C should be continued on the third row not on the fifth row.
Is there a way to fix it over a chart not in the loadscript?
JanRegistered:
load * inline [ ID, IDJan, StayNight, StayMonth, InputMonth
A, A, 3, Jan, 1
B, B,4 , Jan, 1
C, C,2, Feb,1
D, D, 4, Feb, 1
E, E,2, Mar, 1
F, F,3, Mar, 1
G, G, 4, Mar, 1
H, H, 2, Apr, 1];
FebRegistered:
load * inline [ID, IDFeb, StayNight, StayMonth, InputMonth
C, C, 2, Feb , 2
E, E, 2, Mar, 2
F, F, 3, Mar,2
H, H, 2, Apr, 2
I, I, 4, Apr, 2
J, J, 5, Apr, 2
K, K, 1, Apr, 2
L, L, 3, May, 2];
MarRegistered:
load * inline [ ID,IDMar,StayNight, StayMonth, InputMonth
E, E, 2, Mar , 3
F, F, 3, Mar, 3
H, H, 2, Apr, 3
I, I, 4, Apr, 3
K, K, 1, Apr, 3
L, L, 3, May, 3
M, M, 2, May, 3
N, N, 3, May, 3];
AprRegistered:
load * inline [ID, IDApr,StayNight, StayMonth, InputMonth
H, H, 2, Apr, 4
K, K, 1, Apr, 4
L, L, 3, May, 4
N, N, 3, May, 4];
try pivot user measure as only