Key Task: Analyze Custom Data (Advanced)

Add to Aternity any performance metrics you want to collect and then view them in the Custom Data (Advanced) dashboard.

You can collect and analyze any performance parameter which Aternity does not normally detect. To add your performance metrics to Aternity, contact Aternity SaaS Administration and provide details of the measure you want to collect.

Aternity can detect any performance metrics you request in one of the following ways:
Aternity can collect your custom metrics in one of three ways

Use Custom Data (Advanced) advanced dashboard to see trends of your custom performance metrics. 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.

For example, analyze free disk space on end user devices in a certain business location during the timeframe, and correlate it with other attributes, like Office or OS Type.

Analyze your custom measurements in the advanced dashboard

Procedure

  1. Step 1 Open a browser and sign in to Aternity.
  2. Step 2 Select Main Menu > Analyze > Custom Data (Advanced).
    Open Custom Data Advanced dashboard
  3. Step 3 Select what custom metrics you want to analyze and click Go to continue.
    Once SaaS administrator adds your requested metrics to Aternity, you get the name of the monitor, the entity created in Aternity in order to collect your custom data.
    Select what monitor to analyze
  4. Step 4 Rename generic measures and related contextuals to give them meaningful names.

    Each monitor can simultaneously display up to 12 metrics and 16 contextuals. It generates performance data based on any user-selected criteria, and displays performance results in the Custom Data dashboard.

    For example, for the Free Disk Space monitor, rename contextual 01/02/03/04 to disk name, disk type, disk speed, and disk size respectively; and rename measures to free disk space in % and free disk space in megabytes.

    1. a Click the information icon to see the names of measures.
      See names of generic measurements
    2. b Select measurement 01 and right-click it.
    3. c Select Create > Calculated Field.
      Rename the generic measurement
    4. d Paste the name from the information dialog box and save the changes.
    5. e Repeat these steps for all generic measures and related contextuals.
  5. Step 5 Customize dashboard to see the trend of the selected metric (for example, Free Disk Space).
    See the trend of your custom performance metrics
  6. Step 6 Customize the dashboard by adding columns, rows, and your own fields with custom calculations.

    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

  7. Step 7 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
  8. Step 8 You can limit the display of this dashboard using the menus at the right of the window.
    Field Description
    Timeframe

    You can change the start time of the data displayed in the dashboard in the Timeframe menu in the top right corner of the dashboard.

    You can access data in this dashboard (retention) going back up to three months with PII (learn more), or 12 months anonymized. You can set this in the Aggregation Type.

    This dashboard's data refreshes every hour.

    Aggregation Type

    In the advanced dashboards, select the level of granularity or detail displayed in the dashboard. You can view longer retention times when you choose more summarized data:

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

    • Hourly (1 month) displays data as a set of summarized hourly averages.

    • Daily (3 months) displays data as a set of summarized daily averages, which includes personal information (PII).

    • Daily Anonymized (12 months) displays daily summaries of the data going back 12 months, but the data does not include any personal information (PII).

    Tip

    In other dashboards, the raw or aggregated data automatically shown according to the selected timeframe.

  9. Step 9 You can create multiple sheets (widgets) in the advanced custom dashboards.
    Instead of having many custom dashboards with a single section each, you can now create a single dashboard with all sections you need. This allows more information to be provided within one dashboard displaying much more holistic view, as well as much stronger analytics by cross filtering between the sheets.
    Create multiple sheets in the same dashboard.
    For more information on how to open multiple dashboard sheets in Tableau, see the Tableau tutorial.
    Timeframe drop-down menu in the top right corner of the screen serves all widgets. Use it to set the required timeframe for each widget if necessary.
    Set timeframe in the top right corner of the screen

    Once you have created several widgets and then a dashboard that uses these widgets, save a new dashboard. Make sure to click Save while focusing on the dashboard (in the bottom of the screen there is a list of all open tabs). Note that if, by mistake, the focus is on a widget, the saved view will display this widget instead of dashboard. Click Edit to make changes.

    Focus on a new dashboard to save it