Edit Widget

Editing is the most important part of creating a widget, especially for charts and tables. To able to create a chart or table, you must first create an empty widget.

1. To edit an empty widget, click on Show Query.

2. Metrics can be added using three methods:

a. Add the query from SQL Content:

b. Import the query with Import Query:

c. Add metrics selected from a list.

3. To change the display or to add a filter, click on Query Settings.

4. Details of the field can be found below.

Introduction Fields

These fields are common to all output options.

  • Icon: Select the icon of the widget

  • Title: Write the title of the widget

  • Group By: Select the type of device which aggregates the data based on the specified type

  • Output: Select the display option (charts, table, summary) for your data

  • Filter: Filter your data using the field. Click on Pen.

Date & Forecast

These fields are common to all output options.

  • Date: Select the date range of the widget

  • Forecast: Select the forecasting time. Can be disabled

  • Time Zone: Select a time zone from the list

  • Aggregation: Select the type of aggregation, i.e. sum, avg, max, min, first, or last. Can be disabled

  • Aggregation Interval: Select the interval for aggregation

Chart

These fields are displayed when one of the following chart types is selected

  • Legend Position: Select the legend position: table, left, right, top, or bottom. Can be disabled

  • Tooltip Interaction: Select the tooltip interaction: index or point. Can be disabled

  • Size: Select the size of the chart. Adjusts the zoom level

  • Order Direction: Select the ordering direction: ascending or descending

  • Top Rows: Select the number of rows you want to display

Data Table

These fields are displayed when one of the following datatables is selected.

  • Time series: true or false. If true, date will be displayed

  • Show Links: true or false

  • Mode: basic, advanced, or log content

  • Live Update: true or false

5. After updating the fields, you have to click on Save Query.

Last updated