Key Task: Assign the Data Source for a Widget to Analyze Chrome File Downloads (Advanced)

For all managed applications with defined URL addresses, Aternity detects if any file is being downloaded when using Chrome (or Microsoft Edge based on Chromium). Use the File Downloads (Advanced) dashboard to analyze the download time, size, speed or other measures and their impact on efficiency in organizations.

For example, analyzing Chrome downloads can assist with decisions in what infrastructure to invest. After getting a comparison analysis of the downloads speed or users wait time, you might want to invest in web or network accelerator to enable employees to work with the least waste of time.

Add your own columns, design your own fields with custom calculations, and apply them to any of available attributes which you want to examine. For example, customize the dashboard to see the speed, amount, and status of downloads.

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.

This functionality applies only to Windows end-user devices with Agent 12.1 or later. Install the Agent for End User Devices locally on a Windows desktop or laptop.

Analyze Chrome Downloads Data

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 File Downloads data source.
  4. Step 4 Customize the dashboard by adding columns, rows, and your own fields with custom calculations.
    Dimensions Description
    Download Server

    Displays the name of the server from which the file is being downloaded.

    Download URL

    Displays the address (encrypted) of a remote system from where you receive data. Allows to distinguish between files with identical names.

    File MIME Type

    Displays the file type (application, audio, image, text, message, and more). For example, application/pdf).

    A multipurpose internet mail extension, or MIME Type, is an internet standard that describes the contents of internet files based on their natures and formats. This cataloging helps the browser open the file with the appropriate extension or plugin.

    File Name

    Displays the file name that you download (encrypted).

    Result
    Displays one of the possible states:
    • Interrupted: An error broke the connection with the file host.

    • Complete: The download completed successfully.

    Status

    The statuses are measured in severity: Major if the download failed and Minor if it is canceled by a user.

    Web Page Server

    Displays the hostname for the website where the download link was pressed.

    (The actual computer you connect to when you visit a web site with a browser).

    Web Page URL

    Displays the location of a web page or file on the Internet (encrypted).

    Browser Version

    Displays the browser version.

    Browser Name

    Displays the browser name.

    Measures Description
    Avg Download Speed (KBps)

    Displays an average rate of download in bytes per second. Calculated by dividing File Size in Bytes by Download Transfer Duration and rounded to zero decimal points. The value will not be reported in case of download failure.

    Download Interaction Duration (in seconds)

    Displays the time it took a user to choose and confirm the download location.

    In case where a user clicked Save as, the Interaction time is the time passed from the download initiation to its location confirmation.

    Download Transfer Duration (in seconds)
    Displays the time in seconds from passing the startline to goal - the time it took to transfer a file over an Internet connection and rounded to two decimal points.
    Total Download Transfer Time
    Download Wait Duration (in seconds)

    Displays the time (in seconds) users spend waiting for the file to download from the moment they confirm that download (to continue their work). Measures the time to complete a file download.

    File Size (MB)

    Displays the total size of the file (in Bytes).

    Note that in case of failure, this is NOT the amount of data transferred.

    Received Bytes

    Display the amount of bytes received when a download is complete.

    Download Start Time

    Displays the time when a user initiated the download.

    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

  5. Step 5 You can change the start time of the data displayed in the dashboard in the Timeframe menu in the top right corner of the screen. This menu impacts all tabs available in this view.

    You can access data in this dashboard (retention) going back up to 30 days. Learn more.

    This dashboard displays raw data in real time, refreshing every time you access it or whenever you manually refresh the browser page.

    Note

    If you save this dashboard for later viewing, it opens in view mode, and if you have permission, you can select Edit to further customize its view.

  6. Step 6 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
  7. Step 7 It is possible to create multiple sheets (widgets) in the advanced custom dashboards.
    Instead of having many custom dashboards with a single section each, you can 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.

    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
  8. Step 8 It is possible to create multiple tabs within a single dashboard where each tab presents a separate dashboard.

    Tell your story visually by using a sequence of tabs. For example: (a) a list of devices on which antivirus scan was successfully completed, (b) a list of devices on which it failed, (c) a list of viruses found across organization, (d) a trend of all scanning operations, etc.

    1. a Open an advanced dashboard.
    2. b Using the buttons in the bottom, create as many sheets as you want to display on the first dashboard.
      Add a worksheet or dashboard
    3. c Create the first dashboard and rename it.
      Add a new dashboard within an advanced one to create a multi-tabs dashboard
    4. d Using the buttons in the bottom, create as many sheets as you want to display on the second dashboard.
    5. e Create the second dashboard and rename it.
    6. f Repeat steps d & e as many times as you need.
    7. g Highlight a new dashboard to save it.
      Focus on a new dashboard to save it

      Once created and saved, Aternity will display it for you as a dashboard with multiple tabs next time you access it.

      Move from tab to tab within advanced dashboard to tell your story

      For more information on how to open multiple dashboard sheets in Tableau, see the Tableau tutorial.

  9. Step 9 (Optional) Export the dashboard data to Excel, Image or PDF file.
    1. a Select Download.
      For simple dashboards, at the bottom right of the screen. For advanced dashboards, on the top tool bar.
      Download a dashboard
      Note

      In Analyze dashboards, make sure you scroll down the dashboard until the end of the data. Otherwise, you might not see the Download button.

    2. b Select the required option depending on where you exporting the dashboard.
      • To download as Excel file, select Crosstab

      • To download as an image file, select Image

      • To download as PDF file, select PDF

      • To download as PowerPoint file, select PowerPoint

        Note

        Make sure you have data on a sheet. If the sheet is empty, the Crosstab menu is unavailable.

    3. c For PDF and PowerPoint only, define additional settings.
    4. d Select Download to start the process or Cancel to cancel.

      Open the file from your Downloads folder or from any other predefined destination for file downloads.