Create chart showing survey response distribution

[#1]

Hi -

I'd like to create a chart showing the distribution of survey responses.  The survey scale is 1 to 10.

The value for each [EMPLOYEE_ID] is contained in [Q1].

Dimension = [Q1]

Expression =  COUNT ( DISTINCT EMPLOYEE_ID )

This works as expected, it plots the number of employees answering 6, 7, ... etc.

The problem is that i'd like the graph to show all 10 columns and the data does not contain some of the possible values.

For example, there are no 1's so the chart starts at 2.

Any ideas please?  Thanks!

Pat

[swuehl · Accepted solution]

Create an additional table containing your field Q1 with all values:

Table:

LOAD recno() as Q1 autogenerate 10;

And disable 'Suppress zero values' option in presentation tab.

Hope this helps,

Stefan

[#3]

Brilliant.  I just added 10 rows to my data set with EMPLOYEE_ID with blanks and 1 - 10 in the Q1 values.

Thanks!

[Lee_Matthews]

Hi Patrick

There used to be a training evaluation application on the demo site that presented feedback in much the way you are after. I have attached the application. This might help with your formatting and other UI work.

Regards

Lee