Description: This article describes charts, and how they can be created, saved, and exported to different formats. There is also a section on how to save data as a Report.
A Chart is a visualization of the data in a Pivot table. There are different types of Charts available to suit different types and volumes of data. Charts can show you what you want to know in a more presentable format, which you can save, share, and export.
The best way to add a Chart in InnovidXP is to create a new Pivot and save it as a Chart. It is then added to the Chart Library.
This is an example of how to create a Chart showing cost per response by daypart:
-
Select Analysis from the main menu to display the Analyze Data screen.
-
Select the Create new Pivot link to display the New Pivot screen.
-
In the Rows dropdown, select Daypart.
-
In the Metrics dropdown, deselect Spend. The metrics Response and Cost per Response are selected by default.
-
Select the Create chart icon
to display the Chart options.
-
Select the type of Chart you want to create from the dropdown. The Bar Chart option is selected as the default.
-
Choose Daypart for your x-axis by clicking in that column.
-
Choose Response for your y-axis by clicking in that column. You can select more than one option for your y-axis.
-
Select Create Chart to display the Pivot Chart on a new screen. You can optionally scroll to the bottom of the screen and select Edit Chart to display more options:
Note: Make sure you save any changes by selecting Update Chart. -
Select the ellipsis button and select Save to save your new Chart. The Save To Chart Library popup screen is displayed, for example:
-
Complete the Title and Description fields, select the visibility level for the new Chart, and select Save.
The new Chart will be saved in the existing Charts Library (Analysis > Explore existing Charts).
Exporting a Chart
This task describes exporting a Chart as a PowerPoint presentation, PDF, PNG, or CSV.
- Select Analysis > Chart Library and select the Chart you want to export.
- Select the Download button and select a format:
The Chart will be downloaded to your device in the selected format.
Note: You can also export a Report as a CSV (Select Analysis > Reports and select a Report).
Creating Reports
This task describes creating a Report from a Pivot table or starting afresh in the New Report screen.
Creating a Report from a Pivot
When viewing data as a Pivot, switch to the Report (traditional table) view to display a screen that lets you build and save a Report based on the current data selection.
You can change the order of the data, customize, save, and export the Report. Reports are saved in the Reports library in the Analysis area.
Creating a Report in the New Report page
Select Analysis > Reports > Create New Report to display the New Report page.
Make sure you select your desired rows or only metric totals of all spots will be displayed. Add columns so that you can customize the metrics and add a split.