Sort Months in Bar Chart BOXI3.1 SP3 FP3.6

building reports webintelligence
1

Hey Friends,
I have a simple table that displays revenue for PAST 6 MONTHS only. Assuming we are in February 2012, the table should look like this:

Month…Revenue

August…11,500
December…23,975
January…43,556
November…75,233
October…15,325
September…84,453

Here, its understood that “January” in the above table is from year 2012 because the table displays ONLY past 6 months data. Therefore I do not want to explicitly mention the Year Number YYYY.

I want to sort if month wise so that it would look like below:

Month…Revenue

August…11,500
September.84,453
October…15,325
November…75,233
December…23,975
January…43,556

I am able to achieve this requirement in the form of a table. First, I display the Months in the form of YYYY/MM in the table. Then, on that column I apply alerters, for example, If Month = August, then display August. So this works perfectly fine.

How can I get the same functionality to work on a bar chart? When i convert the same table to chart, the alerters are inapplicable. And in the chart, on X-axis, i see values like “2011/08”, “2011/09”…“2012/01”. I just want the month names. If the format is "YYYY/MM " it works fine on the chart also. But I want only the names. Any ideas? I did some search on the forums, but could not find a solution to this requirement.

Regards
Steve

Dolly86 :uk: (BOB member since 2008-02-26)

2

The Alerter method will work - alerters do work on Graphs (for sure in XI R3); go into VIEW STRUCTURE Mode, highlight the Dimension you want to apply the Alerter to and select Alerters from the Toolbar menu.

HTH

mcnelson :uk: (BOB member since 2008-10-09)

3

Hey there,
I tried to go to structure mode and applied the alerter on the month field. When i go back to ‘View Results’ mode, the format is still the same. Where as the same alerter works fine on the table. (I ensured that there are no problems with the alerter syntax)

Any help?

Thanks

Steve!!

Dolly86 :uk: (BOB member since 2008-02-26)

4

Confirmed - frustrating as the Alerters work perfectly well when testing using “Cell Contents”, just not with the Formula syntax?

For your requirement see the attached ; not perfect but hope it will suffice.

HTH
Month Name.JPG

mcnelson :uk: (BOB member since 2008-10-09)

5

Hey, Thanks for getting back.

Yes, I guess this could be the closest solution… I too managed to get a similar look like the one below. Thanks again!

Regards
Steve
Month Graph.JPG

Dolly86 :uk: (BOB member since 2008-02-26)