Word Cloud

You can use this visualization to see a set of words, where the size and placement of a word is determined by its weight. The more important the weight, the bigger the font. You can add colors, shading, and many options.

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 the visualization dimensions by selecting fields. By default, Data Perspective Studio suggests the dimensions available in the data query result set.

  1. In the Properties panel, go to Data.
  2. In Set X dimension, select the field to use.
  3. Optional: Click More options to open advanced configuration properties.

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.
  4. For Maximum values to retrieve, specify the maximum of words to show in the cloud.
  5. For Label, enter a tooltip label for the measure.

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

Define the Text Colors

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. 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.

  3. Select Use shades, to apply shades to the selected color.

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 the Chart Title

  1. In the Properties panel, go to Style.
  2. Specify the chart title.

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

  3. Select the icon that represents your chart.
  4. In Layout Type, select how to show the word cloud, from horizontal, Crossed, or Random.

Add On-click Actions

You can specify actions to run when you click the chart.

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

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