topic Re: Creating custom label in App Development

Creating custom label

Tue, 30 Sep 2014 14:25:07 GMT

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?

Re: Creating custom label

Michael_Tarallo — Tue, 30 Sep 2014 14:55:22 GMT

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

Re: Creating custom label

Tue, 30 Sep 2014 14:55:54 GMT

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

...