Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

How do I add a cascading field to my table and then extract child values in atlassian analytics?

Dan Cheung
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
July 30, 2024

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)`,

Screenshot 2024-07-30 at 2.55.52 PM.png

0 answers

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
TAGS
AUG Leaders

Atlassian Community Events