Burger Counter Per Hour

[gerlandog]

first thing, you should not drill TICKETS table, you should apply this SQL to ORDERS table and filter it by MenuItems…

You can take a look at the REPORT TAGS topic, specifically {REPORT ORDER DETAILS:<fields>:<expression>} in:

Custom Report Tags in detail

We can prepare any type of reports with SQL and display results as a Custom Report. Alternatively we can use Custom Report Tags to prepare reports. If you need more information about preparing a custom report you can review this tutorial. ###Introduction Basically there are four types of tags. DETAILS TAGS: These tags contains DETAILS keyword in it and allows us to prepare table reports. TOTAL TAGS: If a tag contains TOTAL keyword in it we can use this tag read sum of a value. COUNT TAGS C…

G.