Documentation forSolarWinds Platform

Configure proportional widgets for modern dashboards

This topic applies to all SolarWinds Platform products.

  See this video: A Step-by-Step Guide to Building Modern Dashboards on the Orion Platform ‚ SolarWinds Lab #93. | Read the THWACK Post

Proportional widgets display your data as pie charts, donut charts or stacked bars. You can use them on modern dashboards.

How to configure proportional widgets

  1. Configure the title and other labels for the widget (Presentation)
  2. Select chart type and legend (optional).
  3. Configure what should be displayed by the widget (Data and Calculations).
  4. Save Changes.

See Edit widgets for details on resizing widgets, changing widget position, or deleting widgets.

Step 1: Provide labels for the widget

  1. In Presentation, expand Title and description.

  2. Provide the title and subtitle.

  3. If you want to have a link with more details on the widget, provide it in the Widget link URL.

  4. You can also provide a description that might help others to reuse the widget.

  5. Starting with Orion Platform 2020.2.5, you can also set how often you want data in the widget to refresh. See Refresh rate.

Step 2: Define the look of the widget (optional)

By default, proportional widgets use the pie chart and the legend is on the right. You can change the look.

  1. In Presentation, expand Chart Options.

  2. Select what should the widget look like - pie, donut, vertical bar or horizontal bar.

    Donut

    Pie chart

  3. In Legend, specify where you want the legend to be.

Step 3: Specify what should the chart display (Data and calculations)

We will use an example where the widget displays the number of monitored nodes grouped by their status.

  1. Expand Data and Calculations.

  2. Define the data model:

    Using the graphical query builder

    1. Select Use the graphical query builder and click Edit.

    2. Select an entity and click Next.

    3. On Edit tabular data model, drag the database columns you want to see in the widget.
      1. Select Show advanced entities and properties.
      2. Search for Status.
      3. Drag Status to the Columns field.
      4. Click Save model.

        5. The columns you select here appear in the drop-downs in Data Calculations.

    Manually

    1. Select Hand-edit a SWQL Query and click Edit.

    2. Copy the following query into the SWQL query field and click Save model.

      SELECT COUNT(NodeID) as value, Status as status FROM Orion.Nodes GROUP BY status ORDER BY value DESC

  3. In the Value field, specify the values you want to see in the chart.
    Select value. You want to see the number of nodes in individual statuses, not numbers corresponding to individual states.

  4. In the Category field, specify the metric you want to group the entities by.
    For example, to group nodes with the same status, select 'Status' here.

  5. In the Data Format field, select the metric you want to convert the query result to.
    To group nodes by status, select Orion Statuses.

    If you select Custom in the Data Format field, you need to specify Icon Mapping and Color Mapping in the query. See SWQL example with color definitions.

  6. Click Save Changes.

The scripts are not supported under any SolarWinds support program or service. The scripts are provided AS IS without warranty of any kind. SolarWinds further disclaims all warranties including, without limitation, any implied warranties of merchantability or of fitness for a particular purpose. The risk arising out of the use or performance of the scripts and documentation stays with you. In no event shall SolarWinds or anyone else involved in the creation, production, or delivery of the scripts be liable for any damages whatsoever (including, without limitation, damages for loss of business profits, business interruption, loss of business information, or other pecuniary loss) arising out of the use of or inability to use the scripts or documentation.