Visualization

Visualization 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 button 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.

{

  "$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.

Creating Visualization for Killed Queries

On the Dashplots page, you can create visualizations by configuring the data source as "Mongo" and the schema as "Alerts". Once set up, you gain valuable insights, including:

• The queries or applications that have been killed the most times.
• The number of queries or applications terminated daily, weekly, or monthly.

Highlight Result Data with Color Codes

Pulse enables you to highlight Custom Dashplots results using color codes. Rows or columns that meet the specified conditions are highlighted as configured, making it easier to identify and track data points in larger clusters.

1. On the Dashplots-Studio page, create a New Scratchpad or Visualization.
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. A sample of the output records from the query will be shown in the sample data section at the bottom.
5. You can edit the query as required and then click on Execute Query button to execute the query.
6. Select a Table or List View type of visualization from the Visualization Type section. The result is displayed.

7. In the Results Grid:

   1. Select a column from the drop-down and Enable Highlight.

   2. Specify the highlight type (row or column), choose the highlight element (background or text), and define the value type (number or text).

   3. Configure values and assign color codes accordingly.

   4. Add or remove fields using the "+" and "-" options.

   5. Set multiple values or text fields with different colors for highlighting using the "Add Color Threshold" option. For example:

      1. In the Final Status column, assign different colors to highlight "Succeeded" and "Failed" statuses.

         1. For the value type "Text", the text is highlighted with the assigned color only if the cell value matches the specified value, including case sensitivity.

      2. In the Elapsed Time column, apply different colors to specific values (e.g., 5,000, 10,000, 15,000 seconds) to represent the time taken for a job, task, or process to complete.

         1. For the value type "Number", highlighting is applied only when the number exceeds the configured threshold. If multiple thresholds are defined, the color associated with the highest exceeded threshold is used.

         2. Example Configuration:

            • 5000 - Yellow
            • 10,000 - Orange
            • 15,000 - Red

         3. Example Scenario: If the value in the "Runtime in Seconds" column is 10,500, it will be highlighted in Orange, as it exceeds both 5,000 and 10,000, but the highest exceeded threshold is 10,000.

         4. Highlighting Behavior:

            • Values between 5,000 and 9,999 are highlighted in Yellow.
            • Values between 10,000 and 14,999 are highlighted in Orange.
            • Values of 15,000 and above are highlighted in Red.

This capability helps visually differentiate numeric values based on their thresholds.