Bar Chart - Grouping Dimension

[prees959]

Hi,

I have a simple bar chart that counts the number of sales by a sales rep.

Would it be possible to display the number of users with a certain amount of sales rather than an individual user?

er; if the graph shows :

User A 25 Sales

User B 25 Sales

User C 40 Sales

User D 40 Sales

User E 40 Sales

User F 2 Sales

User G 10 Sales

could it effectively show:

40 Sales - 3 Users

25 Sales - 2 Users

40 Sales - 3 Users

10 Sales - 1 User

2 Sales - 1 User

Many thanks,

Phil

[sunny_talwar · Accepted solution]

May be this

Dimension

Aggr(Sum(Sales), [Sales Rep])

Expression

Count(DISTINCT [Sales Rep])

[prees959]

Perfect Thank you!

[vishsaggi]

Hello Phil,

Can you close the thread Marking Sunny's response correct/helpful. That way other members can benefit from your query.

Thanks,
V.

[prees959]

Hi I hope you don't mind me asking another question on the back of this one?

I would like to show the average number of sales a rep would make?

Thanks,

Phil,

[sunny_talwar]

May be this

Dimension

Aggr(Avg(Sales), [Sales Rep])

Expression

Count(DISTINCT [Sales Rep])

[prees959]

thanks !!