Summary reports are similar to tabular reports, but also allow users to group rows of data,
Summary Report adds up the corresponding cell data of multiple reports which have the same structure and different data.
How to build Summary Report?#
Like the tabular report, you can also build a summary report in Drag & Drop mode or Script mode.
Drag & Drop mode#
STEP 1: Select "Summary Report" visualization type#
STEP 2: Deside the Group and Summarized fields#
You can summarized multiple fields.
STEP 3: Label fields and apply filter conditions#
Choose appropriate label for fields, these label names will show as summary report header title.
STEP 4: Preview, correct issues and publish Summary Report#
Click the "Preview" button to see what the summary report looks.
Script mode provides a more flexible and advanced way to build summary report.
Check the "Script" checkbox to switch to Script mode, DbFace will try to generate SQL query that you already build, but you still need to correct it if contains issues.
Here is a sample summary report script:
SELECT YEAR(requiredDate) as `Year`, COUNT(orderNumber) as `Order Number`, COUNT(DISTINCT customerNumber) as `Customer Number` FROM `orders` GROUP BY `Year`