Skip to Content
0
Former Member
Jun 27, 2008 at 08:52 PM

Need help formatting chart...

25 Views

All,

First let me tell you what is wrong (what I need help with), and then I will give some background informationon the problem. ANY help is appreciated!

The problem is that I am trying to supress some of the data in a chart so only the highest 20% amount of data shows up.

We are using BusinessObjects Enterprise XI Release 2 and I have created a chart based on a horizonal table. In the chart, I do a count of defective parts on one of our products that we've building for a couple of years. This means I have two years of data (about 20,00 rows of data in the horizontal table. The column that I count on is called, "Defective Part Number". I am using a variable with formula:

=Count([Defective Part Number];All)

and the count works great. Now when I convert his into a horizontal chart all of the data is "scrunched" together and you cannot see the chart well. I have about 1,500 rows where only one (1) item is counted, so I am attempting to only count those item that have count "greater than one" (>1). The formula I used is:

=If([Defective Ref Desig Count ]>1;(Count([Test Ref Desig];All)))

This also works for suppressing the chart objects, but data is still being counted and the "X-axis still list all of the part numbers. All of the chart objects are pushed to the far right side. I tried to paste a copy of the chart in this message, but it will not paste in. If anyone needs more detail, please let me know. Your help is appreciated.

Thanks,

Charles Norman