< "n" in a pie chart question

[patrichek]

Hi,
I have a pie chart working and I would like to make any "count" less than 10 grouped into a column called "other".

Right now I have about 8 fields of the pie that have a sum of less than 10 and I would like to combine them into 1.
I hope this isn't too confusing.

Thank you in advance!

 

[GingerR]

Save your current query as, say, "CountDetails".

Say that your two fields in this query are called "METHOD" and "CountOfMethod".

Then make another query, based on this query.
Make it a totals query.

The first column will be a caculated field:

ChartTitle: iif([CountOfMethod] < 10, "Other",[Method])

Bring down the "CountOfMethod" field, and change the TOTAL to "SUM"

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html

 

[patrichek]

Hi G,
I tried this but i'm not sure this will give me what i want. How will i put this on a chart with my other query.
Plus my original query has a date criteria...
maybe i need to be more clear.
I'm trying to make any slices less than 10% group together on a pie chart along with the other percentages
like:
newspaper 25%
billboard 25%
word of mouth 25%
others 25% (which are a group of all other sources less than 10%)

 

[GingerR]

I understand exactly what you want. Did you try it? You save your original query, then use that query as the basis for a second query. The second query is what you use for your chart. It will all work fine. The date criteria will still work.

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html

 

[patrichek]

i'm having a little trouble with this, i'll work on it some more and post my results.

thanks G

 

[GingerR]

please post your table structure and field names. Also the sql statement that is your original query. Without that info it's hard to help.

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html