Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good day I've had this problem before but I cant seem to resolve it
I have a graph which needs to reflect a time series within the PaidDate column ! !@ ! !@, but the other two graphs don't display a time series for some reason please see code below. I already verified the spreadsheets and the columns are saved as dates. The last two sheets that have been included in the app don' ! !t display in the time time series it just a total of them at the end of the graph
Directory;
Pri:
LOAD EventName,
Description,
personid,
dateofbirth,
idnumber,
PassportNo,
Surname,
Firstnames,
EntryStatus,
GenderDesc,
email,
cellno,
Prefix,
EventNo,
Starttime,
GroupDescription,
GroupName,
RacePackBarcode,
Age,
PaidDate,
FROM
[CC NC Data 20161018.xlsx]
(ooxml, embedded labels, table is [NC Data]);
Directory;
Concatenate(Pri)
LOAD EventName,
Description,
personid,
dateofbirth,
ID,
Passport,
Surname,
Firstnames,
EntryStatus,
GenderDesc,
email,
cellno,
Prefix,
EventNo,
Starttime,
RacePackBarcode,
Age,
PaidDate,
FROM
[MTB NC Data 20161101.xlsx]
(ooxml, embedded labels, table is Sheet1);
Directory;
Concatenate(Pri)
LOAD EventName,
Description,
personid,
surname,
firstnames,
parentcellno,
GenderDesc,
email,
cellno,
EventNo,
Prefix,
Starttime,
Age,
PaidDate,
[5372Jetline Action Photo]
FROM
[KIDSALL 20161116.xlsx]
(ooxml, embedded labels, table is Sheet1);
Directory;
Concatenate(Pri)
LOAD EventName,
personid,
surname,
firstnames,
GenderDesc,
email,
cellno,
EventNo,
Prefix,
Starttime,
Category,
Age,
PaidDate,
[5483Jetline Action Photo]
FROM
[10KM FFRALL 20161116.xlsx]
(ooxml, embedded labels, table is Sheet1);
Mas_Cal:
LOAD
Date(PaidDate) as PaidDate,
Year(PaidDate) as Year,
'Q' & Ceil(Month(PaidDate)/3) as Quarter,
Month(PaidDate) as Month,
Day(PaidDate) as Day,
Week(PaidDate) as Week;
LOAD
Date(MinDate + Iterno() -1) as PaidDate
While(MinDate + Iterno() -1)<=Num(MaxDate);
LOAD
Min(PaidDate) as MinDate,
Max(PaidDate) as MaxDate
Resident Pri;
Primedia:
NoConcatenate
load*
resident Pri;
drop table Pri;
please see image of the graph:
Accepted Solutions
I do not know how it works in the spreadsheets, but it looks like it really does not have dates for these events.
I do not know how it works in the spreadsheets, but it looks like it really does not have dates for these events.