> ## Documentation Index
> Fetch the complete documentation index at: https://help.airbridge.io/llms.txt
> Use this file to discover all available pages before exploring further.
# Creating a Trend Report
The Trend Report visualizes data collected by Airbridge as a time series.
Configuring the Trend Report
Configure the period, metric, GroupBy, and filter to view the data you need. Use GroupBys to break down the selected metrics, and apply filters to narrow down to specific GroupBy values.
Date range
The period consists of four settings: granularity, condition, date, and timezone.
##### Granularity
Granularity has four options: hourly, daily, weekly, and monthly. Data appears in the selected granularity unit.
##### Date condition
Three date conditions are available.
| Condition | Reference | Date range |
| --------- | ------------------ | ----------------------------------------- |
| Between | Start and end date | From start date to end date |
| Since | Start date | From start date to today |
| Last | Number (n) | From n days/weeks/months ago to yesterday |
For ‘Last’, you can add ‘Include today’, ‘Include this month’, and ‘Offset’. Including today or this month extends the range from n units ago to today or this month. Click ‘Offset’ and enter a number to push the start point back by that many units. For example, with ‘Daily’ granularity and ‘Last 30 days’, the range runs from 30 days ago to 1 day ago. Turning off ‘Include today’ and adding ‘Offset 3 days’ shifts the range to 33 days ago through 4 days ago.
##### Date
Use the following criteria when selecting dates.
* Earliest selectable date: February 1, 2023
* Maximum date range per query: 400 days (daily, weekly, monthly), 15 days (hourly)
##### Timezone
Timezone is the time zone applied to the report. The default matches the [Airbridge App timezone](/en/guides/set-app-timezone).
Metric
Metrics quantify the data Airbridge collects through tracking links, the SDK, the API, and other sources. Select 1 to 8 metrics for a single view. Metrics without collected data do not appear. Three metric types are available: Standard Metric, Cohort Metric, and Custom Metric. For details, see [Airbridge report metrics](/en/guides/airbridge-report-metrics).
GroupBy
GroupBys break metrics down by the selected dimension. For example, selecting Channel groups metrics by ad channel. You can select up to 4 GroupBys. The behavior varies by metric type.
* Standard Metric, Custom Metric: Applied per metric.
* Cohort Metric: Applied to the start event.
Filter
Filters narrow results to specific GroupBy values. The format is A is B, where A is a GroupBy and B is the filter value. Only values Airbridge has collected at least once appear in the search results for B. ‘is’ is the default condition. All available conditions are listed below.
| Condition | Format | Description |
| ---------------- | -------------------- | --------------------------------------- |
| is | A is B | Returns data where A equals B |
| is not | A is not B | Returns data where A does not equal B |
| contains | A contains B | Returns data where A includes B |
| does not contain | A does not contain B | Returns data where A does not include B |
| exists | A exists | Returns data where A is present |
| does not exist | A does not exist | Returns data where A is not present |
Viewing the Trend Report
Once you finish configuring the report, you can view the results. The results appear in chart and table form.
Chart
**Note**
The Trend Report chart displays the metric data in count or sum units. If the value gap between the items is too wide, the chart may not display them correctly due to the difference in results. To avoid such errors, it is recommended not to query items with value gaps expected to be too wide.
The line chart shows data by granularity. Hover over the chart to see all values for that date, or hover over a specific point on a line to see only that point. Click items in the legend below the chart to toggle them. Drag to select an area for zoom, and click ‘Reset’ to return to the original view.
Table
All data appears in the table. Use the checkboxes on the left to show only selected items on the chart.
On the Airbridge dashboard, go to \[Reports]>\[Trend] and configure as follows.
* Period: Set the date range and granularity. For example, select ‘Daily’ to view daily trends.
* Metric: Select ‘Installs (App)’.
* GroupBy: Select ‘Channel’.
Sharing the Trend Report
You can share the results through the following features.
| Feature | Description |
| -------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Report Library | When you save a report with your settings, other users with access can see it with your settings applied. Saved reports appear under **\[Report Library]**. |
| Copy Config | Share view settings with other Airbridge users regardless of their app roles or access level. Trend Report configs can be pasted into the Actuals Report to view the same data. Depending on the number of metrics and GroupBys, an Actuals Report config may not paste into the Trend Report. |
| Report URL | A Report URL is generated each time you view a report. Even without saving, you can share the URL with users who have view access to see the same report. |
| Copy Table | Click ‘Copy Table’ to paste the table into Excel, Google Sheets, or similar tools. |
| Export | Download report results in your chosen format. |
Trend Report features and limitations
Below are the features and limitations of the Trend Report.
| Feature/Limitation | Description |
| -------------------------------------------------------- | -------------------------------------------------------------------- |
| No. of metrics configurable | 8 |
| No. of GroupBys configurable | 4 |
| Self-serve Metrics, Custom Metrics, Custom GroupBys | Supported |
| Timezone | The configured Airbridge App timezone. Configurable per report view. |
| Currency | The configured Airbridge App standard currency |
| Data visualized in | Tables, charts |
| Data refresh cycle | Real-time, except for user count metric data (1 hour) |
| Aggregated data | App event data, web event data, SKAN data, cost data |
| Custom events | Supported |
| Maximum no. of rows in the Airbridge dashboard | 100 rows |
| Maximum no. of rows in CSV/Google Sheets | 1,000 rows |
| Data available of | Past 5 years |
| Maximum date range configurable for a single report view | 400 days (daily, weekly, monthly), 15 days (hourly) |
General features
These features are supported across Airbridge reports. Some may not apply to certain reports.
| Name | Description |
| --------------- | --------------------------------------------------------------------------------------------------------------- |
| Refresh | Reloads results with the current report configuration. The time since the last load appears next to the button. |
| Wide controls | Configure the report on a wider panel. |
| Search | Search within the report results. |
| Expand/Collapse | Expand or collapse the report configuration. |
| Report naming | Name the report. A name is required to save the report. |
Attention
Note the following.
Custom Metrics using metrics from only some apps
Custom Metrics are available across every app in your organization. However, if a Custom Metric’s formula includes a metric defined for only some apps, the results may not reflect what you expect.
App A and App B are in the same organization. Both apps use the following custom events and self-serve metric.
| Event/Metric | push\_sent (custom event) | in\_app\_sent (custom event) | push\_clicked (self-serve metric) |
| ------------ | ------------------------- | ---------------------------- | --------------------------------- |
| App A | Collected | Collected | Collected |
| App B | Collected | Collected | Not collected |
Assume custom metrics are defined as follows.
* message\_sent = push\_sent + in\_app\_sent
* push\_click\_rate = (push\_clicked / push\_sent) \* 100
In the results for each app, App A can see both custom metrics. However, App B shows push\_click\_rate as 0 because App B does not collect the push\_clicked metric.
| App | message\_sent | push\_click\_rate |
| ----- | ------------- | ---------------------------------------------------------------------- |
| App A | Available | Available |
| App B | Available | Unavailable (Shown as 0 because push\_clicked metric is not collected) |
Interoperability of Copy Config
* Among Airbridge reports, configs can be copied only between the Actuals Report and the Trend Report.
* The Trend Report allows fewer metrics and GroupBys than the Actuals Report. Pasting an Actuals Report config that exceeds the Trend Report’s limits results in an error.