Step one: Create a desk identifying new groups and you will numeric selections
An easy a couple of table ask computes such overall performance even when the measurements of this new numeric ranges commonly similar. Contained in this analogy, i have fun with several dining tables (Age range and you may Customers), plus one query (Frequency: Ages Shipment). Only pursue such easy steps:
Only would a dining table which have four sphere: Group ID (counter), Classification Term (text), Lowest (number), and you can Restrict (number). For each and every number, determine brand new teams as well as low and you will large viewpoints:
See how the [Maximum] value of you to definitely checklist is actually smaller than brand new [Minimum] value of another record. They cannot feel the same otherwise including thinking do fall into one or two teams. Inside our example, the age analysis try integers very using integers in this desk is ok. If you don’t, you are able to wide variety extremely close to each other (e.grams. 999). You could potentially name and you will indicate as numerous teams as you wish.
Step two: Would multi-desk Find ask
See that the 2 tables packages are not associated with for every single most other. The first and you may third industries regarding ask come from brand new group desk: the new [Category Label] dysfunction therefore the [Category ID] career controlling the kinds order.
(read more)