How would I go about creating a chart to represent the percentage value instead of a numeric value. My data is a little different in the respect that I'm counting the presence in the data rather than its value (which is 'yes').
My data is below:
There were 149 distinct people answering the question and 267 boxes ticked in total - it was a multiple choice question and as many of the options could be ticked as wanted with at least one box having to be ticked.
In a single bar chart I would like to represent each option's percentage value - 84.56% of people clicked Option 1 and 44.967 people clicked Option 2 - how do I put those values on a chart instead of the actual numbers.
If I click 'relative' it shows 47% for Option 1 which is not really what I want to represent - 47% is 126/267*100 rather than 126/149*100.
I can get the distinct count of how many people answered any question for the chart label but when I try to use this value for the definition =count( Distinct ID) the chart just gives me a value for 1 for each option.
I'm sure there's an easy answer (I hope there is) but I'm not able to figure out what I need to do so any help is greatly appreciated.
I suppose what I want to be able to do is to use the value of 149 (in this case) in the expression definition without explicity writing in 149 - what do I need to type that will give me 149. If I can get that I can then change the number format to show in percentage quite happily.
Give this a try. I created a variable to store the number of participants (vParticipants). I did it manually in the load script. It can be done in multiple ways, but from your dataset, there is no way to infer that 149 participated. All we know is that at least 126 did (the number that answered 1).
Once you have the number of participants defined, you take the number of clicks divided by the number of participants and you have your percentage.