5 Replies Latest reply on Apr 20, 2018 7:37 PM by Diogo Braga

    Calculate date difference between current and 7 days prior

    Diogo Braga

      I have the current total applications per zip code for each school, I need a calculated field showing the total applications 7 days prior to the current date. I can't be a table calculation, given the way I want to create the visual.

       

      This is what I have so far:

       

      { FIXED [Academic Year],[School Code],[Zip]: IF MAX([Apptime])=MAX([Apptime])-7 then COUNTD([App ID Modified]) end}

       

      Workbook attached. Thank you!