Overview allows you to see the sales based upon a date range whilst also being able to apply a filter and group the results.


Filter

To add a filter select the button:



*Note when using the autocomplete any option shown as a pill below the value input field will always be treated as an include to the report and does not abide by the selected operator, this will only apply to

the text in the Value field:  



The filter option allows for a filter based upon:


  • Shop
  • Master Items
  • Vendor
  • Hierarchy
  • Attributes


Once the filter drop down option has been selected an operator can be chosen from the following:


  • is equal to
  • is not equal to
  • starts with
  • ends with
  • contains
  • does not contain


Finally a constraint can be added. The example above will exclude the shop named Manchester.


Multiple filters can be added by choosing the button. To remove an applied filter press the button.


Group By


The Group By toggles can be used to group the filter results. A maximum of 4 Groups can be selected. The Group hierachy is determined by the level in which the groups are set, you can change the group order by clicking and dragging on the group handle .

In the example below the Report will be group by Shop then By Master Item:



Note the dimensions grouping will only display if you have configured Dimension types from within Item Management.



Date Range

The report will display the results from the date range selected, you must enter a start and end date range within a 10 year period. The filter defaults to a month back from the current date to the current date.



By clicking on the within the Start or End date a calendar will be shown where the date can be selected.



Within the calendar selecting the will choose todays date.


Generate

Once the filter, grouping and date range has been selected clicking Generate will display the report in 2 sections.


Report Grid

The first section is the report grid. 


The below example shows a report grouped by Shop and Master Item.


The report grid headings display the following data:


  • Turnover - The turnover from the specified date range
  • Discount - The amount of discount applied 
  • Return - The amount of returns during the specified date range
  • Turnover Ex Tax - The Turnover amount excluding Tax
  • Gross Profit - The Gross profit amount
  • Gross Profit % - The Gross profit % achieved
  • No Of Sales - The number of transactions
  • No of Articles Sold - The number of individual arcticles/items sold
  • Avg Price of Articles Sold - The average article price 
  • Avg Articles in Basket - The average number of items per transaction
  • Avg Basket amount - The average transaction amount


Clicking will download a csv file of the report grid


Graphs

The second section shows the KPI graphs. The top graph is the financial KPI, hovering over any of the lines will display the chart figures.


The bottom graph is the statistics KPI, hovering over any of the lines will display the chart figures.



Selecting the hamburger icon allows you to print or download the charts in various formats.