Configure proportional widgets for modern dashboards

  See this video: A Step-by-Step Guide to Building Modern Dashboards on the Orion Platform ‚ SolarWinds Lab #93. /archive/sw-videos.htm?uuid=w42w06lazt&title=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 other information about 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. You can also set how often you want data in the widget to refresh. See Refresh rate.

6. To make the widget header hidden by default, select the Collapsible box. To expand the header on the widget, click the line on the top of the widget. To hide the header again, click the arrow signs.

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.

      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.