Forum Discussion

dmace's avatar
dmace
Frequent Visitor
3 years ago
Solved

Consolidate rows into one row using RANK()

I am trying to use partitions to consolidate the rows in my table into one row.  The data is for candidates who have been referred by multiple people (up to 4). A candidate can have multiple rows ...
Need Help
Tips and Tricks
  • dmace's avatar
    dmace
    3 years ago

     

VijayP's avatar
VijayP
Community Champion
3 years ago

dmace 

HAve you tried Calculate Function? 

  • dmace's avatar
    dmace
    Frequent Visitor
    3 years ago

    I have but was unable to get it to work, could you give me any tips on how to use Calculate to accomplish this?

     

    • VijayP's avatar
      VijayP
      Community Champion
      3 years ago

      dmace 

      Calculate (Average(column), filter(table name, rankcolumn = 1)), try this

      • dmace's avatar
        dmace
        Frequent Visitor
        3 years ago

        The values are text so I don't believe Average will work.