Forum Discussion

Raf_Joker's avatar
Raf_Joker
New Member
3 years ago
Solved

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 pe...
Need Help
  • danextian's avatar
    danextian
    3 years ago

    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" )
danextian's avatar
danextian
Super User
3 years ago

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" )
  • Raf_Joker's avatar
    Raf_Joker
    New Member
    3 years ago

    Thank you, yes that has helped and will give me my desired outcome.