3 Replies Latest reply on Sep 29, 2016 4:05 PM by Deepak Rai

    Dynamically calculate IF date is within a moving date range

    Nicholas Kamenos

      Hi everyone,

       

      I'm trying to only take into consideration records IF the a date is within a date range

       

      I'd like to calculate the average of "Score #1" and "Score #2" (separately, excluding NULLs)  if the "End Date" is within the "Time Frame". I need this calculation to work on the fly because the user will only be filtering by "Time Frame".

       

      So basically have Tableau exclude the ID the calculation if the "End Date" is outside of the "Time Frame".

       

      See the Excel document.

       

      Thank you!