article Creating custom reports with Tableau

Related Documentation Version of up.time affected Affected Platforms
Connecting to the up.time DataStore via ODBC
Workload Heatmap with Tableau
All All

Article Contents

Overview

While up.time offers powerful reporting features, you may want to generate reports that use a specific set of data or a custom report format. Using Tableau, you can retrieve data from the up.time DataStore and use it to create reports that meet your individual requirements.

For a functional example of how you can use Tableau to create reports, see this posting on the uptime Community Forum.


Before You Begin

If you have not already done so, install the MySQL ODBC driver and create a data source to access the up.time DataStore. For more information, see the Connecting to the up.time DataStore via ODBC Knowledge Base article.


Configuring a Report in Tableau

To configure a report in Tableau:

  1. Start Tableau.
  2. Select Data and then click Connect to Data Source.
  3. Double click New Connection.
  4. Choose MySQL Database.
  5. In the Enter a Server name field, type the name of the server that is hosting the DataStore that you want to connect to.
  6. Enter the port on which the DataStore is listening in the Port field (the default port for the DataStore is 3308).
  7. In the Username and Password fields, enter reports and reports.
  8. Click the Test Connection button.

    A message will appear confirming if Tableau was able to connect to the DataStore, as shown below:

  9. Select the uptime database from the dropdown menu.
  10. Select the Custom SQL option and enter the following statement in the text area:
    select e.display_name,avg(p.cpu_usr + p.cpu_sys + p.cpu_wio), 
    DATE(s.sample_time) from performance_sample s,
    performance_aggregate p, entity e
    where s.id = p.sample_id
    and e.entity_id = s.uptimehost_id
    and s.sample_time > "2010-11-17"
    and s.sample_time < DATE_ADD("2010-11-17", INTERVAL 7 DAY)
    group by DATE(s.sample_time), e.display_name
    order by DATE(s.sample_time), e.display_name
    

    The above example will report on the CPU workload average for all systems over the 7-day period from 2010-11-17 to 2010-11-24.

  11. Click OK when finished.

Modifying How the Report Displays Information

You can quickly and easily change the information in a Tableau report to suit your needs, as illustrated below:

In the above example, display_name and avg(p.cpu_usr + p.cpu_sys + p.cpu_wio) are moved into Rows by clicking with the mouse, dragging the values from the left hand column and dropping them in the Rows field. DATE(s.sample_time) is moved to Columns in a similar way. By default, Tableau may format the DATE(s.sample_time) to only display the year, and format avg(p.cpu_usr + p.cpu_sys + p.cpu_wio) to add the results.

To change this presentation, hold your mouse over any of the fields and click the arrow that appears on the right side of the field to open the following menu:

Select All Values from the menu for both the display_name and avg(p.cpu_usr + p.cpu_sys + p.cpu_wio) fields (you may need to move or alter some fields to modify the default Tableau formatting).

The following image illustrates a formatted Tableau report:

Related Articles


Creating custom reports with Crystal Reports

RatingViews
article

Use Crystal Reports with up.time's DataStore to generate custom reports.

By: uptime Support | Date Created: 11-28-2006 | Last Modified: 7-28-2011 | Index: 103

  45106

Creating custom reports with Microsoft Reporting Service

RatingViews
article

Learn how to query data from an MS SQL Server DataStore and create reports with Microsoft Reporting Services.

By: uptime Support | Date Created: 1-3-2007 | Last Modified: 7-6-2011 | Index: 113

  7541

Creating Custom Service Monitors with Retained Data Collection

RatingViews
article

By: uptime Support | Date Created: 5-15-2006 | Last Modified: 12-16-2011 | Index: 067

  10867

Creating Custom Alert Scripts in up.time Alert Profiles

RatingViews
article

By: uptime Support | Date Created: 5-17-2006 | Last Modified: 8-9-2011 | Index: 065

  11027

Creating Custom Service Monitors in up.time

RatingViews
article

By: uptime Support | Date Created: 5-15-2006 | Last Modified: 6-26-2013 | Index: 066

  21587

User Comments



No comments have been posted.

Copyright © 2021 IDERA, Inc.   Legal   Privacy Statement