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