Forum Discussion

bswank31's avatar
bswank31
Helper II
3 years ago

Ranking

Hi. Is there a way to Rank a specific column (GXT) but if there is an "Including" in the Category Column then keep those intervals together? I hope someone can help me. Thanks a bunch!   Example: ...
Need Help
lbendlin's avatar
lbendlin
Super User
3 years ago

sorry, still not clear to me, especially what you mean by "the interval it belongs to" - please explain what that means.

 

What is the expected outcome based on your sample data?

bswank31's avatar
bswank31
Helper II
3 years ago

What I am looking for is to create a Ranking from my GXT column and if my category column Contains "Including" to give it the same rank as the interval it belongs with: See how each color belongs in the same interval?

 

This first table works and is what I want but when I apply it to my table with more sites and years (See below table) it gets all messed.

This table is not filtering correctly when i select the year and the ranking is not working. 

I hope this makes more sense.

thanks,

  • lbendlin's avatar
    lbendlin
    Super User
    3 years ago

    Nowhere in your source data does it say "interval" .  What is an interval?  Is it a combination of Site, Project and Hole?

    • bswank31's avatar
      bswank31
      Helper II
      3 years ago

      Sorry. I forgot to add that in. The "interval" I am talking about is the From (m) column and To (m) columns. The From (m) to To (m) is an interval. 

       

      • lbendlin's avatar
        lbendlin
        Super User
        3 years ago

        You have overlapping intervals. 

         

         

        that makes it impossible to determine which one "belongs" to which other one.