Forum Discussion

mitchpj75's avatar
mitchpj75
Icon for Helper I rankHelper I
5 years ago
Solved

Pivoting to get the correct data format for visuals

Hi,   Struggling with the right format of my data.  I have 2 tables (case values and case value attributes).  The case values are the names of the fields and the case value attributes are the value...
Need Help
  • HotChilli's avatar
    HotChilli
    5 years ago

    Remove the 2 columns 

    case attribute ID Case attibute name

    before the Pivot.

    Then Pivot on the Field Name, using Value as value.  Choose 'Don't aggregate' from advanced.

     

     

HotChilli's avatar
HotChilli
Icon for Community Champion rankCommunity Champion
5 years ago

Remove the 2 columns 

case attribute ID Case attibute name

before the Pivot.

Then Pivot on the Field Name, using Value as value.  Choose 'Don't aggregate' from advanced.

 

 

  • mitchpj75's avatar
    mitchpj75
    Icon for Helper I rankHelper I
    5 years ago

    Awesome!  This worked very well...I see what I should have done to complete it.  Thanks!  Have given kudos!