Learning Objectives
After completing this help guide, you’ll be able to:
- Access Comet Data
- Navigate report groups
- Use report parameters
- Manage the table of results
- Save reports
The reports found in Comet Data are more generic than the previous reporting platform and allow users for flexibility to select, filter and export data that is contained in the Comet System.
Access Comet Data at comet.oceaniafootball.com/data. With single sign-on you will automatically navigate to the Comet Data dashboard if you are already logged into Comet, otherwise just login with your normal Comet username and password.
Report Groups
On the left side of the screen you will see all available Report Groups. Selecting an item on the left menu (example below shows Competitions) will open the list of all available reports under that specific group. Clicking on a specific Report will then take you to the parameter form of the selected report, where you will be able to set various parameters for the report.
Selecting a specific report takes you to the screen with a list of all available parameters that can be used to filter the result set captured by this particular report. There are very few mandatory parameters, and all others are optional.
Some parameters are dependent on each other. For example when you choose Registration category type = Coach, then Registration type will show only the registration types available for coaches, such as Head Coach, Assistant Coach, etc.
First time you click on each report, the system will automatically preselect default parameters, which mostly depend on your organization.
Each time you run the report, the system will remember all the selected parameters and it will preload the screen for you next time you open the same report. This “memory” is actually browser based, so it works this way on the same browser and on the same device.
At the bottom of the screen there is a Reset button which erases browser cache for the selected report and restores the defaults.
We have created some example report parameters to get you started.
Manage Table of Results
Once the user executes a report with selected parameters, results are presented in a large data table which offers additional options / actions. The following is a list of standard built-in features available on any set of results from Comet Data:
Sort results by any column
Sorting data is the process of arranging data into meaningful order so that you can analyze it more effectively. Select the column header once to sort text data into alphabetical order or to sort numeric data into numerical order. Click the column header once again to sort in reverse order (Z-A).
Change page size
You’ll notice that the number of items per page is by default set to 25. Click on the arrow next to the number 25 and change to any of the other available options.
Select columns you need
COMET Data reports are designed to provide you with as much relevant data fields (columns) per category. Some of this information may not be useful or necessary for your purpose, so each user is able to customize the presented results by hiding the columns that are not needed at the moment.
Run the report whose data you want to export and remove the columns by clicking the table icon in the top, right-hand corner of the report. You’ll see the list of columns on the right side. Mark the ones you don’t need and click on the report table. The report will be reloaded in a couple of moments.
Export results to Excel
For additional analysis and processing of the presented data results, there is an option to export data to Excel. The export feature will pick up exactly the order and the columns that are visible on the screen, including all pages of results. Simply run the report whose data you want to export, remove the columns that are not necessary and export it by clicking the chart icon in the top, right-hand corner of the report.
If the report contains less than 1000 rows, the Excel file will be generated automatically and downloaded on the local device. However, a large report that contains more than 1000 rows will be processed asynchronously and delivered to the user’s email address.
Saving Reports
If you run the same reports often, Comet Data has the option for saving and naming “your” version of the reports with all the predefined parameters and selected columns. The idea is to click through all the parameters and sorting and select the columns just once, then save and name “your” report for future use, as often as it may be necessary or until you choose to delete this report from your list. The procedure is as follows:
Set the desired parameters and run the report.
Customize further by sorting data and removing unnecessary columns.
Click on the Save icon at the top-right corner of the table with results.
Choose the name of the report and add a description, then click Save again. (This is for your eyes only, so choose names and descriptions that are helpful and descriptive for you.)
This action saves the query with all the details you have selected under the My Reports section so you can reproduce the report with new data at any time.
Note that the list of My Reports is the first page that opens each time you access Comet Data.