Create Your Own Dashboard from Multiple Data Sources (Advanced)

Use Create Your Own Dashboard option (previously called Analyze Multiple Data Sources (Advanced)) to build a dashboard that includes widgets from multiple data sources in order to provide a holistic view that correlates between data of different types.

For example, understand the impact of OS version on applications performance, or analyze number of crashes and resource utilization in a single view.

When working with Multi Data Sources dashboard, be aware of the following:
  • The Aggregation Type drop-down menu exists only on the first sheet of the Multi-Data Sources dashboard, but also affects all other sheets, even though they might use different data sources for which the actual retentions might be different for the same aggregation type.

  • Whenever the available data does not fit the retention described in the parentheses of the selected aggregation type, learn about actual retention of the data source you are using in the Understanding Retention Policies in Aternity article.

Procedure

  1. Step 1 Open a browser and sign in to Aternity.
  2. Step 2 Select Main Menu > Analyze > Create Your Own Dashboard.
    Select what kind of data you want to analyze
  3. Step 3 Select a data source for the first widget and click Go.

    Starting with a blank dashboard, you can add widgets (sheets) one at a time, where each widget links to a different data source, like Applications or Device Health. This allows viewing data from different sources side by side.

    This article details how to create a dashboard(s) containing data from multiple sources.

    Data Source Description
    Application Events

    The Application Events (Advanced) dashboard shows only application events, which you can create to report the number of errors or the number of times someone used a feature in your application, like accessing its online help. You create application events in the Aternity Activity Designer and upload it to Aternity in a similar way to a regular custom activity. This advanced analyze dashboard allows you to customize its layout, so you can correlate the occurrence of an application event with other system or application measurements, but it does NOT display regular activities, only application events. See the Analyze Application Events (Advanced) dashboard.

    This data source provides data you need to correlate the occurrence of an application event with other system or application measurements.

    Learn how to customize an advanced dashboard to analyze Application Events

    Applications

    This data source provides data you need to investigate your own theories on any application's performance (including discovered applications with no activities defined).

    Learn how to customize an advanced dashboard to analyze Applications.

    Boot Components

    Use the Data Source Boot Components to analyze the degrading performance of those Windows boot components whose boot time takes longer than 1 second.

    This data source provides data you need to investigate the degrading performance of those Windows boot components whose boot time takes longer than 1 second.

    Learn how to customize an advanced dashboard to analyze machine boot components.

    Boot

    Use the Data Source Boot to customize the dashboard and to investigate total boot duration, machine boot times, or user logon boot times across the organization and understand the performance of operating system in terms of boot times.

    This data source provides data you need to investigate total boot duration,machine boot times, or user logon boot times across the organization and understand the performance of operating system in terms of boot times..

    Learn how to customize an advanced dashboard to analyze boot issues.

    Business Activities

    Use Data Source Business Activities to customize the dashboard to display any data you need to investigate your own theories on any managed application's activity performance. Add your own columns, design your own fields with custom calculations, and apply them to any of the monitored attributes which you want to examine. See the Analyze Business Activities (Advanced) dashboard.

    This data source provides data you need to investigate your own theories on any managed application's activity performance.

    Learn how to customize an advanced dashboard to analyze Business Activities.

    Device Health

    Use Data Source Device Health to track errors and crashes throughout your organization by viewing the latest individual health events with all of their details. Analyze for patterns with specific types of health events to find correlations with attributes like the device model, RAM, location, and disk type. Add your own columns, design your own fields with custom calculations, and apply them to any of the monitored attributes which you want to examine.

    This data source provides data you need to track errors and crashes throughout your organization by viewing the latest individual health events with all of their details. Use this data source to analyze for patterns with specific types of health events to find correlations with attributes like the device model, RAM, location, and disk type.

    Learn how to customize an advanced dashboard to analyze Device Health.

    Device Inventory

    This data source provides data you need to analyze information about the inventory of devices in your organization.

    Learn how to customize the dashboard.

    File Downloads

    Use Data Source File Downloads to analyze the download time, size, speed or other measures and their impact on efficiency in organizations.

    This data source provides data you need to the download time, size, speed or other measures and their impact on efficiency in organizations.

    Learn how to customize the dashboard.

    Host Resources

    This data source provides data you need to investigate correlations between attributes that relate to host resources, using the customization features of the advanced dashboard.

    Learn how to customize an advanced dashboard to analyze Host Resources.

    Installed Software

    Use Data Source Installed Software to analyze the current status of software deployment across your entire organization. The dashboard will assist you to answer questions, such as “who still has an old Office version” or “when was version X installed in my organization.

    This data source provides data you need to analyze the current status of software deployment across your entire organization.

    Learn how to customize an advanced dashboard to analyze Installed Software.

    MS Teams

    Use Data Source Microsoft Teams to investigate correlations that might justify an improvement or worsening in call quality in Microsoft Teams on monitored devices running Agent for End User Devices 12.1 or later.

    This data source provides data to investigate correlations that might justify an improvement or worsening in call quality in MS Teams on monitored devices.

    Learn how to customize the dashboard.

    Software Changes

    Use Software Changes Data Source to check and analyze the installed software related changes on each Windows physical monitored device, along with its version and deployment date.

    This data source provides data you need to check and analyze the installed software related changes on each Windows physical monitored device, along with its version and deployment date.

    Learn how to customize the dashboard.

    Mobile App Errors

    Use the Analyze Mobile App Errors (Advanced) dashboard to analyze all mobile app errors in your organization, including viewing a list of all errors in a given app, the relevant mobile operating systems, locations, device details (like manufacturer, model, carrier) affected device names, and view the recent past to see if there has been a rise or fall in the number of these errors.

    This data source provides data you need to check and analyze mobile app errors in your organization, including viewing the list of all errors in a given app, the relevant mobile operating systems, and more.

    Learn how to customize an advanced dashboard to analyze mobile app errors.

    Mobile HTTP Requests
    • Use the Analyze Mobile HTTP (Advanced) dashboard to analyze the performance of HTTP traffic from mobile apps in your organization. You can easily see the apps which are slowest at accessing data via the web, and determine if the problem is only with specific web services, operating systems or locations. You can build the trend in the performance of mobile web access, to see if there was a recent increase in response times, and use this information to help track down the cause of the problem.

    This data source provides data you need to analyze the performance of HTTP traffic from mobile apps in your organization.

    Learn how to customize an advanced dashboard to analyze mobile HTTP requests.

    Mobile Network Traffic

    Use the Analyze Mobile Traffic Network (Advanced) dashboard to analyze the incoming and outgoing data usage of mobile devices within organization. Use this dashboard to identify problematic apps, devices, networks, trends and locations.

    This data source provides data you need to analyze the incoming and outgoing data usage of mobile devices within organization.

    Learn how to customize an advanced dashboard to analyze mobile network traffic.

    Process Resources

    Use Data Source Process Resources to customize the dashboard to display any data you need to investigate your own theories on any managed application's resource usage (PRC), which would slow down devices. Add your own columns, design your own fields with custom calculations, and apply them to any of the attributes which you want to examine. See the Analyze Process Resources (Advanced) dashboard.

    This data source provides data to investigate your own theories on any managed application's resource usage (PRC), which would slow down devices.

    Learn how to customize an advanced dashboard to analyze Process Resources.

    Remediation

    Use Data Source Remediation Actions to customize the visual representation of all executed remedial actions to investigate and analyze their statuses.

    This data source provides information about the executed remediation actions and their results/states.

    Learn how to customize the dashboard.

    Remote Display Latency

    The Analyze Remote Display Latency (Advanced) dashboard highlights the delays to performance caused by remote display latency in virtualized environments, showing the delays in different locations or data centers. Use this dashboard to investigate correlations between attributes that relate to latency, using the customization features of the advanced dashboard. Add your own columns, design your own fields with custom calculations, and apply them to any of the monitored attributes that you want to examine.

    This data source provides data to investigate the delays to performance caused by remote display latency in virtualized environments.

    Learn how to customize the dashboard.

    WiFi

    Use the Data Source WiFi dashboard to analyze the customer experience of WiFi in your enterprise, the WiFi speed, signal strength, and access points for each monitored device.

    This data source provides data to analyze the customer experience of WiFi in your enterprise, the WiFi speed, signal strength, and access points for each monitored device.

    Learn how to customize the dashboard.

  4. Step 4 Customize the dashboard by dragging measures and dimensions to the Columns and Rows bar, so that you can compare specific attributes.
    Both attributes and measures are now arranged in one folder. Attributes are marked with Abc, whereas measures with special symbols.
    See the folder structure of dimensions (attributes) and measures in advanced dashboards
    Drag measures and dimensions to the Columns and Rows fields in the top bar
  5. Step 5 To display a filter of this value in the right pane of the dashboard, hover over the attribute, open its drop-down menu, and select Show Filter.
    Alternatively, drag this attribute to the Filters section.
    Add filter for further correlation of data
    Tip

    Be mindful of the TopByUsageParam parameter when using the Applications data source as this can prevent all data from showing on the dashboard. In the left pane, under Parameters, right-click TopByUsageParam and then select Add to Sheet. Then in the right-pane, under Add to Sheet, select All Applications since sometimes MS Visio or MS Project may not be the top usage applications.

    Select the level of usage

    For more information on the full editing capabilities of this dashboard, see http://www.tableau.com/learn/training. View the following training sections:

    • Visual Analytics

    • Calculations

    • Tableau Server

    • How To

  6. Step 6 Click Create new sheet at the bottom of the screen and then select a data source for the second widget, either a different source or the same one.
    Note

    The Aggregation Type drop-down menu exists only on the first sheet of the Multi-Data Sources dashboard, but also affects all other sheets, even though they might use different data sources for which the actual retentions might be different for the same aggregation type.

    You can rename each widget and dashboard.

    Create a second worksheet with a different data source
    Tip

    If you receive a communication error 504, ensure that your dashboard does not list too many rows (like all your device names or usernames). You can narrow the scope of the data displayed by selecting Show Filter for that attribute and selecting the values to display. To further improve dashboard performance, select Aggregation Type > Hourly or Daily, and do not include Tableau's level of detail expressions.

  7. Step 7 Click Create a new dashboard at the bottom of the screen and then drag the Sheets to the middle of the screen.

    Arrange the sheets in the most convenient way to view data, either in rows or in columns.

    Create a new dashboard using multiple widgets
  8. Step 8 Use Filter to allow filtering between widgets.
    Note

    Note that filtering works even between widgets that use different data sources.

    Note that filtering requires that in both widgets from different data sources will be at least one identical column name, otherwise filter does not work.

  9. Step 9 Save the dashboard.