Forum Discussion

stackedcreative's avatar
stackedcreative
Frequent Visitor
5 years ago

Grouping DocID Column to show all data points

Hi.  I have a unique DocID column.  There are 4 separate workflows for each DocID (Create, HR Process, Package Selection, Service Process).  Problem is, they are in separate rows.  I need to show them all in the same row.  

 

I tried:

 

- CTRL+click in visual > Group (but it's greyed out)

- Data > Data Groups (but it wants me to group by individual DocIDs)

- Tooltips (but they, again, only show the data for that one workflow, not all

 

For the attached image, I want to show Create Date = X, HR Process Date = Y, Package Selection = Z, Service Process = A) all in the same row.  Basically like a "transpose" function in Excel. 

 

Need Help

5 Replies

    • DataInsights's avatar
      DataInsights
      Super User
      5 years ago

      You can adjust the second argument to include multiple columns, like this:

       

      Concat = CONCATENATEX ( DocTable, DocTable[WFAction] & " = " & DocTable[JoinDate], ", " )

       

       

      • stackedcreative's avatar
        stackedcreative
        Frequent Visitor
        5 years ago

        DataInsights - FINALLY had time to work on this.  I need the data to still be in separate columns.  I ran this and got about 6,000 pieces of data in one... makes it hard to put in something readable.  

         

        I tried UNION, have looked into other stuff.  Still perplexed. 

  • stackedcreative's avatar
    stackedcreative
    Frequent Visitor
    5 years ago

    DataInsights  Thanks for trying to help.  I've hit so many issues with the data coming in mismatched that I haven't had time to try to get this to work beyond that.  Pivoting does seem the way to go but I get errors.  😞  A colleague had a different idea of a way to display the data so we're going down that path.