Key Task: Customize a Dashboard to Analyze Business Activities (Advanced)

Use Analyze Business Activities (Advanced) 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 attributes in the system which you want to examine.

Tip

For advanced analysis of data for all applications, including discovered applications with no defined activities, use the Analyze Applications (Advanced) dashboard.

If the data you need for your investigation is not provided in the set of columns displayed in any other Analyze dashboard, use this screen to customize and tailor the dashboard to display the fields you need to check the data you need.

The Analyze Business Activities (Advanced) dashboard

There are endless ways you can use the data from this dashboard to check almost anything you want to investigate.

For example, you can compare the response times of opening mails between Microsoft Outlook in different versions of Microsoft Office, to check whether Samsung computers in your Tokyo office are quicker with the newer version.

If you saved this dashboard for later viewing, it opens the main sheet (only) in view mode. To further customize (if you have permission), select Edit.

Procedure

  1. Step 1 Open a browser and sign in to Aternity.
  2. Step 2 Select Main Menu > Analyze > Business Activities (Advanced).
    Accessing the Analyze Business Activities (Advanced) dashboard
  3. Step 3 To customize the dashboard further, to add your own fields with custom calculations, and to add columns, select Edit in the top bar of the window.

    For example, you can easily turn the bar chart into a trend graph by dragging Hour of Day from the sidebar to the Columns section, and selecting Show Me to view a trend graph.

    Edit the look and data of the dashboard to view the trend across time

    As another example, you can create your own custom data item called Is a lab Laptop which returns True only if the device's hostname starts with the characters LAB_, as in LAB_Lenovo1. After you create this data type, you can create a filter to limit this dashboard's view to laptops for the lab only.

    Creating a data item for filtering

    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

    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 formulas.

  4. Step 4 You can create a custom group for an attribute in any of the advanced Analyze dashboards, from data in Excel (like a CSV file).

    For example, you can create two custom groups to compare their measurements.

    Use CSV data to create a custom group
    1. a Copy the values you want for the group from a CSV file in Excel.

      For example, if you have a CSV file of device names from the device inventory API, choose the names you want as a group and copy them to the clipboard.

    2. b Display the attribute of your group in the dashboard by dragging it from the left pane to the top bar.

      For example, to display rows of hostnames in this dashboard, drag Client Device Name from the left pane to the Rows bar at the top.

      Drag the attribute to the top bar and show its filter
    3. c 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.
      Choose Show filter from the drop-down menu
    4. d To display only the values from your CSV file, change the filter in the right-hand bar by opening its drop-down menu and selecting Multiple values (custom list).

      This displays only several specific values in the dashboard.

      In this example, to display only the specific hostnames from your CSV file, in the right hand bar, select Client Device Name > Multiple values (custom list).

      Display only specific values in the dashboard
    5. e To display only the items from your CSV file, paste them into the filter field.
      Paste your data into the filter field
    6. f Create a group by selecting the group members, then in the pop-up select the group icon .
      Select items and create a group

      It creates a custom group as a new object in the left sidebar. You can now use it as part of your analysis like any other object.

    7. g To create a second custom group for comparison with your first group, select Clear List to clear the first group's data from the filter, and repeat the process.

      Paste a second set in the filter field to display them, select them in the dashboard, then group them.

      Clear the data from the filter
    8. h Clear the filter and now paste both lists into the filter so you can see all values from both groups in the dashboard.

      This displays all members of the groups in their respective groups so you can compare them side by side.

      View a comparison of two custom groups
  5. Step 5 You can limit the display of this dashboard using the menus at the right of the window.
    Field Description
    Timeframe

    Choose the start time of the data displayed in this dashboard.

    You can access data in this dashboard (retention) going back up to 14 days. This dashboard's data refreshes every hour.

    Aggregation Type

    Select the level of granularity or detail displayed in the dashboard:

    • Raw displays the data as reported from devices without any summarizing (aggregation).

    • Hourly displays data as a set of summarized hourly averages.

    • Daily displays data as a set of summarized daily averages.