Need to show the Quarter in the chart

[Anonymous]

Hi All,

Have the Date column and the values are there for 3 years ie:

01/30/2013

02/28/2013

03/31/2013

04/30/2013

05/31/2013

06/30/2013

07/31/2013

08/31/2013

09/30/2013

10/31/2013

11/30/2013

12/31/2013 and so on...

i need to show in the chart the month end date for eg:- (03/31/2013,06/30/2013,09/30/2013,12/31/2013 and so on).

Can any one help me on this..

[joshabbott]

Try something like this for a dimension:

=if(num(month([MonthField]))<=3, '3/31/2013',

    if(num(month([MonthField]))<=6, '6/30/2013',

      if(num(month([MonthField]))<=9, '9/30/2013',

        '12/31/2013')))

Or better and more efficient, create a field based on the return value of this if statement in your script

[jerem1234 · Accepted solution]

Use the QuarterEnd function:

=QuarterEnd(DATE)

Hope this helps!

[joshabbott]

Oooo, like it.  I didn't realize the QuarterEnd function existed.  This goes down as one of my things learned for today, thank you!

[jerem1234]

You're welcome!

[javier_florian]

Hi Ankit,

An additional option is through a formula like this:

=Year(Date)&'_'&Ceil(Month(Date)/3)&'Q';

This is a different option of visualization but is aligned with formula QuarterEnd or QuarterName or QuarterStart.

-JFlorian

[Anonymous]

Thanks Jeremiah Kurpat it worked!!!! Thanks a lot!!!