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

    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

    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

    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

    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

    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

    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

    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

    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

    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

    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

    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

    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

    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

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

    Learn how to customize the dashboard.
    Remote Display Latency

    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

    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.
    Zoom Meetings

    This data source provides data to analyze and troubleshoot your Zoom performance (quality of service).

    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.