2 Replies Latest reply on Oct 30, 2018 8:14 PM by Yichao Tang

    How to see the count in each column for Top/Bottom N

    Yichao Tang

      Hi boss,

       

      I have 4 columns as below: ( Packed workbook(2018.2)  attached )

       

      EmployeeIDZoneModalityScore
      FE1Zone1ModalityA75.93836674
      FE2Zone2ModalityA90.6
      FE3Zone3ModalityC56.2479183

       

      It tells the Employee ID with score for 10+ zones and 4 modalities .

       

      The graph want to show how many people and the % for each zone in top/bottom N (of score) people for all modalities or for single modality.

       

      like this:

      Top and bottom N.PNG

       

       

      Filters or parameters will be:

      1. Modality: All , ModalityA, ModalityB, ModalityC, ModalityD

      2.Top N:  List (10, 20,30...)

      3.Bottom N: List (10,20,30...)

       

      Key points to looking for answer:

      1. How to see the count in Top/bottom N for all modalities and as well I can choose to see it for single modality.

      2. How to show the %, marked at the header of the bar.

       

       

      Let me know if it is not clear enough. Appropriate in advance. Online waiting...

       

      Thank,

      Irvin