Group dimesion. Aggregate problem

[#1]

Hi Community,

Here's the sample bar chart. This chart have 3 dimensions ( Date, Response, Role) and 1 expression: count(Response)

This chart yield correct response count. But I want to display this bars with a single color. Or more likely I don't want to display the Roles in the dimension.

Any idea? I'm looking at aggregation function to solve this.

Thanks!

[#2]

Hi,

Cant you just delete Roles from the dimensions?

Br /Daniel

[#3]

Hi daniel,

Thanks for the response but I need the Role Dimension (since some user have 2 or more roles).

I'm thinking if I can use aggregation on this? group response according to roles?

[#4]

Hi Ronald,

you are here ?

The question from Daniel is not so bad. Or do I understand your problem not quite clear? If its only a design problem, take a look at the colors tab and use the same color. Thats to easy, isn*t it ?

Regards

Roland

[#5]

Hi Roland and Daniel,

Here's another image I want to achieve. This chart has two dimension (date and response)

Notice the inconsistent count for each bar. This inconsistent count caused by user with multiple roles. So I put the role in the dimension and got the numbers I want. unfortunately with different presentation. If only I can group the response per role. (Honestly i can't fully understand aggregate function )

[#6]

try:

=aggr ( count ( Response ) , Role )

or

Set the expression color to a fixed color, that might work also.

[#7]

Hi Jesper,

I've tried your suggestion but still not what I want to achieve.

Anyone?

Thanks

[#8]

Hi,

do you can post your qvw document?

[#9]

Hi All,

Please see attached file.

Thanks in advance!

[#10]

Hi,

remove the section access. I don't can access the document.