Edit Widget
Last updated
Last updated
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.
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.
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
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
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.
