Help required-trying to create a distribution table

Thu, 11 May 2017 16:21:14 GMT

Hi I have some survey data where questions are answered with a score 0-6. I am trying to create a table/grid that show the % of respondents for a given score by item:

EG:

Header 1	Header 2	Header 3	Header 4	Header 5	Header 6	Header 7	Header 8
	0	1	2	3	4	5	6
Item ID 1	5%	15%	20%	23%	17%	10%	10%
Item ID 2	3%	17%	23%	20%	10%	17%	10%

Any ideas where to start? Any suggestions gratefully received.

The data is stored as a filed called the ITEM ID# and consists of a series of scores between 0 and 6

Re: Help required-trying to create a distribution table

swuehl — Thu, 11 May 2017 16:42:38 GMT

If your table shows two fields, Item and Score, you can create a pivot table chart with these two dimensions, and a single expression

=Count(Score) / Count(TOTAL<Item> Score)

topic Re: Help required-trying to create a distribution table in App Development

Help required-trying to create a distribution table

Re: Help required-trying to create a distribution table