[Cloud release: 2025.01.15]
[On-prem release: 2025 January]
[On-prem build: 25.02.07520]
Returns 1 (true) if dimension member in current row/column matches the string. Otherwise, it returns 0 (false).
Useful if you need to make conditional calculations, based on specific names or categories of your dimension. The same conditions can also be used together with color and visibility agents.
Syntax:
rowname("[string]")
colname("[string]")
Example, single level dimensions:
rowname("Rhetta Parker")
colname("Europe")
Note: The rowname() calculation only makes sense when added "as a column" or "as a new measure". Likewise, the colname() calculation only makes sense when added "as a row" or "as a new measure".
Example, multi level dimensions:
rowname("Arjuna Bolton")
rowname("Arjuna Bolton"(l1))
rowname("North America")
rowname("Madelina Hewitt"(l1)) and rowname("North America"(l2))
Comments
GREAT, great, great !!!!
Thanks for this !!!!
BR MARC
You are welcome, Marc :-)
Hi Ole,
Is it possible to match a part of a string? I can't find a way to do it at the moment and this could be very usefull :-)
Best regards Jette
Hi Jette,
No. The Rowname and Colname functions only work with exact matches.
BR / Ole
Thanks for a quick reply
BR / Jette
It would be useful if this could work with measure names so that you could do effective calculations when the "Measures Down" property is selected. Is this possible?
Hi Ellis,
This will not solve the issues that you see with "Measures down". See my reply to your other "Measures down" question here: https://community.targit.com/hc/en-us/articles/4412909804817-December-6th-Smartpad-hidden-gems?page=1#comment_19520214116764
BR / Ole
Please sign in to leave a comment.