Hi @fda2, in the app you are able to drill down and up in the hierarchy by pressing on the data point instead of the label. This should open the menu at the bottom, where you can drill up (arrow up) or down (arrow down). You can check the docs for more info SAS Help Center: Navigate a Data Hierarchy ... View more

In Visual Analytics you can use the FindChar / FindString functions instead, in contrast to the FindWord function you can specify the separator(s) this way. For your example this could work: IF (FindChar(LastName, '-') > 0) return Substring(LastName, 1, FindChar(LastName, '-')) ELSE LastName ... View more