Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I had split out a column in the data manager to 3 total new columns. In a bard chart I am looking to merge the values which I accomplished with the below formula:
=pick(match($Field,'Competitor Name-1','Competitor Name-2','Competitor Name-3'),[Competitor Name-1],[Competitor Name-2],[Competitor Name-3])
BUT now I am wanting to remove a specific value from the Competitor list (for each dimension). How can this be accomplished?
Hi,
Not clear with the question. Could you please elaborate more with an example?
That would be helpful for understanding.
I have a field (called Competitor Name) in my data that is";" separated values (i.e. sample1;sample2;sample3). I need to report on sample 1,2,3 separately so I split the field out into three total fields Competitor Name-1, Competitor Name-2, Competitor Name-3. Now to report on the individual values (summing Sample1 when occurring across all field Competitor Name-1 to 3) I used the below formula.
=pick(match($Field,'Competitor Name-1','Competitor Name-2','Competitor Name-3'),[Competitor Name-1],[Competitor Name-2],[Competitor Name-3])
However, I need to report on all values except for 'Sample-2' within Competitor Name-1, Competitor Name-2, Competitor Name-3.
I have resolved through the data manager, I manually made null the values I do not want to report on. Thanks!