How to bring in Jira custom field

I’ve loaded in a Jira dataset into QuickSight and a custom field is not showing up from the dataset. Has anyone found a workaround for this? On how to bring that custom field in?

Hello! by custom field, do you mean calculated field?

Hi! It is not a calculated field. The Jira dataset does not typically have this field but it was specially added in from my team. I see the field when importing the dataset but there’s no data populated. So just wondering how to get the data from Jira into QuickSight since it’s not an out of the box field.

If it’s still not working I would suggest dumping data to s3 and then querying it with Athena.

That should solve the problem of a customized field and give you a lot more flexibility as well.