How to combine data from a cascading custom field

[Mikael Sandberg]

Hi all,

I feel like a newbie all over again trying to figure out Analytics, which is good since I am learning something new. 

I am creating a issue detail chart with issues that are using a custom cascading field to indicate what type of leave it is. Instead of duplicate the rows where the field has two values, how can I combine that into a single value/row?

[Tracy Chow · Accepted solution]

Hi Mikael,

It would depend on how you want to format the data in your chart. In my example, I have the data in 3 columns: Issue key (from "Issue" table), Name (from "Issue field"), and Value (from "Issue field"), and I have it filtered to only display my cascading field.

Since the parent and child values of the cascading field are in the same column, I can use a "Pivot" step to separate them into their own columns.

Then I added a "Formula column" step with the following custom formula which concatenates the parent and child values.

"Function (parent)"||" - "||"Function (child)"

This returns the value "Marketing - Email" and you can subsequently hide the original parent and child columns.  

Let me know if this helps, or if you have questions about this approach!