bar chart with large number of data points

[marko_rakar]

I am trying to create chart (line chart or something similar) with a large number of data points.

I have thousands of records of total turnover per customer; my idea is to create chart which will show distribution of turnover per customer. Horizontal axis should be total turnover (from zero to max recorder amount), and vertical should be count of turnover. Also since tunover is different for each customer I should probably round them somehow (thousands, tens of thousands, every five thousand or someting similar).

Result should be chart which shows some kind of bell curve which show distribution of turnover per customer.

Any ideas on how to do this properly and show full range of values in a single chart?

[swuehl · Accepted solution]

You just need to define how large your buckets should be (round to what amount of turnover).

Then use either a calculated dimension with (for a bucket size of 1000)

=class(TurnOver, 1000)

or create a field for your dimension in your load script in a similar way, and for the expression use

=count(distinct Customer)

You may need to enable a continuous axis on axis tab to also see buckets with zero customer count inbetween.

[phaneendra_kunc]

I know you are looking for a Histogram, but have you tried a Scatter Chart?

This will give you a nice distribution with bubble size.

[marko_rakar]

thanks, this solved the problem

there are literally limitless possibilities with charts and it is interesting that this particular case wasn't covered in any of the tutorials (and books) I have read (unfortunately I see that I do not have option to upload my example for others to see)