2 Replies Latest reply on Dec 7, 2017 11:12 AM by David Joyce

    Creating a pie-chart using aggregated data

    David Joyce

      I have metrics that log the time taken in a piece of code as follows

       

      {

      RequestID=1234

      Controller=100ms

      {

      Validation=20ms {}

      ServiceLayer=80ms

      {

      DAO=80ms

      }

      }

      }

       

       

      I am in complete control as to how I want to store these in a table of some sort, SQL or no-SQL

       

      In Tableau, I wish to have the following behaviour:

      • user selects RequestID and Controller from filters
      • a pie-chart is displayed showing Validation and ServiceLayer segments within a chart labelled with Controller=100ms
      • if possible if the user clicked on ServiceLayer it would then drill in and display a chart with just the DAO segments

       

      Is the above possible using Tableau? If so, how can I achieve this baring in mind I've control of how I store the data?