Skip to main content

I'm visualizing clinical trials data and want to sort universities doing the trials by 3 measures (tbwx attached, Tableau 9.3):

  1. Enrolled/Randomized
  2. Completed Screening Visits
  3. Eligible to Screen

I can sort by Enrolled/Randomized with no problem (tab "Sorted by Enrolled" in the attached).

 

But - I then want to sort the remaining universities by:

    2. Completed Screening Visits

 

And if they have only eligible participants, I want to sort those remaining universities by:

    3. Eligible to Screen

 

I've looked into Index() and using a parameter, but I haven't quite found a way to make this work.

I want it to look like the "Sorted Manually" tab.

Any pointers much appreciated!

4 answers
  1. Feb 16, 2017, 4:26 AM

    Hi Kristin

     

    I think you can do that by creating three different ranks.

    Don't use Rank_unique but normal "Rank"

    Hi Kristin I think you can do that by creating three different ranks.

     

    [Rank 1]

    Rank(SUM([Trial B Enrolled/Randomized]))

     

    [Rank 2]

    RANK(SUM([Trial B Completed Screening Visits]))

     

    [Rank 3]

    RANK(SUM([Trial B Eligible to Screen]))

     

    pastedImage_4.png

     

    pastedImage_6.png

     

    Thanks,

    Shin

0/9000