3 Replies Latest reply on Apr 5, 2013 6:35 PM by Joshua Milligan

    percentage of total in a measure

    Manali Nekkanti

      Hi there,

      I have several yes/no questions coded as measures that I would like to compare side by side. Specifically, I'd like to look at proportions (%) rather than number of responses.


      I know I could create calculated fields for each one separately by doing sum(var)/count(var). But that will get mighty tedious for dozens of dimensions. Is there some way to calculate percentage of total for all of them at once? Something like sum(measure values)/count(measure values), that will apply to all measures and calculate only for the measure of interest?


      thanks for your help!