Forum Discussion

Hjameelaq's avatar
Hjameelaq
Regular Visitor
1 year ago
Solved

Multiple answers and using other

Hello all, I have a multiple answer question and I want to make a bar visual which is something I know how to do. What I want is to show only options that have 3% higher and show other option instea...
  • FreemanZ's avatar
    FreemanZ
    1 year ago

    hi Hjameelaq ,

     

    try to write a calculated column like:

    Column =

    DIVIDE(

        data[value],

        SUM(data[value])

    )

FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
1 year ago

hi Hjameelaq ,

 

supposing you have two columns: answer and percentage, try to plot the barchart with two calculated columns:

 

answer2 =

IF([percentage]>=0.03, [answer], "Others")

 

Percentage2 =

IF(

    [answer]=[answer2], 

    [percentage], 

    SUMX(

        FILTER(data, data[answer2]="Others"),

        data(percentage)

    )

)