π Required Role Permissions: Data Export, Generate Reports, See Custom Reports, Modify Custom Reports, See Charts, Modify Charts
The Ventrata dashboard offers tools to discern detailed information about focused aspects of your operation. The Generate Report button appears in most sections of the dashboard to help you create reports and charts, useful for both finance and day-to-day operations.
β
The Generate Reports button appears on the action bar sandwiched between the top navigation and page table. Follow the steps below to create and manage reports and charts.
β
Reports
Use reports when you need a detailed, structured view of raw data that you can filter, sort, and export for further analysis.
Use reports when you need a detailed, structured view of raw data that you can filter, sort, and export for further analysis.
Create Report
In this article, the Bookings page is used as an example.
In the Ventrata dashboard, go to Bookings > Bookings.
β
π NOTENotice that certain column titles appear in green. These columns are the input data of your report. Make sure you select and filter the columns that reflect the information you need from the report.
Report Input Date
Press the Generate Report button.
Select New Report.
New Report
Review your input data.
Report Builder
π NOTE
Remember that these are coming from the filters on columns with green titles.If you wish to include test bookings, check the 'Include Test Data' box.
Include Test Data
Select what information you wish to determine using the report:
Total - sum of values
Minimum - the lowest value
Maximum - the highest value
Average - the sum of values included in the report divided by their count
Count - number of selected parameter
β
Select which information you want to measure from the 'Show' drop-down field.
Select how you want your information sorted from the 'By' drop-down field.
Data Composition
π TIP
It is helpful to read the steps in constructing your report as "Show Total of PAX by Channel".
βIf you selected more than one 'By' attribute, choose the field you want to use to sort the information.
π NOTE
This field sorts only based on the options selected in the 'By' field.
Select whether to sort data in ascending or descending order.
Sort By & Sort Direction
π NOTE
If you are modifying an existing report, make sure to save the report with the desired sort options before exporting. This ensures that the sort order is retained in the exported report.
Press the Generate Report button.
Generate Report
A report using the information provided on the left is generated on the right-hand side of the Report Builder.
Generated Report
The Ventrata dashboard offers 4 actions that can be done on the report:
Save Report - save to create up-to-date reports using the latest data
Print Report - print the report in table view, including all your input data and report criteria
Download Excel - download the report to work with the output offline
Download CSV - download the report to import the output into other applications
β
Save Report
Press the Save Report button.
βEnter 'Name'.
Mark the report as 'Private' if you do not want other users to access your report.
Uncheck the box to make the report public.
Check the 'Include Test Data' box if you wish to include test bookings every time the report is generated anew.
Review and tweak your criteria as needed.
If you have not specified the field to sort by or the order in which to sort your data, you can do so here.
Sort By & Sort Direction
π NOTE
These fields sort only based on the options selected in the 'By' field.
Check the 'Email Report' box to automatically send emails when the report is updated.
Email Report
Check the 'Skip if Empty' box to prevent emails from being sent if the report contains no matching data.
Skip if Empty
Enter the email addresses of the recipients.
Email Recipients
Enter how often you want the email sent in
hours,
days,
weeks
or months.
β
Then, set the start date.
Email Period & Start Date
Select the time zone.
Email Time Zone
Select 'Email Date Field' to delimit results since a certain action + date combination.
Email Date Field
Enter date range start since the email date field event and range end in days, weeks or months.
Email Date Range
π TIP
You can use the Quick Links button to set larger chunks of time, such as last/next month/week, or today, tomorrow, yesterday or day after tomorrow.
βPress the Create Report button.
Create Report
Manage Reports
In the Ventrata dashboard, go to Bookings > Bookings.
Press the Generate Report button.
Select 'Manage Reports'.
Manage Reports
A new window with a list of your reports appears onscreen.
Reports
βPress the pen and paper icon to edit the report. You will be redirected to the Save Report window from above.
βπ TIP
If you set up automatic email sending, you can test your email setup using the TEST EMAIL button next to your report in the Reports window.
βEdit your report parameters and automatic email settings.
Press the Update Report button to save your changes.
Update Report
π TIP
You may also choose to Duplicate or Delete the report.
β
You can include new input data into your existing report by adding new green columns in the table view by pressing the Show Column, then selecting your report from the list of reports under the Generate Report button.
β
Generate Report
You can also switch between reports by pressing the OTHER REPORTS button below the report name.
Other Reports
β
Charts
Use charts when you want to visualise trends, comparisons, or summaries in your data for quicker insights and presentations.
Use charts when you want to visualise trends, comparisons, or summaries in your data for quicker insights and presentations.
Create Chart
In the Ventrata dashboard, go to Bookings > Bookings.
Press the Generate Report button.
Select 'New Chart'.
New Chart
Enter 'Name'.
Select chart width in single digits.
Chart Name & Width
βUncheck the 'Private' box if you want want other users to access the chart.
Private
If you wish to include test bookings, check the 'Include Test Data' box.
Include Test Data
Select what information you wish to determine using the report:
βTotal - sum of values
Minimum - the lowest value
Maximum - the highest value
Average - the sum of values included in the report divided by their count
Count - number of selected parameter
β
Select which information you want to measure from the 'Show' drop-down field.
Select how you want your information sorted from the 'By' drop-down field.
π TIP
It is helpful to read the steps in constructing your report as "Show Total of PAX by Channel".
βIf you selected more than one 'By' attribute, choose the field you want to sort the information by.
π NOTE
This field sorts only based on the options selected in the 'By' field.
Select whether to sort data in ascending or descending order.
Sort By & Sort Direction
Select chart type.
Chart Type
If you select 'Bar Chart', also select whether in case of multiple objects ('Show' field) they should be stacked on top of each other.
Select whether the bars in your chart should line up horizontally or vertically (default).
Chart Orientation
Press the Create Chart button.
Create Chart
Your new chart is located above the table view.
Press the Load Chart button at the centre of the chart card.
Load Chart
β
The Ventrata dashboard offers 4 actions that can be done on the report:
EDIT - edit your chart, duplicate or delete the chart
Download SVG - download the chart in scalable vector format
Download PNG - download the chart in high-resolution raster format
Download CSV - download the chart to import the output into other applications
β
Chart Actions
β
Reporting Use Cases
Here are some real-world examples of information you can get from generating reports:
β
Are any sellers selling suspicious amounts of reduced price tickets?
Are any sellers selling suspicious amounts of reduced price tickets?
Create a report using the following:
βSHOW Total OF Children, Adults, Seniors BY Seller
Consider also filtering by date ranges.
I want to see a breakdown of the popularity of our products by country.
I want to see a breakdown of the popularity of our products by country.
Create a report using the following:
βSHOW Total OF Total BY Customer Country, Product
The report will provide a list of products bought the most often grouped by the nationalities your customers entered during checkout. You may consider adding Customer language as a variable.
β
β