Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
Doing a simple line chart.
The x-axis dimension should be Year -> Month-Year -> Date-Month-Year in a drilldown or a cyclical.
The measure should be the count of a filed with respect to the above dimension.
How can this be done?
A sample is attached.
Hi @sqlpuzzle , try doing this in your script :
[Data]:
LOAD Id,
Date(floor(date),'DD MMM YYYY') as date_month_year,
monthname(date) as month_year,
year(date) as year
FROM
data.csv
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);
Hi @sqlpuzzle , try doing this in your script :
[Data]:
LOAD Id,
Date(floor(date),'DD MMM YYYY') as date_month_year,
monthname(date) as month_year,
year(date) as year
FROM
data.csv
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);