To create a barchart, click on the barchart icon in the first tab of the configuration menu:
This adds a new barchart at the top of your dashboard:
There are several points to notice:
- The widget has a blue border around it. It means it is selected.
- The configuration menu automatically switched to the "widget configuration" tab (the second one). This tab always show the configuration of the selected widget.
As indicated by the widget, you must select a datasource where the widget will query its data. To do so, in the source field, select one datasource. When a source is selected, the next steps of the configuration are available in the configuration menu:
To show data in the barchart, you need to provide the dimension to use on the X axis, and at least one measure in the Data section:
The provided configuration queries the datasource, asking for the "sum of column price grouped by Country". In this query:
- Country is the dimension
- Price is the measure (also called metrics)
- The aggregation operator is "sum"
In the previous example, all the rows from the datasource were used. In many cases you want to add a filter on them to apply your query only to specific rows. To add filters, use the "Filters" section. Each filter requires a dimension, an operator and a value (although some operators such as "is_empty" do not require a value).
For example, to exclude rows having Country=USA in the above example:
Note that the operator "!=" means "different" in Serenytics.
Add a dynamic filter in the widget
In the above example, the filter was selected once and for all in the widget configuration (we call this a static filter). But in many cases, we want the viewer to be able to modify the filters himself.
To do that, you need to add a "dynamic filter" in the Filters section. Just select the dimension of the filter (e.g. "Category" in the example) and automatically, a selector will be shown at the top of the widget filled with all the possible values.
Open a dashboard in Viewer mode
So far, you have only seen the dashboard in studio mode (i.e. with all the options to edit it). To open it in Viewer mode, in the "Sharings" tab, click on "Open in Viewer mode":
This will open the dashboard exactly as other viewers will see it once you have share it with them. Note that on the left side of the viewer mode, there is a bar allowing the viewer to list all his dashboards and to logout.
To know how to share your dashboards to a list of users, read the dedicated tutorial.
Following this tutorial, you are now able to create your first dashboard. As your modifications are applied immediately to your dashboard and visible, do not hesitate to try all the options, that's the best way to learn.