Quarter Format Issue

Pa11
Participant I

Hi Team,

     I am facing problem with my Quarter value.  In my data set I can see quarter as 2021-01,2021-04,2021-07,2021-10.

    But my requirement is to show case this as 2021-Q1,2021-Q2,2021-Q3 and 2021-Q4.

     I am not able to implement liquid variable with rendered value for Quarter as  implemented for month and week.

Could any one from the group can help me in resolving the issue.

Thanks,

Pavan

0 1 665
1 REPLY 1

Hello Pa1!

I believe creating a separate dimension of type date_quarter is exactly what you are looking for. Something like the following:

  dimension: date_qtr {
type: date_quarter
sql: ${date_raw} ;;
}

This will return values in your desired output! 

Top Labels in this Space
Top Solution Authors