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 Define a direct filter on data) or the report context (refer to Use context 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.
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:
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.
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.
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.