Combine Data Values in Bar Chart

[#1]

I have a dimension "Area ID" which branches into 4 departments: "ASM", "BIW", "C-2", and "PNT"..... I want to REPLACE "ASM" with "TCF", CHANGE "C-2" & "PNT" to "PAINT", and keep "BIW".... Is this possible through an expression? Thanks in advance.

[sunny_talwar · Accepted solution]

May be use a calculated dimension or make changes in the script using if statements:

Calculated dimension

If([Area ID] = 'ASM', 'TCF',

If(Match([Area ID], 'PNT', 'C-2'), 'PAINT', [Area ID]))

script:

If([Area ID] = 'ASM', 'TCF',

If(Match([Area ID], 'PNT', 'C-2'), 'PAINT', [Area ID])) as [Area ID]

[vikramv]

Try using like this in your script for [Area ID]...

pick(match([Area ID],'ASM','BIW','C-2','PNT'),'TCF','BIW','PAINT','PAINT') as [Area ID]

or

Try using like this in your dimension for [Area ID]...

pick(match([Area ID],'ASM','BIW','C-2','PNT'),'TCF','BIW','PAINT','PAINT') as [Area ID]

[#4]

Thanks Again!

[sunny_talwar]

No problem at all