Custom Column Returning Duplicate Rows

Fabio Saltos

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

 

Example:

Tejaswi G

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 https://support.atlassian.com/contact to look into the issue?

 

Kind Regards,

Tejaswi