Custom Column Returning Duplicate Rows

Fabio Saltos May 22, 2024

I added a new custom column in one of our data source's schema to capture 'Start Date' from the Issue Field table. For some reason the new custom column is returning  duplicate Issue ID rows with only one row containing a value. The other duplicate Issue IDs return blanks.

How can I ensure the new custom column is only pulling a one to one match?

Here is the query i'm using:

CASE WHEN `Issue field`.`name`= 'Start date' THEN `Issue field`.`value` END



Screenshot 2024-05-22 at 11.31.27 AM (2).png

1 answer

0 votes
Tejaswi G
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
May 27, 2024

Hi Fabio,


This is Tejaswi from the Analytics team and here to assist.


We would like to review your current table setup in the Analytics to assist you. Can you please log a ticket at to look into the issue?


Kind Regards,


Fabio Saltos May 28, 2024

Submitted! Thanks, Tejaswi.

Suggest an answer

Log in or Sign up to answer
AUG Leaders

Atlassian Community Events