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])

    )

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
    Icon for Super User rankSuper User
    1 year ago

    hi Hjameelaq ,

     

    try to write a calculated column like:

    Column =

    DIVIDE(

        data[value],

        SUM(data[value])

    )