Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a format like 17/12/2012 19:35:38 hours, i want only Month in bar chart.
Hi Vamsi,
Please try this and just pick the field for your dimension.
OUTPUT:
LOAD
*
,Date(Floor(Timestamp#(DATEFIELD, 'DD-MM-YYYY hh:mm:ss')), 'DD/MM/YYFYY') AS NewDate
,Month(Floor(Timestamp#(DATEFIELD, 'DD-MM-YYYY hh:mm:ss'))) AS JustMonth
Resident TableName
;
Best Regards,
Gabriel