http://forums.visokio.com/discussions/tagged/useful_formulae/feed.rss Mon, 30 Oct 17 15:47:58 -0400 Tagged with useful_formulae - Visokio Forums en-CA http://forums.visokio.com/discussion/3126/subset-formulas-calculating-of-total-per-category Thu, 12 May 2016 11:34:25 -0400 MPatel 3126@/discussions
I have survey data and i want to show data by the percentage of control and exposed respondents. The data is categorical.

Column A; Column B; Column C
Respondent 1 ; Control; Competitor A
Respondent 2 ; Control; Competitor B
Respondent 3 ; Exposed; Competitor C
Respondent 4 ; Exposed; Competitor A
Respondent 5 ; Exposed; Competitor B
Respondent 6 ; Exposed; Competitor C

The chart needs to show two bars for Competitor A, one control and one exposed. Control would be 50%, Exposed would be 25%. For competitor B it would show Control 50%, Exposed 25%. For competitor C it would show Control 0%, Exposed 50%.

Any idea how to do this??]]> http://forums.visokio.com/discussion/2301/idea-formulae-custom-bucket-intervalss Thu, 29 Aug 2013 11:00:48 -0400 starsky51 2301@/discussions