Stephen Russell wrote: > On Mon, Apr 26, 2010 at 8:53 AM, MB Software Solutions, LLC > <[email protected]> wrote: >> Here's a chart I've quickly put together with FoxCharts and some sample >> data: http://mbsoftwaresolutions.com/images/sample1.png >> >> I don't want to have a zillion little crap categories; rather, I'd like >> to just wrap them up into a category called "Other". What's the >> mathematical approach for determining the cutoff and then saying "You >> remaining categories are "Other" ??? > ------------------------- > > You have to define what the cutoff is first. If % or whole is < > 5,7,10,15% you want it lumped together right? > > Just do a iterate / scan through the data before you present it to the > chart app and change the ID to the fake "OTHER" that you want to > present.
Yeah, I was finding the mean (middle) value, and then copying the data to a new cursor in 2 parts: 1st part was values above mean value; 2nd part was sum of remaining values at or below mean in group called "Values <= (mean)". That should do it. -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
