beautypg.com

Performing a group by query, Drilling down a group by query – Milestone Retail 2.2 User Manual

Page 9

background image

Milestone XProtect Retail 2.2; User’s Manual

www.milestonesys.com

Page 9

How to Investigate

will not trigger any action. (Please see Retail Application Settings on page 16 for instructions on
how to connect to the surveillance system.)

Performing a Group By Query

Performing group by queries will present you with a window like this:


When performing a group by query each line in the table represents a set of transactions. In the
example above each line in the table represents the void items made by each employee.
The Number_Of_Items column in the table shows the number of void items made by the specific
employee and the last column gives a graphical representation of the number of void items.

When clicking on a line in the group by table each transaction contained in the group will be shown
in a drill down table.

Drilling Down a Group By Query

When you drill down into an aggregated (group by) query result, the transactions found in the
group by query are presented like this: