Creating dashboards from an SQL query

To create new dashboard

1. Perform one of the following steps:

1. 
   
   • On the Home page, click Add  and select New dashboard.
   • From the navigation menu , click Dashboards. On the Dashboards page, click New, and then click New Dashboard.
2. On the New dashboard page, click Add visualization.

3. In the Query section, perform the following actions:

   • Select BMC Helix as the data source.
   • Select Service Management as Query Type.
   • Select SQL as Type.

   • Select Table in the Format As field.

     Important

     You can select Time series in the Format As field for Pie chart and Graph visualizations. For remaining visualizations, you must select Table in this field.

   1. In the SQL Editor, paste the SQL query that was copied and modified in Exporting-and-modifying-an-SQL-query-from-BMC-Helix-ITSM-Smart-Reporting.
      
      
      
      

4. Select the appropriate visualization panel.
   
   
   
   Based on the visualization panel type, you can make changes to the display parameters and configurations. The following table provides few examples of display parameters based on the visualization panel:

   The [confluence_table-plus] macro is a standalone macro and it cannot be used inline. Click on this message for details.
   This macro generates standalone content. As a consequence you need to make sure to use a syntax that separates your macro from the content before and after it so that it's on a line by itself. For example in XWiki Syntax 2.0+ this means having 2 newline characters (a.k.a line breaks) separating your macro from the content before and after it.
   
   

5. Once finished, click Save. 
   You will see your report in BMC Helix Dashboards now.