Table

This visualization lets you configure column visibility and order, sort and filter rows, and show rich value renderers (value, percentage, trend, icons, badges, timeline…).

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.

Format the Display of Column Elements

You can define the formatting of the elements contained in your table columns.

  1. In the Properties panel, go to Data.
  2. In the Column Configuration section, choose the column field on which you want to apply some formatting.
  3. Click More options.

    A panel appears on the left.



  4. In the Colors section, select the colors to apply to the field values.
    OptionDescription
    Color

    This is the default color associated with all field values.

    Palette

    Associates field values to colors automatically.

    There is a limit in the number of colors available. Data Perspective Studio reuses the same colors when the number of values crosses this limit.

    Important: The Palette colors are common to all visualizations in your app for consistency.
    Customize

    You can search for values and customize their colors.

    There is a limit to this customization, which blocks the option when there are more than 100 values.

    Important: The colors in Customize apply to the current visualization only.
    Additional mapping

    You can define conditions to apply colors, by defining a Comparator and an associated Value.

    For example, you can define to associate a color when the value is inferior (<) to the expected value.

    matches: allows you to specify a regular expression to choose the color or the icon to apply, depending on the value for the selected field.

    Note: There are priorities if you define several colors for the same field value. Manual customizations first, then colors defined for additional mapping, and at last, the default color.

  5. From Column Width, you can specify a factor to increase the column width based on the global table width.



Use Dynamic Columns

The Table visualization can show columns that do not come directly from data queries, but that data queries return dynamically. As you do not know the column names, it uses a field of MAP type, containing the field name as key, and it associated value.

  1. In the Properties panel, go to Data.
  2. In the Dynamic Columns section, select the Values map field, that contains the column names.
  3. Select Visible by default to show all dynamic columns by default.

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.



Add On-click Actions

You can add effects when users click table cells.

  1. In the Properties panel, go to Actions.
  2. Click to add a new effect.
  3. Select the effect Behavior.
    OptionDescription
    FilterFilters screen data with the content dropped on the screen.

    Information source: Specify the field to filter data.

    Target studio variable: Select the data query variable to store source data.

    Set variableSpecify the variable that stores the data.

    Target studio variable: Select the data query variable where Data Perspective Studio stores source data.

    Navigate to screenSelect 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.