Using the context
When you want to represent data in the form of tables or charts , it can be taken from two sources: a new query (refer to Defining a direct filter on data ) or the report context (refer to Using context data ).
Defining a direct filter on data
Using a Query type activity isn't mandatory when building a report. Data can be filtered directly in the tables and charts that make up the report.
This enables you to select the data to display in the report directly via the Page activity of the report.
To do this, click the Filter data... link in the Data tab: this link lets you access the expressions editor to define a query on the data to be analyzed.
Example: use a filter in a chart
In the following example, we want the chart to show only recipient profiles who live in France and who made a purchase during the year.
To define this filter, place a page in the chart and edit it. Click the Filter data link and create the filter that matches the data you want to display. For more on building queries in Adobe Campaign, refer to this section .
Here, we want to display the breakdown by city of selected recipients.
The rendering will look like this:
Example: use a filter in a pivot table
In this example, the filter lets you display only non-Parisian customers in the pivot table, without using another query beforehand.
Apply the following steps:
- Place a page in the chart and edit it.
- Create a pivot table.
- Go to the Data tab and select the cube to be used.
- Click the Filter data... link and define the following query to remove Adobe from the list of companies.
Only recipients that meet the filtering criteria will appear in the report.
Using context data
To represent data in the form of a table or a chart , the data can come from the report context.
In the page that contains the table or the chart, the Data tab lets you select the data source.
- The New query option lets you build a query to collect data. For more on this, refer to Defining a direct filter on data .
- The Context data option lets you use the input data: the context of the report coincides with the information contained in the inbound transition of the page that contains the chart or the table. This context may, for instance, contain data collected via a Query activity placed before the Page activity and for which you need to specify the table and the fields that the report concerns.
For instance, in a query box, build the following query for the recipients:
Then indicate the source of the data in your report, in this case: Data from the context .
The data location is inferred automatically. If necessary, you can force the data path.
When you select the data which the statistics will concern, the available fields coincide with the data specified in the query.