Forum Discussion

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.

  • CaraJonesReadle's avatar
    CaraJonesReadle
    Frequent Visitor
    8 years ago

    HI Ashish

     

    Your solution has been working brilliantly, thank-you again.

     

    I am wondering though, I now want to have 3 columns each showing the top 3 issues based on duration. I have copied the rank x formula for the 3rd column that I want to add, however now column 2 losses its ranking when i apply this. How can I rectify this issue?

     

    Thanks

    Cara

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

    You are welcome.  Share the file and tell me exactly what the problem is.

  • CaraJonesReadle's avatar
    CaraJonesReadle
    Frequent Visitor
    8 years ago

    Here is the link

    https://drive.google.com/open?id=1Dr-XRSW58BbE5x8iyqFHvbvLXci6ljct

     

    In the tab called Overall, you can see a matrix that is showing 3 levels, level 2 and event descirption are only showing the top 3 issues where as the level 3 column shows all. What I am looking for is the Top 3 level 2 events by duration that then break into the top 3 level 3 events and then the top 3 evenet descriptions.

     

     

    Thanks so much for your help :)

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

    Hi,

     

    Someone else will help you with solving this problem.