Other Example Reports
Example Reports
Example 1:
A report to show the total revenue made from Freshers tickets and how many units were sold.
Source Table:
Transactions
Columns:
transactions.transactions_items.products.id
transactions.transactions_items.products.name
transactions.price_total (Use Sum operator)
transactions.transactions_items.products.description (Use Count operator)
Criteria:
| Column | Operator | Value | Meaning |
|---|---|---|---|
| transactions.status | Equals | C | Transaction is completed |
| transactions.transactions_items.products.id | In | 10001,10002,10003 | ID's of Freshers Tickets |
| transactions.transactions_items.status | Equals | A | Transaction is active (not refunded or cancelled) |
Group By:
transactions_transactions_items.products.id
Example 2:
A report to show how many students are part of each Sport or Society this academic year.
Source Table:
Group Memberships
Columns:
group_memberships.members.student_id
group_memberships.groups_name
Criteria:
| Column | Operator | Value | Meaning |
|---|---|---|---|
| group_memberships.created_date | Greater Than | 1561849200 | Membership was purchased after 30.06.19 |
| group_memberships.leaver_date | Greater Than | 0 | Student is currently enrolled |
Updated on 1st February 2021