The Data panel enables you to query and display data for a selected widget. It also allows you to:

  • Construct queries that span your environment.

  • Query using attributes and relationships that are important.

  • Quickly get to the data you need even if you don’t know the metric path.

  • Construct more sophisticated queries.

  • Query both metric and analytics data in the same query.

Data Queries 

The Data panel is structured around queries. Each query follows a sentence-like format, starting with a selection of the data type of the query. Many fields in the Data panel support typeahead functionality. 

Consider an example where you want to know errors per minute for the nodes in an application:

  1. Choose a value from the Show me data for dropdown based on the data type you wish to display.

    Show Me Data For Value

    In this scenario, select Applications.
  2. The subsequent inputs shown in the Data panel are specific to the data type you selected in the previous step. In this case, it is the Application dropdown which lets you select the application for which you want to drill down the data. 

    Application Menu

  3. The next dropdown is Metric. The Metric dropdown changes depending on the data type. For instance, the node displays two more inputs before you select the metric. 
  4. Select the metric you wish to display on the widget. The More icon available on the right-corner of the Data Panel allows you to set the limit and baseline. 

    Data Panel

    Once you have specified valid inputs for all fields in the query, the widget is updated on the canvas to show the query result.

ADQL Queries

ADQL (AppDynamics Data Query Language) Query is a metrics query available in the Data panel for dashboards created in Dash Studio. This query allows you to filter and create customized metrics for Analytics data.

ADQL Query data binding uses Analytics queries written in ADQL. After selecting the ADQL Query option from Show me data for dropdown, you can either type or paste an ADQL query. See ADQL Reference for the syntax of these query statements.

You must enter a valid ADQL Query for series in order to see data reflected in the Time Series widget in Dash Studio. The ADQL query statement must include the 'series' expression, else it does not display a series. ADQL Query is currently available only for the Time Series widget.

After you type or paste the query in the input field, moving the cursor away from the input field automatically validates the query. For a Valid ADQL Query, displayed in green as shown below, the data is displayed in the widget on the canvas. In case of an invalid query, an error message is displayed in red.

Valid AQL Query

Variables in ADQL Queries 

Variables in ADQL queries enable you to dynamically change the values passed into the queries.

Consider an example where you want to use a variable for an application within an ADQL query:

  1. Click + Add Variable under the Dashboard Variables panel.  

    Add Variable

  2. Enter a value in the Variable Name field and select the variable type in the Type dropdown. 

    Variable Name Value

  3. Select an application in the Application dropdown.

    Application Menu

    The subsequent inputs shown in the Dashboard Variables panel are specific to the data type selected in the previous step. In this case, it is the Initial Values dropdown, which lets you select the business transaction for which you want to drill down the data. 

    Dashboard Variable

  4. Select the Show in View Mode checkbox after selecting the Initial Values.



    Click the widget to change Data Panel from variable data to widget data.
  5. Choose a value from the Show me data for dropdown. 
    In this case we select ADQL Query. After selecting ADQL Query, enter the query in the ADQL Query field as shown below:

    ADQL Query

    On entering a valid query, the widget appears as displayed in the following image:

    Valid Query

  6. Click View on the top-right of the screen and the subsequent dashboard screen allows you to change the application by clicking the $app dropdown.



Server Metrics 

Server Metrics, also known as the Server Infrastructure Monitoring (SIM) Metrics is a data binding option available in the Data panel of the Dash Studio. This option allows you to filter and create customized metrics for server monitoring.

Follow the steps below to filter and create customized metrics for one or more servers:

  1. Click Show me data for dropdown and select Servers from the dropdown.

    Show Me Data For Servers

  2.  Click Application dropdown and select the application for which you want to drill down the data. 

    Applications


  3. Click Select a Value and choose either of the following options:
      • All Servers: This option shows data across all applications. If you select this option, then the Application selected in the previous step becomes optional. If you select All Servers, the next input field in the Data panel automatically changes to Metric. Select the metric value you wish to display on the widget from the dropdown or by manually entering a value in the input field.

        All Servers

        If none of the applications are selected, then the widget displays data only for stand-alone applications and not for the ones included in the application tree.

      • Named: This option lets you specify individual servers known to the specific application that you chose in step 2. If you select Named, the next input field in the Data panel changes to Server. Select one or more servers from the Server dropdown and the metric value from the Metric dropdown.

        Named Serversr

      • Within: This option lets you select the tier or tiers of the server you wish to display in the server chart.

Database Metrics

Database Metrics is a data binding option available in the Data panel of the Dash Studio. This option allows you to filter and create customized metrics for database monitoring.

Currently the Metric Number widget does not support Database metrics.

Consider an example where you want to monitor a specific database or multiple databases as follows:

  1. Click Show me data for dropdown and choose Databases from the dropdown. 

    Show Me Data For Databases

  2. Click Type and select the required database from the dropdown to display the metrics on the widget. 

    Click

  3. Click Select a Value and choose one of the following options:
    • All Databases: Displays data for all the databases.

    • Named: Displays data for a specific database. The required database can be selected from the subsequent input field Database that appears on selecting Named.
  4. Click Metric and choose the metric value. You can also enter a value in the input field manually.

    The database metric chart appears.

    Database Metric Chart

JMX

JMX (Java Management Extensions) is a data binding option available in the Data panel for dashboards created in the Dash StudioThis option allows you to filter the entities by nodes and monitor the JMX metrics for the given set of nodes. 

Consider an example where you want to monitor JMX metrics of a node or multiple nodes:

  1. Click Show me data for dropdown and select JMX from the dropdown.

    The subsequent inputs shown in the Data panel are specific to the data type selected in this step. 
  2. Click Application dropdown and select the application for which you want to drill down the data. 
  3. Click Select a Value and select a node filter from the dropdown.


  4. Select a JMX metric. You can enter the name of the metric in the field manually or select from the dropdown.
    This list is dynamic.
  • Entries are not displayed if the selected entry is not a Java application or if no JMX metrics are currently available on the selected application.
  • The metric selector parses the Java Application metric tree dynamically for all available JMX metrics and displays them as a flattened list.

  • Currently, only the JMX metrics that are 2 levels deep from a JMX folder in the metric tree are available in the Dash Studio.

Backends 

Backends is a data binding option available in the Data panel for dashboards created in the Dash StudioThis option allows you to filter the backend entities.

To monitor Backends, perform the following steps:

  1. Click Show me data for the dropdown and choose Backends from the list. 



  2. Click Type or Select and choose the application from the dropdown to display the metrics on the widget. 



  3. Click Select a Value and choose the filter that you want to apply from the dropdown:

    • Named 
    • Name Starts with

    • Name Ends With

    • Name Contains

    • All Backend

  4. Click Type or Select and choose a named filter from the list of options. 

  5. Click Metric and choose the backend metric value. 


    The metric chart appears as follows:


Errors Data Binding 

Errors is a data binding option available in the Data panel for dashboards created in the Dash StudioThis option allows you to filter the error entities.

To monitor error entities, perform the following steps:

  1. Click Show me data for dropdown and choose Errors from the list. 

    The subsequent inputs shown in the Data panel are specific to the data type selected in this step. 
  2. Click Type or Select and choose the application from the dropdown to display the metrics on the widget. 

  3. Click Select a Value and choose the filter that you want to apply from the dropdown.

  4. Click Type or Select and choose a named filter from the list of options. 
  5. Click Metric and choose the metric value. 



  6. Chart showing data for All Errors:

Browser Applications Metrics

Browser Applications metrics, also known as the Browser Real-User Monitoring (BRUM) metrics, is a data binding option available in the Data panel of the Dash Studio. This option allows you to filter and create customized metrics to view the performance of the web applications.

To filter and create customized metrics for one or more browser applications:

  1. Under Data panel, click Show me data for dropdown and select Browser Applications from the dropdown.
    Data panel
  2.  Click Application and select the application for which you want to drill down the data. 

    The subsequent inputs shown in the Data panel are specific to the data type selected in the previous step. 

  3. Click Browser Entity Type dropdown and choose an entity type from the list of options.
  4. Click Select a Value and choose the filter that you want to apply from the dropdown.
  5. Click Type or Select and choose one or more browser applications from the list of options. 
    You can also enter the name of the browser application in the input field manually. 
  6. Click Metric and choose a metric value from the list of options.

    The Browser Applications metric chart appears as follows:

Mobile Applications Metrics

Mobile Applications metrics, also known as the Mobile Real-User Monitoring (MRUM) metrics, is a data binding option available in the Data panel of the Dash Studio. This option allows you to filter and create customized metrics to view the performance of mobile applications.

To filter and create customized metrics for one or more mobile applications:

  1. Under Data panel, click Show me data for dropdown and select Mobile Applications from the dropdown.


  2.  Click Mobile Application Group and select the application for which you want to drill down the data. 

  3. Click Select under Metric Name dropdown and choose a metric from the list of options.
  4. Click Ok. 
    The Mobile Applications metric chart appears as follows: