How do I group together data?

[#1]

I have imported the data from SQL.

Its a list of questions that need to be answered by different people.

When importing the data into a chart,I have the questions displaying as

1,2,3,4,5 then 1,2,3,4,5 and so on.

I would like it to display just once, so its Question1 and then the answers. but not sure if im tackling the problem right?

Any suggestions would be welcome?

Please see below an example of what im talking about.

Thanks

[er_mohit · Accepted solution]

Have you tried distinct function like

load distinct

A,

B,

C

from table;

or you can write this in your expression side

like sum(Distinct fieldname)

hope it helps

[#3]

Thank you, seems so simple now!

[#4]

Thank you, seems so simple now!

[#5]

Thank you, seems so simple now!

[#6]

Thank you, seems so simple now!