Edit Widget

Editing widget is the most important part of the creating a widget especially for creating charts and tables. For creating chart or table firstly you must create empty widget.

1. To edit empty widget, click on show query.

2. Metrics can be added with three different methods.

a. Query of your data can be added from SQL Content

b. Import Query, prepared query can be imported from import query.

c. Metrics can be added by selecting from list. Click on add new query button and select the proper options.

3. To change display or add filter click on query settings.

4. Field details are below.

Introduction Fields

This fields are common for every option of output.

• Icon: Select icon of widget

• Title: Write the title of widget

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

• Output: Select the how to display option (charts, table, summary) of your data.

• Filter: Filter your data from this field. Click on pen.

Date & Forecast

This fields are common for every option of output.

• Date: Select the time range of widget.

• Forecast: Select the time for forecasting. This option can be disabled.

• Time Zone: Select the time zone from list.

• Aggregation: Select type (sum, avg, max, min, last, first) of aggregation. This option can be disabled.

• Aggregation Interval: Select interval for aggregation.

Chart

This fields are displayed when one of the chart type selected.

• Legion Position: Select the legion position (table, left, right, top, bottom) from the list. This option can be disabled.

• Tooltip Interaction: Select the tooltip interaction (index, point) from the list. This option can be disabled.

• Size: Select the size of chart output. This option will adjust the zoom.

• Order Direction: Select the order direction (ascending, descending) to order the legions.

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

Data Table

This fields are displayed when one of the datatable selected.

• Time series: Select an option between true and false. If it is true, date will be displayed. If it is false, date will not be displayed.

• Show Links: Select an option between true and false.

• Mode: Select an option between basic, advanced and log content

• Live Update: Select an option between true and false.

5. After updating the fields, you have to click on save query.