Solved

Concatenate Dimension Type Metrics - Convert Dimension type metrics to text type

+10

Hello Pigment Community,

I need help converting dimension-type metrics into text and concatenating them into another metric.

For example, in the screenshot I provided, I want the "Concat" metric for Row A to display "Asste1Con1".

How can I achieve this? Any guidance would be greatly appreciated.

Thanks in advance!

Best answer by Min Li

@Spandan98
Concat = Assets.Name&Cons.Name

+13

Hi!

There’s no way to concatenate the dimensions themselves, however you can create a concatenation of the names of the item, like so:

Dimension.Assets.Name & Dimension.Cons.Name

You can call any other property, or even chain them further like Dimension.Assets.Group.Name & Dimension.Cons.Code

Hope this helps!

François (Pigment)

+12

@Spandan98
Concat = Assets.Name&Cons.Name

Min Li

Sign up