Visualization

Vizualization Dashboard

If you have already generated visualizations, you will find them under this tab. You may now gain insights into your data using several forms of visualizations.

Visualization Dashboard

By clicking on the ellipsis icon on the right side of the visualization record, you can remove, clone, or edit the reporting frequency of the visualization.

Report Enabled

Creating New Visualization

To create a new visualization:

1. Click on the + icon in the tabs beside visualizations to create the new scratchpad or go to visualization tab and click on Create Visualization buttone on top left.

2. Select the Datasource from the Datasource dropdown on the left and then select Schema for the selected datasource.

3. Click on any table group in the left sidebar and select a table. It will open the editor on the right pane with a default query pre-populated.

4. You can edit the query as required and then click on Execute Query button to execute the query.
5. A sample of the output records from the query will be shown in the sample data section at the bottom.

Note Sample data section as two views: table view and JSON view. If the output has many nested fields you can switch the view to JSON by clicking on the Format dropdown and selecting JSON option to view the data in an hierarchical manner.

6. Select the the type of visualization you want to create from the Visualization Type section.

7. Select the value to be plotted on the X axis from the dropdown in the X Axis section and give it a label and select a formatter for the value from the X Axis Formatter dropdown.

8. Similarly select the field for the Y Axis and give it a label and apply the required formatter.

9. If required select one or more fields in the Group By section to group be data by those fields. A dropdown will appear on the top right corner of the chart with all the unique combinations of the group fields selected and first five values selected by default. You can select more values by clicking on the group by dropdown.
10. There is also an option to filter the data plotted by a particular field. Select the filter field from the Filter section and a dropdown will appear on the top right corner of the chart with all the unique values of that field and you can select the value from it to plot only data points corresponding to that value of the filter field. You can use the equals, not equals, and NOT IN operators to apply filters.
11. Click on the Save button on the top right corner above the editor, a popup form will appear. Fill the required fields and save the visualization.

Note Only alphanumeric values and - is accepted in the name field.

12. Click Save to save the Visualization. Once saved it can be added to any dashboard.

Note One visualization can only be added to a single dashboard. In case you want to add same visualization to two or more dashboards. Use the clone feature to clone the visualization and save it with a different name and then add it to the new dashboard.

Creating a List View or Table Visualization

1. Follow the steps 1 - 6 in the Creating New Visualization section and select List View or Table from the Visualization Type section.

Note Most of the features of List view are only supported on mongo datasource. If you are using a different datasource please use Table Visualization.

2. Select the field for the the List View/Table from the column dropdown, give it a name if required and apply the suitable formatter from the Formatter section.

3. You can add more columns by clicking on the green + icon on the right end of the last column.
4. Save the Visualization by clicking on the Save button on the top right corner above the editor and filling the required details.
5. The new visualization can then be added to any dashboard.

Adding Grouped View to a List View

1. Select the Group By option for the fields you want to group the data.

1. Click on the Group Query tab in the Editor (appears only when the visualization type selected is list view).
2. Add the Query for the group view in the Group Query tab.

3. Add the following $group stage at the end of the query pipeline.

xxxxxxxxxx

{

  "$group": {

    "_id": "$${groupkey}",

    "groupkey": {"$last": "$${groupkey}"}

  }

}

Note Group View query needs to be an aggregate query.

4. You can add more fields as required to the last $group stage.
5. Then select on of the group by fields from the group dropdown located at top right corner of the table and execute the group query.

6. Click on the List View Group Fields section to expand it and add the required columns for the group view.

7. Save the Visualization and add it to a dashboard and the group view dropdown will be available on the top right corner of the table.