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
, orlast
. Can be disabledAggregation 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