Drill Down Line Chart

[sqlpuzzle]

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.

[QFabian · Accepted solution]

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);