What is a Report?
CoolaData enables you to define reports showing any slice of data or dates that you stored in CoolaData in a variety of report visualizations – Table, Single number visualization, Line chart, Area chart, Bar chart, Column chart, Pie chart, Geo chart or Pivot table. CoolaData provides a variety of report types, breakdowns and grouping options.
Each report holds a CQL query that determines the data that is retrieved from CoolaData.
CoolaData provides a variety of forms for presenting reports –
- Dashboards present reports inside your own dashboard that you can share with your colleagues.
- Publications send scheduled emails containing a set of reports to the recipients that your specify.
- Embedded Reports show CoolaData reports in any of your webpage frameworks by embedding the provided snippet.
Cooladata offers a variety of report types. See Reports and Queries for all the report types and how to create them.
Defining a Report’s Date Range
To define the report date range click the dates button at the top right.
The date range defined in the top right corner of a Dashboard applies to all the reports that appear in it, unless a different timeframe was defined for a specific report. Turn on the Ignore Dashboard Date Range option to always use this date range and ignore the dashboard date range.
Defining a Report’s Filter
To define a report filter click the filters button at the top right.
The filter defined in a Dashboard applies to all the reports that appear in it, unless a different filter was defined for a specific report. Turn on the Ignore Dashboard Filters option to always use only this filter and ignore all other filters in a dashboard. f the Ignore Dashboard Filters option is not used, then the date range shown in this report when it appears in the dashboard will be different than when this report is shown on its own (meaning not in a dashboard).
Exporting Report Data
You can export any report from the report page or directly from the dashboard. The export creates a CSV file which can be downloaded to your computer.
Note that the exported file is limited to 20,000 rows, as in the visualization. To export a larger data set use the Query API.
To export report data click the Compute button and click the Export button to download all displayed report data to a CSV file.
In the dashboard it can be found in the option menu of each report: