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?
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!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.