Multi KPI

You can use this visualization to show the values of metrics. For example, sums in dollars by country.

This task shows you how to:

See Also
Configuring Visualizations

Define the Data to Show

  1. In the Properties panel, go to Data.
  2. Select a data query and a Result Set.

Define the Dimension

You can configure a dimension by selecting a field. By default, Data Perspective Studio suggests the dimensions available in the result set.

  1. In the Properties panel, go to Data.
  2. In Dimension, select the field to use.
  3. Optional: Click More options to open advanced configuration properties.
  4. From Limit, select the maximum number of categories to display for the dimension.

Override the Category Name

You can replace the dimension name on the UI. This is useful since fields often have technical names that are not presentable.

In Override category name, enter the name to show on the UI.

Note: To localize this title in other languages, click , and select a translation key. You define keys and translation values in the Translation menu.

Define the Measure

You can configure the measure to show in the visualization. By default, Data Perspective Studio suggest the measures available in the data query result set.

  1. In the Properties panel, go to Data.
  2. Select a Measure.

    Data Perspective Studio lists the numerical fields, and the aggregation functions defined in the data query. The default aggregation is COUNT.

  3. Optional: Click More options to open advanced configuration properties. For example, you can select a currency format like USD.

Show Underlying Data in a Data Panel

You can add a Show underlying data action in the Actions menu of most charts. On-click, Data Viewers can see more information about chart data in a data panel at the bottom of the page.

  1. In the Properties panel, go to Data.
  2. In the Data Panel section, select Enable Data Panel.
  3. From Fields, add the fields that you want to see as table columns in the data panel.
  4. Optional: Select Allow to reorder columns if you want Data Viewers to be able to reorder columns by dragging their headers.
  5. Optional: From Buttons, define the icons (and their on-click effects) to show in an Actions column.
  6. Optional: Select Add drag button in the first column to add a drag icon in that column for users to drop objects in another 3DEXPERIENCE platform widget.
    1. In Information source, select the field to use as data source.
    2. In Object type, specify the name of the object to drag.
    3. For 3DEXPERIENCE Service, select the variable which contains the id of the 3DEXPERIENCE platform service. For example, 3DSpace.
  7. Optional: Select Add "Open with" in the actions column to add a button allowing Data Viewers to open an object in another 3DEXPERIENCE platform app. For example, 3D Markup, CATIA V5, Product Explorer, or Product Structure Editor.
    1. Optional: Enter the Label to show on the Open with button.
    2. In Icon, specify the button icon.
    3. Optional: You can also add a tooltip and a theme.

  8. Optional: From Effects (On checkbox click), you can define an interaction with a 3D Widget outside of your Data Perspective app to select a part. When the Data Viewer clicks a 3D object in the data panel, the 3D Widget refreshes to show corresponding data.

    Note: To do the opposite, that is, click an object in a 3D Widget and refresh the Data Perspective view, use Effects (On 3D Selection).

  9. Optional: From Effects (On 3D Selection), you can define how the data panel reacts, when the Data Viewer clicks a 3D object in a 3D Widget outside of your Data Perspective app. The Data panel refreshes to show the data selected in the 3D Widget.

Reduce the Scope of Dimensions with Local Filters

For a visualization that displays data for a dimension (for example, in a chart axis), it may be useful to focus on specific values for that dimension. You can do so using a local (internal) filter.

For example, if you have a priority dimension that contains Very Minor, Minor, Major, and Critical priorities, you may want to display values for the Major and Critical priorities only.

Important: Unlike Filters, you cannot select Local Filters on the visualization UI.

  1. In the Properties panel, go to Data.
  2. In the Local Filters section, specify the dimensions for which you want to filter data out as follows:
    1. From Field, select the dimension on which you want to apply the filtering.
    2. From Filtering mode, select Include or Exclude.
    3. From Values, select the set of values to include or exclude from the dimension.

    For example, for the Status dimension, you can exclude NULL values.



Define an Icon and Colors

  1. In the Properties panel, go to Style.
  2. For Icon, select the icon that represents the KPI.
  3. For Background color, select the color to apply in the visualization background.
  4. For Text color, select the color to apply on text elements.
  5. For Figure color, select the color to apply on the KPI figure.

Add Actions to the Actions Menu

You can add actions to the list of available actions, in the upper right of the visualization.

  1. In the Properties panel, go to Actions.
  2. Click to add a new menu action.
    OptionDescription
    Label Enter the action label.
    Icon Specify the icon associated with the action.
    Effect (On click) Select the destination screen to open when you click an object.

    Target screen: The destination screen where the user goes after clicking an object. For example, for a visualization showing risks, clicking a risk could redirect the user to a details page.
  3. Optional: You can add specific menu actions for reached targets.

    When the KPI value matches the condition specified in Targets, the actions menu displays these additional actions.

Add a Target

You can add a target indicator to the chart to let users compare the KPI value with the target value.

  1. In the Properties panel, go to Targets.
  2. Choose how to define the target value.
    • Select Custom value, and specify a numerical Value. For example, 5.
    • Clear Custom value, and specify a Target measure.
  3. Optional: Click to add a Conditional display.
    1. For Type, select the condition comparator. For example, select <= if you want the condition to apply only if the field value is lower or equal to the Value.
    2. For Color, select the color to apply when the value matches the condition. For example, green.
    3. For Icon, specify the icon to show when the value matches the condition. For example, a cog.
    4. Select Use for menu, to show additional menu actions when the value matches the condition.

      To add additional menu actions for reached targets, see Add Actions to the Actions Menu.

      Note: When the value matches the condition, an orange circle appears above the visualization actions, and the actions specific to reached targets.

  4. Select Display target, to show Target: <value> below the KPI value.