Question

Quarter Format Issue

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

This topic has been closed for comments

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!

Sign up