1 Reply Latest reply on May 3, 2012 3:29 PM by Alex Kerin

    How do you use a statistical function on aggregated data?

    Richard Holohan

      I have a table of order data with the following fields in it:

       

      1) Transaction Number (unique)

      2) Customer Name

      3) Date

      4) Order Volume

       

      The table has about 13 weeks of data.

       

      I'm trying to generate a scatter plot that shows total volume (over the full 13 wk period) on one axis and weekly variability on the other. 

       

      The total volume is straight forward.  I can also create a stand alone chart that shows weekly volume, and can add a standard deviation band as a reference line, etc.  What I can't do is come up with a way to generate a measure of weekly variation, either through a calculated field or otherwise for use on the second axis. 

       

      I could always do the calculation in a new table, outside of tableau, but I'm wondering if there's a way to do it inside tableau.

       

      Any help would be greatly appreciated.

       

      Rich