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 instead of these options that are below 3% and show a small hint underneath thus bar saying other options include 1, 3 blah blah... can you please help!

 

 

Regards, Hanna

  • FreemanZ's avatar
    FreemanZ
    1 year ago

    hi Hjameelaq ,

     

    try to write a calculated column like:

    Column =

    DIVIDE(

        data[value],

        SUM(data[value])

    )

4 Replies

  • FreemanZ's avatar
    FreemanZ
    Super 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)

        )

    )

  • Hjameelaq's avatar
    Hjameelaq
    Regular Visitor
    1 year ago

    I will give this a try, how can we show these options on table like saying 

    Others is blah blah blah...

  • Hjameelaq's avatar
    Hjameelaq
    Regular Visitor
    1 year ago

    How do we calculate the sum of all values for a column to be able to calcuate the % for each ? 

    • FreemanZ's avatar
      FreemanZ
      Super User
      1 year ago

      hi Hjameelaq ,

       

      try to write a calculated column like:

      Column =

      DIVIDE(

          data[value],

          SUM(data[value])

      )