Forum Discussion

fernandoC's avatar
fernandoC
Icon for Helper V rankHelper V
6 years ago

Splitting Column per Category

Hi!   I'm trying to split a column so that it represents one category per column. I have 2 columns: ID & Custom Field name where for example there multiple "Years of Experience" per the same ID and...
General Comment
Need Help
Tips and Tricks
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

fernandoC So solved? Sorry not clear on level of order.

fernandoC's avatar
fernandoC
Icon for Helper V rankHelper V
6 years ago

Hi Greg_Deckler ,

 

So, It works great using a Matrix Visual, however, when I try to use it for a bar chart it doesn't work since the structure of the data needs to be as displayed on the Matrix Visual. 

 

So I've created a measure to count Hires that are equal to "Issue Type=Offer" & "Custom Field Value = Accepted", and I want to filter them by Disciplines (which are currently under "Custom Field Name") the issue comes when using the axis "Custom Field Name" as both "Accepted & Disciplines" come from the same column.  Hope it makes sense.