You can produce charts of the raw data you are viewing.
- Go to Reports
- Select the desired Raw Data Report from the sidebar menu
- Select Report Settings, Columns to Include, and Search Parameters (if applicable)
- Instead of exporting the data to a file, click on the [View …] button at the bottom of the page.
- In the “Results” area, click on the “Columns” menu, which appears down the right side of the area.
- Click and hold the left mouse button on the 12 dots next to a column name, to drag the selected column down into the “Groups” area. Your view is now grouped by the column you have moved.
- Click and hold the left mouse button on the 12 dots next to a column name, to drag the selected column from the top down into the “Values” area to indicate the values you want to chart.
- Click on the column name in the “Values” section to choose the type of function to apply.
- Depending on the data, values can include min, max, average, sum, and count.
- In the “Results” area, highlight the region containing the grouped column and the values.
- Right click on the selected range and choose “ChartRange” from the menu
- Select the chart type (column, bar, pie, line, area, XY scatter / bubble). The chart type may offer sub-options.
- Optional: Customize the chart by clicking the options icon in the top right corner
- Optional: Click the download icon at the top right
EXAMPLE:
- Go to: Reports >> Raw Data Reports and select the desired report to run.
- Select all statuses.
- Click the [Search] button
- In the “Columns to Include” section, choose only FirstName, LastName, and City (from the “Basic Columns” section
- Click the [View Profiles] button
- In the “Results” area, click on the “Columns” menu, which appears down the right side of the area.
- Drag the “City” column down into the “Groups” area. Your view is now grouped by the “City” column.
- Drag the “City column from the top down into the “Values” area to indicate that you want to use “City” as the value.
- Click on the options icon to the left of the “City” column (in “Values”) and select “Count” as the function to use.
- In the “Results” area, highlight the region containing the grouped column (City) and the values (Count).
- Right click on the selected range and choose ChartRange >> Pie >> Pie