Forum Discussion

mitchpj75's avatar
mitchpj75
Helper 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
Community 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
    Helper I
    5 years ago

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