7 Replies Latest reply on Oct 10, 2016 5:46 AM by Yuriy Fal

    Help getting max of total headcount and growth rate for single month

    Kyle Rutland

      Hello,

       

      Ultimately, I would like to create a comparison forecast chart that looks at the max, min, median, and average for each month of the year stretching back to 2012 and compare it to the current headcount in current year and month. 

       

      What I have done in excel (and what I would like to do here in Tableau), is to find the max of all Januaries (2012-2016) in my data source all of the averages, medians, current headcount or growth rate #.

       

      Does anyone have any advice on how to create something like I have done below?