The report options are available from inside the report, in the top right corner next to the report date range:









Report Settings

The report settings allow you to control specific configurations of the report:

Ignore dashboard date range

When turned on – the report will only run on the date range defined inside the report, ignoring the dashboard date range.

Ignore dashboard filters

When turned on – the report will only filter the data by the filters defined inside the report, ignoring the dashboard filters.

Read Only

When turned on – saving changes in the report will be blocked. Remember to Save after turning this toggle on for it to take effect. Turning off the Read only setting can only be done by an ADMIN or the owner of the report.


When turned on – The report will only be visible to the report owner in the reports list, but can still be used in dashboards.

Use Cached Results

When turned on – Cooladata will attempt to use results from a previous run of this query. If cached results are returned, the query summary row will show “cached” and query runtime will be minimized.
Results from past runs will be used as long as the queried tables were not modified and the date range and filters of the query are the same.

Use sessions aggregation for query optimization

When turned on – Cooladata will attempt to optimize performance by automatically shifting your query to run on top of the sessions table if all the data you are querying is available there.
Notice: Cooladata stores your data in two separate tables: one is your event table, in which every row is an event, and the other is your sessions table, in which every row is a session. The event table holds all the event-level data and event-scope properties, as well as user and session scope properties. The sessions table holds session-specific properties (such as session duration and the session path) as well as session and user scope properties.  Shifting between the sessions and events table might cause for slight differences due to the fact that when running over the sessions table, the date range is filtered according to the session start time (session_start_time_ts) whereas when running over the events table the date range is filtered according to the event (event_time_ts)  timestamp.

Drill-through Reports

Drillthrough Reports enable you to drill through (zoom in) to a section of a report by clicking it, and opening another preconfigured report, filtered to that category’s data.

For more information on setting drill through reports see Drill through Reports.


This will create a copy of the original report. When clicked on from inside a dashboard, this will add the copy of the report to the dashboard as well.


This will create a publication (email report) with the report results and send it to a list of recipients. Project ADMINs can also choose the publication’s frequency.

For more information see publications.

Add to Dashboard

This allows you to add the report to a specific Sheet in a specific Dashboard you have permissions to edit.

Show CQL

This opens up the underlying CQL of the report. You can copy and paste it in a CQL report to modify it.

Print Friendly, PDF & Email