4 Replies Latest reply on Oct 25, 2018 8:19 AM by Caite Stevens

    Average # of records over various time periods

    Caite Stevens



      I feel like this should be easy, but I can't figure it out.


      I track the number of tasks a department completes. 12,000 since Jan. 1. Tableau gives me that pre-calculated Number of Records count, and I can filter on it by department, by time period, etc. Great.


      But what I want is "How many tasks do they complete on average over any given week, month, or quarter?" Simply applying AVG to [Number of Records] gives me a nonsensical answer.