Forum Discussion
Need Help creating yes no fields
Hi Guys,
I have some data from Jira and I am trying to group some labels and show it against the issues table with a yes no column, however its producing yes and no results, meaning I have 2 rows per issues on each group I made.
I need it to be only 1 row in which if it contains that label I want it to say yes and if doesn't I want it to say no on 1 row as shown on my ideal screenshot.
How can I accomplish this?my attemptideal outcomerelationship between tables
Hi Raf_Joker ,
I am confused. What is exactly is your ideal outcome? The relationship view doesn't show how you want the data to be shown in a visual. If you want it to just show Yes per unique ISSUE_KEY, you can create a calculated column that counts the number of yes per ISSUE_KEY and if that yes is more than 0 then return Yes for all the rows of that ISSUE_KEY. Sample formula
yes/no = VAR YesCount = CALCULATE ( COUNTROWS ( Labels ), Labels[Yes/No Column] = "Yes", ALLEXCEPT ( Labels, Labels[ISSUE_KEY] ) ) RETURN IF ( _YesCount > 0 || _YesCount <> BLANK (), "Yes", "No" )
2 Replies
Hi Raf_Joker ,
I am confused. What is exactly is your ideal outcome? The relationship view doesn't show how you want the data to be shown in a visual. If you want it to just show Yes per unique ISSUE_KEY, you can create a calculated column that counts the number of yes per ISSUE_KEY and if that yes is more than 0 then return Yes for all the rows of that ISSUE_KEY. Sample formula
yes/no = VAR YesCount = CALCULATE ( COUNTROWS ( Labels ), Labels[Yes/No Column] = "Yes", ALLEXCEPT ( Labels, Labels[ISSUE_KEY] ) ) RETURN IF ( _YesCount > 0 || _YesCount <> BLANK (), "Yes", "No" )Thank you, yes that has helped and will give me my desired outcome.
