Trying to plot a normal distribution

[#1]

Hello,

I am trying to create a diagram showing the normal distribution of pallet weights in a machine.

The weight of the pallets, which carry coils with unique ID's, are calculated as the sum of the coil weights as shown below.

PalletID	CoilID	CoilWeight
1	1	100
1	2	50
2	3	200
1	4	90
3	5	100

In the example above, PalletID 1 has a total weight of 240 (100+50+90).

Now I would like to plot this table as a diagram with PalletWeight as X-axis and quantity as Y. Furthermore, I would like the X-axis to be presented as a couple of ranges; i.e. 0-50, 51-100, 101-150, 151-200 and so on.

When I use PalletID as dimension of a bar chart and Sum(CoilWeight) as the expression, I get the pallet weights over palletID's, but I have no idea of how to get the normal distribution over some ranges of weights.

Do you have an idea?

Thank you

[Anonymous · Accepted solution]

If I understand you correctly then one way you can get this is by using a caculated dimension

fe:

Calculated Dimension:

=IF (CoilWeight < 51 , '0 - 50' ,

IF (CoilWeight  >= 51 and  CoilWeight <= 100,  '51-100',

IF (CoilWeight  >= 101 and  CoilWeight <= 150,  '101-150',

IF (CoilWeight  >= 151 and  CoilWeight <= 200,  '51-200',

'201 +'))))

Expression:

SUM(Quantity)

This calculated dimesion groups your Dimension.

Let me know if you get this to work, and if this is what you are looking for.

Good Luck,

Dennis.

[#3]

Thank you.