Search code examples
percentagespotfire

Percentage Calculation in Spotfire

DataSet_Image

This is the data that i've in Spotfire like this and trying to arrive at a percent calculation with the logic.

The formatting messed up the first time i posted the question.

Percentage for Instagram: (Count of Instagram) / (Count of all Social network)

Can you please help me with the calculation?

Solution

  • I'd do it with a cross table:

    • set "Question# 1" as row header
    • enter this expression as value: Count() / Count() over (All([Axis.Rows]))

    enter image description here