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!
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!
Concat = Assets.Name&Cons.Name
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.