Custom Hourly Report

[QMcKay]

@cafe1999

if we want to show the total sales for the hour instead of %Sales

The Report already shows both of those. The Total is column 2 (“SALES” column in your screenshot).

@cafe1999

are we able to export the report in Excel or CSV format?

Any Report can be turned into a Data Export, which supports any type of plain-text output such as CSV, XML, etc. You cannot export directly to XLS because that is not plain-text, but Excel can of course read CSV files.

Data Exports feature

I notice Data Exports feature under Manage > Reports, but nothing mentioned on the forum about it. What does this do? Can I use it to create CSV exports? Any info much appreciated. Thanks EDIT: Ok I notice it exports the report to a txt file. If for example I use the {REPORT INVENTORY} tag I am getting output like this: >Local Warehouse|| Svedka|4,900|ML Absolute|4,280|ML Belvedere|455|ML Taking same format from the inventory report with the table header [Inventory Report:1,1, 1…