Quarter of year not currently supported

I am trying to get a numerical value of the quarter and enabled quarter_of_year in the timeframes but it doesn’t show up in the list of available time definitions when creating custom dimensions. Also if I manually type I’m getting this error:


Please tell me this is not expected behaviour?

I don’t see any extract_quarter function in the table calcs, and maybe this should be a feature request.

The good news is that you can compute this easily on a date.

floor((extract_months(${your_date})-1)/3) + 1

This worked for me.

Support has confirmed it’s not currently supported in Custom Dimensions