Working with Activeboard widgets
After creating your Activeboard, you can start adding widgets and feeding them with the required data sources. Everything you need to know about working with widgets is explained in the following articles, but you can start watching the following video to see the first steps you need to follow to build an Activeboard—from the creation of the source query for a widget, to the customization of the data retrieved.
Create a widget
To create a widget from scratch:
- Click the Widgets button at the top of the Activeboard, then click and drag your selected graph style to the Activeboard workspace.
Now select the data that will feed your widget. Click the Data button at the top of the Activeboard. You can choose from several methods of identifying the data source for your widget:
Free text query Last queries Select from a list of queries you have recently run in the domain and drag it to the widget on the Activeboard. Learn more about recent queries here. Favorite queries Select from a list of the queries that you have marked as favorites and drag it to the widget on the Activeboard. Learn more about favorite queries here.
If the data in the query meets the data requirements of the graphic you selected, the new graphic will appear right away. However, you may need to specify which fields of data in the query you want to use to draw the widget. To do so, select the widget title bar to display the settings pane which will appear to the right. Review and edit the settings in the Data tab as needed.
ID This is a unique name for the widget used for internal calls, such as referring to data in the widget from another widget's script. It is auto-generated and cannot be modified. Name The name of the widget. This is the friendly name that appears in the widget title bar in the Activeboard. Description Enter a meaningful description of the widget. Data Source This is the query that feeds data to the widget. Click the Edit button to open the Query Editor, where you can edit and update the widget's query script. Learn how to build your widgets source queries in the section below. Custom Date Range
(Optional) Toggle on this option to set a date range to apply to the widget and its dependencies, overriding the date range set for the Activeboard.
Widgets with a custom date range show the calendar icon in their top right corner. Learn more about setting time ranges here.
The settings available in the Visual tab will depend upon the type of graphic chosen for the widget. Learn more about each type of widget and its settings in the following articles.
The yellow play appears on widgets whose source query is not optimized, that is to say, a data source has not been defined from the source query of the widget. To optimize the widget performance, copy the widget source query and generate a data source from it. The data source will be automatically used in the widgets that are fed with that query. Learn how to generate a data source in the Set up a data source article.
- Even though your query is optimized with a data source, you may still see the icon in your widgets. This happens when the date range set for the Activeboard is not within the data source time range. For example, if your data source start date is February 15, 2019 and you set your Activeboard time range to 01/01/2019 - 01/30/2019, your widgets will show the icon.
- Note that the icon will never appear when you select a period of time of less than one hour for your Activeboard or widget, even though your widget query is not optimized.
In case of any problem, contact the Devo support team for further information.
Building your widget's source query
The free text query editor in Activeboards uses the standard LINQ query language used for searching data in Devo. However, it is necessary to encapsulate the script within parentheses preceded by the word query. For example:
query(from demo.ecommerce.data select *). Devo automatically encapsulates your LINQ query if you don't do it, but you can also add it manually.
Other cases that need the addition of specific operators to the widget query are the following:
Limit the events of a widget query
You can limit the query events represented in a widget using the
Add this operator to your query to discard the oldest number of events. If there aren't enough events available, the maximum number of events will be discarded. For example, a widget with the following source query will represent all the events in the selected time range except for the five oldest events.
Add this operator to your query to show only the oldest events. If there aren't enough events available, the maximum number of events will be shown. For example, a widget with the following source query will only represent the 10 oldest events that arrived in the selected time range.
You can use both operators at the same time to get a specific window of events within a time range. For example, the following query will discard the five oldest events and will only show the 10 oldest ones from the remaining set.
query (from demo.ecommerce.data group every 0 by statusCode offset 5 limit 10)
When you use both operators, note that the order matters; if you use
offset, events will be discarded from the set of events specified in the
limit parameter. So, if we switch the order of the operators in the previous example, query events will be first limited to the 10 oldest ones, and then the five oldest ones from that set will be discarded.
query (from demo.ecommerce.data group every 0 by statusCode limit 10 offset 5)
For a more visual approach, you can see all this explained in the following video:
Connect a widget to an input
When you add inputs to your Activeboard, the widgets linked to them must reference the input name in their queries to work properly. Depending on the type of data, you need to add a different expression. Learn more here.
By default, widgets connected to an input don't show any data before you enter or select a specific value in the corresponding input. However, you can make them show data (either a query data or a specific value) before using the input. This is made adding a specific operator to the widget query. Learn more here.
Click the ellipsis button of a widget to access the following options:
|Go to query||Take you to the search window and show the table constructed with the query that feeds the Activeboard.|
|Expand||View the widget in full-screen mode.|
|Edit||Access the widget configuration options.|
|Clone||Copy the widget in the Activeboard.|
|Export to CSV||Download a table with the widget's data in a CSV file.|
|Delete||Remove the widget from the Activeboard.|
The following articles describe each of the available widgets you can create in an Activeboard:
- Area chart widgets
- Column chart widgets
- Donut chart widgets
- Heatmap widgets
- Line chart widgets
- Pie chart widgets
- Simple value widgets
- Table widgets
- Voronoi diagram widgets