Configure Tableau to Keep All Request History and Daily Desktop Reporting Stats

Version 2

    Background

    First up, we’re not really going to change any configuration, we’re going to use Tableau data extracts to store the data and incrementally refresh the information.
    It’s that simple.

     

    Http_requests is essentially a transaction log with an id that increment for each new record, an incremental extract tells tableau to grab any records are have a larger id than it already has.  Incremental extracts only ever add records so when the data clean-up deletes data in the source table they are not deleted from our extract.

     

    Desktop_reporting we’re getting a little tricky as tableau repository maintains one record per product key, machine and action combination (or something like that) and updates these records with the latest information rather than adding new records.  So this time we’ll tell the increment to grab any records that have changed since our last increment and add them as new rows to our extract. We run this increment on Last Report Date and if we run it daily you’ll be able to get some daily stats on your desktop (and reader*) users

     

    (if someone explains the above in a nicer way I’ll edit it in)

     

    I’m going to assume a general level of knowledge around tableau desktop server and publishing.

    *You know Tableau Reader will report back to your Tableau Server as well?  Just get the same registry keys deployed.

     

    Doing it

    What you’ll need

     

    http_requests

     

    • Open up desktop and connect to the repository
      (as at the end of the server_repo link above)
    • Add the http_requests table
    • You may also add other tables, I just add sites
    • Set an Extract connection with all rows and
      incremental refresh on Id
    • Publish to server and set a daily INCREMENTAL refresh
      on it

    Warning Warning - If you ever do a full refresh you will replace all your lovely history with whatever you have in your repository, which is likely just 7 days

    hhtpreq.png

    Desktop_reporting

    • Open up desktop and connect to the repository
      (as at the end of the server_repo link above)
    • Add the desktop_reporting tableau
    • Set an Extract connection with all rows and
      incremental refresh on Last Report Date
    • Publish to server and set a daily INCREMENTAL
      refresh on it

    Warning Warning - If you ever do a full refresh you will replace all your lovely history with just the current state

    desktoprep.png

     

    sooo does it work?

    I've got over one year of http_request information, so determining performance of server / workbooks etc is a breeze

    1year.PNG

    I only turned on the desktop_reporting one recently

    Who's using desktop daily and how many users per day.