2 Replies Latest reply on Nov 8, 2018 8:51 AM by Juan Pablo

    Calculated Field: 50% or more participation per month

    Juan Pablo

      My goal in this Tableau workbook is to be able to make a line graph that represents the amount of participants that participate in 50% or more of the possible activity dates.

      Ex: September 2018 had 6 dates, I only want to count the participants that have done activities in 3 or more of those dates.

       

      Evnetually I want to be able break this out by Activity, Group and Teacher.

       

      I'm not sure if my graph in sheet 3 is correct with the calculated fields, or if there's a better way to do this?

       

      Workbook Attached below. Thank you