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.

Converted from CHM to HTML with chm2web Pro 2.85 (unicode)