Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How do I create an expression to take the date column and break it up by quarters. For example 1/1/2016 to 3/31/2016 = 2016Q1
Thank you!
May be create it in your master calendar script:
LOAD Date,
Year,
Month,
Year&'Q'&Ceil(Month(DateField)/3) as YearQuarter