Home > Statistics > Concepts > Statistics Groups

# Statistics Groups

When you use Trading Statistics and you group your data by location, you can see the statistics for each specific store. But what if you want to view your statistics by state or by region? This is where the concept of statistics groups are used.

You define a statistics group for each location summary you want to see, for example STATE or REGION. For each store, you specify the groups that it belongs to. You would specify the state location code and the region location code it belongs to. Next to each of these you would specify the statistics group it belongs to, if any.

An example will make this easier to understand.

We have a top level location code of ALL.

We have region location codes called NORTH and SOUTH.

We have state location codes called QLD, NSW and VIC.

We have store location codes called SHOP1, SHOP2, SHOP3, SHOP4, SHOP5.

We also have some other general reporting location groups called BIG and SMALL.

We have two statistics groups called REGION and STATE.

Lets look at SHOP1

 Store Location Group Statistics Group SHOP1 ALL SHOP1 QLD STATE SHOP1 NORTH REGION SHOP1 BIG

Notice it belongs to one location code (QLD) which is marked as the STATE group. It also belongs to one location code (NORTH) which is marked as the REGION group. Also, it belongs to other location groups (ALL and BIG) which don't have a statistics group. You don't have to have a statistics group!

Now lets look at the other locations:

 Store Location Group Statistics Group SHOP2 ALL SHOP2 QLD STATE SHOP2 NORTH REGION SHOP2 SMALL SHOP3 ALL SHOP3 NSW STATE SHOP3 SOUTH REGION SHOP3 SMALL SHOP4 ALL SHOP4 NSW STATE SHOP4 SOUTH REGION SHOP4 SMALL SHOP5 ALL SHOP5 VIC STATE SHOP5 SOUTH REGION SHOP5 BIG

Notice that for each store, it only belongs in one location group in STATE and one location group in REGION. You cannot set up a store to belong in two different location groups with the same statistics group.

Lets look at what happens if we simply show statistics data grouped by store for the ALL group.

 Store Includes Data From SHOP1 SHOP1 SHOP2 SHOP2 SHOP3 SHOP3 SHOP4 SHOP4 SHOP5 SHOP5

Now if we reselect the data to group by STATE for the ALL group:

 Store Includes Data From NSW SHOP3, SHOP4 QLD SHOP1, SHOP2 VIC SHOP5

And if we reselect by REGION for the ALL group:

 Store Includes Data From NORTH SHOP1, SHOP2 SOUTH SHOP3, SHOP4, SHOP5

For all of these queries, the system is selecting the statistics data from the individual stores. It is simply summarising the data differently.

Note: It is important that if you set up a statistics group, all stores should be set up with a location group in that statistics group. If you tell the system to select statistics for the ALL location group by REGION and ALL includes SHOP5 but SHOP5 doesn't have a REGION location, the statistics will not work correctly.

Statistics groups are set up using the Location Types function. You use the Locations function to define which location groups and statistics groups a store belongs to.