Creating a bar chart from survey results

[#1]

I have the following survey results

Response ID	Response
1	Within the last year
2	Within 2 years
3	Within last year
4	Within last year
5	5 years or more
6	Within the last year

How do i create a bar chart with count of responses, per response. Response on the x axis.

Thanks in advance,

Rebecca

[buzzy996]

seems to be all are different conditions, so u can use ur Response ID as ur dimension and on ur expression if Response ID=1,then count(Within the last year responses)

2nd expression: if Response ID=2,then count(

Within 2 years

r responses)..

so,similarly u can create 6 expressions.

HTH

[vinieme12 · Accepted solution]

Use

Dimension

: Response

And

Expression

Count(Response)