Creating custom label

[#1]

I have created a quarter dimension on my data like following

Load

...    

     Div(Month([timestamp]), 3) as season,

...

I have made a pie chart on this dimension showing data in different quarter periods. The labels on these pie slices are obviously 0,1,2,3 and I would like them to be Q1, Q2, Q3, Q4.

How do I do this in the best way?

[Michael_Tarallo]

Hi Viktor - try this:

'Q' & Ceil(Month(OrderDate)/3) as Quarter

Let us know how you do.

Please mark the appropriate replies as helpful / correct so our team and other members know that your question(s) has been answered to your satisfaction.

Regards,

Mike

[#3 · Accepted solution]

You could change your dimension to the following:

'Q'&Div(Month([timestamp]), 3) as season

Or in case you want to keep your current dimension, just add the new one bellow:

...

Div(Month([timestamp]), 3) as seasonNumber,

'Q'&Div(Month([timestamp]), 3) as season

...