8 Replies Latest reply on Jun 20, 2017 2:41 PM by Jane Wong

    aggregation problem

    Jane Wong

      Hi Tableau Wizards

       

      I have been facing this kind of problems a few times in my analysis but was not able to resolve it.

      I have scores for each date, and need to get portion of how many weeks average score is lower than a target e.g. 195.

       

      In the sample data, I have total 10 weeks. Based on weekly average, 4 weeks have average score greater than 195. Hence I want to have 40% showing in my report.

       

       

      I always need to compare an aggregate number to a target in my analysis.

       

      Can anyone please help? Sample data is attached.

       

       

      Many thanks

       

      Jane