I have a tree map visualization. Currently, I can only have one dimension in the tree map. However, I want to display multiple pieces of information in the tree map, so I used a calculated field to join multiple values and display them in the tree map graph.
For example, I concatenated Item ID and Node ID in a calculated field and displayed them in the tree graph. Now, I am using interactions to navigate to a specific URL with Item ID and Node ID as separate values. For example:
url/itemid/nodeId
Currently, I am able to pass the complete calculated field values. However, I tried splitting the values directly in the URL, which doesn’t work. If I pass the parameter directly, it does not select the user-clicked data but instead takes the filtered data.
I’m not sure I understand so to clarify, you concatenated fields together to get more out of the group by field in your tree map, but now for your URL action to work you need to split up the combined value?
Also, for the filter issue, how is the action set up and how does it relate to your parameter value?
The URL action is set up on the tree map, where a calculated field is used that contains concatenated values. Now, I want to use only the separated values in my URL.
For example, I have Node ID | Item ID | Date displayed in the tree map, and I want to use this in the URL action with the format: host/NodeID/ItemID.
Would it be possible to concatenate the values for your visual in the same format that you need for your URL? That way you just need to pass the value as is for your URL and avoid another transformation.