1 Reply Latest reply on Feb 11, 2015 8:28 PM by Tableau kumar

    Calculating max values over a date range

    Daniel Pastore

      Hi

       

      I have 1 years worth of data... but I  am trying to build a 'simple table' which shows that does a couple of things...

       

      1. reflect data for the current date

      2. show me a measure (something like... MAX(Active User Cnts) ) over a 1 week period.

       

      The table will have the 2 following columns...

      Customer Name (all customers reporting activity as of today())

      Active user Count (the Max number of users for each customer over a 7 day period)

       

      My report filters for the current date.So, my initial thought is, that the current date filter will void out any calculation to show the max users over a 7 day period.

       

      Can anyone help shed some light on how to build that calculation (MAX(User Cnts) over 7 days??

       

       

      Thanks

      Dan