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