Create and Manage Pie Charts in Visualizations

This article is currently being updated. Please come back later for updates.

Permissions: Any Data Central user may create, save, and edit visualizations privately for personal use. Saving a visualization as public or editing an existing public visualization requires the Data Central Designer privilege.

A Pie chart is a circular chart that shows how a total is divided into its component parts. Each slice represents a specific category, with the size of the slice reflecting a measure or value. This chart makes it easy to identify which categories contribute the most or least to the total.

Create a Pie Chart

  1. From Visualizations in the left navigation, click the New Visualization (+) icon.

    Create a Pie chart

  2. Click Pie to open the Pie Designer window.
  3. In the Fields section, click the arrows, Data Store names, or Domain names to expand the data. Use the Search feature or scroll down to view all available domains and fields.

    Fields in the Pie Designer

Tip: Search also supports dot notation, e.g. DataStore.Domain.Field. After entering text, an X icon displays in the Search field. Click the icon to clear the search and reset the field list to its unfiltered state.
Search

Note: System Tables contain operational data that can be used in visualizations. While non-eCS users cannot create visualizations on these tables themselves, they can request that visualizations be built on their behalf through their eClinical Solutions Project Manager, Customer Success Manager, Implementation Consultant, or Tech Services representative. Once created, any user with access to the visualization can view and use it.

Tables available for request include:

Issue - Tracks issues raised during data review.
Protocol Deviation - Stores protocol deviation records with details.
Protocol Deviation Comments - Stores comments on protocol deviations.
Query - Stores queries to sites.
Review Cycle Status - Tracks review cycle progress.
Review Objectives - Defines goals for data review processes.
Review Objectives Domains and Fields - Links objectives to specific domains and fields.
Review Objectives Review Materials - Associates roles responsible for review tasks.
Review Objectives Reviewer Roles - Assigns roles responsible for review tasks and risks.
Review Objectives Risks - Identifies risks linked to review objectives.
Review Status Metrics by Domain and Role - Measures review progress by domain and role.
Review Status Metrics by Domain and Role and Subject - Tracks review completion per subject, domain, and role.
Subject - Contains subject identifiers and demographics.

Define Dimensions

A dimension is a field that segments or categorizes data, creating distinct slices of the pie for each subgroup. Dimensions are usually categorical or discrete variables, such as toxicity grade, outcomes, sex, or ethnicity. A Pie chart supports only one dimension.

  • Drag a field that can be categorized into the Dimension section. The preview displays each value of the field as a separate slice of the pie. By default, the field is also added as a measure that counts the records for each slice. For more information, see the Define Measures section.

    Define a Pie chart dimension

Add Dynamic Dimensions

A Pie chart supports optional Dynamic Dimensions, which allow users to switch between dimensions and automatically update the chart. Dynamic dimensions display at the top of the chart as pills or a popout menu.

  1. Click the 3-dot icon next to the field in the Dimensions section to open the Dynamic Dimensions popout.

    Dimensions popout

  2. Click Additional Dimensions and select the fields to add. The list contains fields from the selected dimension's domain.
    Add Dynamic Dimensions
     

    Note: Up to 10 Dynamic Dimensions can be selected from the same domain.

  3. Display As Pills is checked by default. This option determines whether dynamic dimensions display as pills or in a popout menu.
  4. The Label field displays the default field name. Enter a user-friendly label if needed. To restore the original value, click the Revert icon.
  5. To remove a dimension, click the X icon to the right of the field name.
  6. Click OK.

The published Pie chart displays Dynamic Dimensions as pills or a popout menu at the top of the chart. Selecting a dimension updates the chart.

When Display As Pills is checked, click a pill to switch between dimensions:
Dimensions displayed as pills

When Display As Pills is unchecked, select a dimension from the popout menu:
Dimensions displayed in a popout menu

Dimension Options

Click the 3-dot icon in the header of the Dimensions section. 

Dimensions sort options

Select an ascending or descending sort order for the primary dimension axis, then specify whether to sort by the dimension or measure.

Important: When more than 4096 records are available, a warning message displays and only the first 4096 records appear in the chart.

Define Measures

By default, the field added to the Dimensions section is also added to the Measures section. Keep the default measure, remove it by clicking the X icon, or drag a different measure into the Measures section to replace it.

Note: Only one field can be added to the Measures section at a time. Pie charts do not support dynamic measures.

  1. To configure the measure, click the 3-dot icon on the right to open the popout.

    Configure a Pie chart measure

  2. Select an Aggregate: Count Distinct, Count (default), Sum, Average, Minimum, Maximum, Standard Deviation, or Variance.
  3. The Label field displays the default field name. Enter a user-friendly label if needed. To restore the original value, click the Revert icon.
  4. Select a Value Display option to determine how values display in tooltips and series labels: Numeric, Percentage, or Both.
  5. Click OK.

Apply Filters to Dimensions and Measures

A filter can be applied to a dimension or measure using fields that belong to the same domain. Only one filter condition can be applied to a dimension or measure.

  1. Click the Filter icon to the right of the field name to open the popout.
  2. Use the default setting, Include Selections, or change to Exclude Selections.
  3. Click Filter Field to open the list and select the field to filter by.
  4. Click Operator to open the list and select =, <, >, Null or Empty, or Between. 
  5. Click Filter Value(s) to open the list and select the values to filter by.

    Select values to filter 

  6. Click OK. The chart opens filtered by the selected values, and the filter icon becomes shaded.

Tip: Click in the whitespace to close the popout if the OK button is not visible.

Note: To filter out Null values for a measure, dimension, or the entire Pie chart, select Exclude Selections and choose the field to filter. Select the Null or Empty operator and click OK.
Filter Null values
The Dynamic Filter option is not available for the Null or Empty operator.

Apply Dynamic Filters

Dynamic Filters let users select predefined values from a popout menu at the top of the published chart. Users can select one or more values from the popout menu to immediately update the chart with the selected filter values.

Dimension-level, measure-level, and chart-level filters can be configured as dynamic.

  1. Turn on Dynamic Filters by clicking the toggle switch.
    Enable Dynamic Filters
  2. Click Optional Default Filter Value(s) and select the default values for the published chart. The list displays values defined in the original filter before it is converted to a dynamic filter. When the chart opens, it is filtered using the selected defaults.

    If Select All is checked, the chart opens unfiltered, allowing viewers to choose values in the dynamic filter. The chart updates as selections change.

    Select Dynamic Default Filter Values

    If no default values are configured, the chart opens filtered by the first value in the list.

  3. The Label field displays the default field name. Enter a user-friendly label if needed. To restore the original value, click the Revert icon.
    Update the label or revert it
  4. Click OK. 

Tip: To collapse or expand each section (Dimensions, Measures, Filters), click the down and up arrows. Click the box icon to view only one section and collapse all other sections.
Collapse or expand areas

Apply Chart Filters

Filters applied in this section affect the entire visualization and are not limited to a single domain like filters applied to dimensions and measures.

  1. From the Fields section, select a field to filter the entire chart and drag it into the Filters section. A popout opens. 
  2. Use the default setting, Include Selections, or change to Exclude Selections.
  3. Click Operator to open the list and select =, <, >, Null or Empty, or Between.
  4. Click Filter Value(s) to open the list and select the values to filter by.
    Select a field to filter
  5. Click OK. The chart opens filtered by the selected values. Up to 25 filters may be added.
  6. To apply Dynamic Filters to the chart, refer to the Apply Dynamic Filters section.

Note: Each Dynamic Filter, whether defined at the dimension level, measure level, or chart level, appears as a popout menu at the top of the published chart. Users can select one or more values, and hovering over a filter displays a tooltip with the current selections.
Dynamic Filters in a published Pie chart

Reorder and Remove Fields

Fields can be reordered or removed from any section in the designer window.

  • Reorder Fields: Click and hold the 6-dot icon next to a field and drag it above or below another field.
  • Remove Fields: Click the X icon at the right of a field to remove it.

Add a Chart Description

Enter a Chart Description in the text field above the chart preview. The description appears at the top of the published chart.

Add a chart description

Export and Import Pie Chart Configuration

After creating or editing a chart, the chart configuration can be exported directly from the designer. This allows users to replicate charts across different environments without recreating them manually.

Export a Pie Chart Configuration

Click the Export icon in the upper right corner of the designer window to download the configuration file.

Export the chart configuration

Import a Pie Chart Configuration

When importing a chart configuration, the created chart must match the exported chart type to ensure compatibility.

  1. Click the New Visualization (+) icon and select Pie.
  2. After the designer window opens, click the Import icon in the upper right corner.
  3. In the popout, upload the configuration file.

Import a chart configuration

Note: Users with the Data Central Designer privilege can also export and import charts created by other users.

Toolbar Icons and Actions

Each chart includes a toolbar in the top right corner of the chart designer and published chart. Available icons vary by chart type and whether the chart is open in the designer or published. The following icons are available for a Pie chart.

Icon Icon Name Description
Edit Edit* Click to open the designer window.
Add Filter Add Filter* Click to open a popout and apply a Runtime Visualization Filter to the visualization. The filter displays in the Local section of the Filter Panel. When a filter is active, the icon is shaded blue and changes to Edit Filter.
3-dot 3-dot* Click to open a popout menu with additional visualization options.
Tooltips Tooltips Click to activate or deactivate tooltips that display when hovering over the chart.
Legend Legend Click to show or hide the legend. The legend displays by default.
Series Label Series Label Click to show or hide series labels within the chart.
Chart Notes Chart Notes Click to view Chart Notes added in Advanced Chart Settings.
Export Export Click to access a popout menu to print or export to PDF, PNG, or JPG.
Advanced Advanced** Click to open Advanced Chart Settings on the left side of the designer.
Dock Item Dock Item* Click to dock the visualization to the sheet.
Maximize Maximize* Click to maximize the visualization.
Restore Restore* Click to restore the visualization to its previous size.
Close Close* Click to close the visualization.

* Available in published chart only 
** Available in designer only

Note: A blue icon indicates that the option is active. A gray icon indicates that the option is inactive.

Advanced Chart Settings

Advanced Chart Settings provide additional options for configuring the chart's legend, color palette, and chart notes.

  1. To open the Advanced Chart Settings window:
    • Click the Advanced button in the bottom right corner of the chart designer window.
    • Click the Advanced icon in the chart designer toolbar.
    • The Advanced Chart Settings window opens on the left and displays the current settings.
  2. Legend Position:
    • Outside
    • Inside
  3. Legend Horizontal Alignment:
    • Center
    • Right
    • Left
  4. Legend Vertical Alignment:
    • Bottom
    • Top
  5. Palette & Custom Palette:
    • Select from the available color palettes. Material is the default.
    • Click the Toggle Custom Palette icon to open a custom color selector for the current dimension. When using Dynamic Dimensions, select another dimension from the popout as needed.

      Custom Palette Settings

    • For each unique value in the selected dimension, use the color picker, slider, RGB values, or Hex values to define a custom color.
    • Use the Reset Colors icon to restore the last configuration or the Clear Colors icon to restore the default palette.
    • Custom color selections are saved with the chart and preserved when the chart configuration is exported and imported into another chart.
  6. Chart Notes:
    • Add text to describe the chart. After a note is added, the Chart Notes icon displays in the toolbar.
  7. To close the Advanced Chart Settings window:
    • Click the X icon in the top right corner.
    • Click the Advanced button in the bottom right corner of the page.
    • Click the Advanced icon in the toolbar.
  8. Click Save to save the changes or Cancel to discard them.

Save and Save As

When creating a visualization, only the Save button displays in the bottom right corner. After the visualization is saved, both Save and Save As display.

When a saved visualization opens in the Chart Designer, the header displays the title followed by Preview. A blue badge to the right of the title shows the number of segments currently displayed in the visualization.

Pie chart preview

The Save Chart window opens when Save is clicked for the first time or when Save As is clicked.

Tip: Click Save As to duplicate an existing chart with a different name or save a new version with different settings. Click Save to update the existing chart.

Save Chart window

When the Save Chart window opens, enter or edit the save options.

  1. Enter the Name of the chart (maximum 100 characters).
  2. Select the folder where the chart is to be saved.

    Note: Users with the Data Central Designer privilege can also add a new folder by hovering over an existing folder and clicking the add folder icon. To edit or delete existing folders, click the Actions icon in the master header and select Manage Objects.

  3. Select the Public or Private radio button. Users with the Data Central privilege only see Private as an option. Public is also available to users with the Data Central Designer privilege.
  4. Select the Roles. This option is available when saving a public visualization and is grayed out for a private visualization. Users with the selected roles can access the visualization.
  5. Update the Scope. By default, the current study is selected. Use the drop-down lists for Therapeutic Areas, Compounds, Programs, or Studies to update the scope as needed.
  6. Click Save to confirm the save settings or Cancel to discard the changes.

Edit a Pie Chart

A Pie chart can be edited to update its data, description, and advanced settings. Chart settings in the Save Chart window can also be updated, including the name, folder, visibility, roles, and scope.

Note: The Data Central Designer privilege is required to change a private chart to public.

Edit Content

  1. Hover over the visualization to edit.
  2. Click the Edit icon. The Pie Designer window opens.
    Edit chart content

    Note: Users may also click the Edit icon in the published chart's toolbar to open the designer.

  3. Edit fields in the Dimensions, Measures, or Filters sections as needed.
  4. Edit the Description as needed.
  5. Update Advanced Chart Settings as needed.
  6. Click Save to update the existing chart or Save As to save it as a new chart.

Edit Settings

  1. Hover over the visualization to edit the settings.
  2. Click the Configure icon to open the Save Chart window.
    Use the Configure icon to edit settings
  3. Update the settings as needed.
  4. Click Save to confirm the changes or Cancel to discard them.

Delete a Visualization

Saved Visualizations, Workspaces, Filter Sets, and Advanced Filters are deleted from Manage Objects, available from the Actions icon in the master header. The Data Central Designer privilege is required to delete public items. All Data Central users can delete their own private items.

  1. Click the Actions icon in the master header, then select Manage Objects. The Manage window opens.
  2. Hover over the name of the item to delete.

    Tip: Hover over the icon to the left of the item name to view a tooltip that identifies the item type, such as Saved Workspace, Advanced Filter, or a visualization type.

  3. Click the Delete icon.
    Delete a visualization
  4. In the Delete Item confirmation window, click Delete to delete the item or Cancel to cancel the action.

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request