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

    Average # of records over various time periods

    Caite Stevens

      Hi,

       

      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.

       

      Thanks,

      Caite