Forum Discussion

CaraJonesReadle's avatar
CaraJonesReadle
Frequent Visitor
8 years ago
Solved

Ranking Multiple columns in a matrix

  Hello   I have a matrix that I am trying to show the top 3 Level 2 downtime areas and then show the top 3 reasons (level 3) for that area. I am using TOP N for the first column, from my research...
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
8 years ago

Hi,

 

Upload the file to Google Drive or any other such service and share the download link.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    8 years ago

    Hi,

     

    You may download my solution file from here.

     

    Hope this helps.

     

    • CaraJonesReadle's avatar
      CaraJonesReadle
      Frequent Visitor
      8 years ago

      Thanks so much Ashish this is terrific.

       

      Don't suppose you could explain how you managed to create the ranking filter, as I am sure that I will have similar situations occur on other reports I create.

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Icon for Super User rankSuper User
        8 years ago

        You are welcome.  I created a rank measure using the RANKX formula to assign a rank to each Level3 based on Event duration.  I then dragged that measure to the visual filter section and applied a criteria of <=3.