Define a Ratings Column for a Matrix Widget

Use the Columns page (in the Matrix Widget Properties window) to define how a ratings column looks and behaves on a Matrix Widget.

A ratings column shows a number of images based on a value. For example, you could show a star for each Incident closed by a technician.

Good to know:

  • Calculated columns are calculated after all numeric columns have been retrieved.
  • Calculated columns cannot query themselves.

To define a ratings column for a Matrix Widget:

  1. Create a Widget.
  2. In the Type drop-down, select Matrix.
  3. Click the Columns page.
  4. Click Add>Calculated column.
  5. Define how the rating will be calculated:
    1. Click the Calculated Value page.
    2. Click the Selector button Selector button, and then select the Tokens (System Functions, Expressions, Stored Values, Metrics, and/or Counters) and math operators to build the calculation.
  6. Define how the ratings column will look:
    1. Define the following:
      • Image Width:

        Specify the width of the image for display.

      • Image Height:

        Specify the height of the image for display.

      • Image:

        Select the image to open the Image Manager, and then select an existing image or import a new image to represent the item in the UI.

        • Select the Image Expression check box to use an Expression to change the image based on conditions. Then, click the Custom Expression button Expression Button to open the Custom Expression Builder and create a custom Expression. If no special condition applies, then the default image is used.
      • Maximum rating:

        Select this check box to impose a cap on the number of images to show, and then specify the maximum number.

      • Show partial ratings:

        Select this check box to show fractions of values (example: 2 ½ stars).

      • Stretch image:

        By default, a new version of the image is shown for each value, so the value 10 would be represented by 10 stars. However, you can instead have the rating column stretch out a single version of the image based on the rating. This can be effective with certain images that stretch well, but might look odd with other images.

  7. Select OK.