How do I add a cascading field to my table and then extract child values in atlassian analytics?
We have a custom field called Service Incident which has a parent and child field (Revenue, Knowledge Gap). Is there a way for me query the columns separately as right now they are shown together. The purpose of this is for use in Atlassian Analytics and to break out the data separately so that Revenue would be in the "Service Incident (Parent)" column while Knowledge Gap would be in it's own column "Service Incident (Child)"
As of now I'm having trouble getting the field to even show up in our data (via schema page in Data in Atlassian Analytics). Does it have something to do with the way that I'm trying to create the custom column? SQL I tried using for the custom column:
'PS Service Incident[Select List(cascading)]'
I've also tried to use a custom table where I wrote this with no results as well:
CASE WHEN `Issue field`.`name` = 'PS Service Incident[Select List (cascading)]' THEN `Issue field`.`value` END AS `PS Service Incident (cascading)`,
