Counting unique values in a field

[Bempster]

Hi, I'm pretty new to FileMaker and am trying to create a report and chart that shows the occurrences of a various cylinder sizes that we use in our facility. I have a list of items each of which has a cylinder size assigned. What I am ultimately looking for is a report and pie chart with the slices showing the percentage of use forr each size. I have tried the example from the Filemaker Support page "Counting the Number of Unique Values in a Field" and cant quite figure out what the calculation entries in field "B" should be (I bolded the entries that I don't understand). Below is the description of the four fields that are required. I have replaced my entries where applicable

 

 

A) The first field is a summary field called "Cylinder Count":

 

Cylinder Count (Summary) = Count of Plate Cylinder

This will count the records.
 

B)The second field is a calculation which produces the number of records within a group:

Break (Calculation, Number result) = Summary (Region Count, Region)
 

C) The third field is a calculation that returns a numerical weight of a record in the group when compared to the total records for the group. For example, for a set of ten records, this calculation returns the fraction, 0.1 (i.e., 1/10). This is the formula:

Occurrence (Calculation, Number result) = 1 / Break
 

D) The fourth field is another summary field that totals the fractions generated by the third field above, giving you the total of unique values in the field:

NmbrOfRegions (Summary) = Total of Occurrence

My result comes up as a decimal instead of a count. I think if I can place the correct calculation in the Break field it will work. Thanks in advance for any help that someone can offer.

[Lee Smith]

Automatic message

This topic has been moved from "FileMaker Pro 12" to "Calculation Engine (Define Fields)".

[comment]

What I am ultimately looking for is a report and pie chart with the slices showing the percentage of use forr each size.

 

I don't think that's the same thing as counting the number of unique values. For example, given:

 

# SIZE

1 20

2 30

3 40

4 20

5 30

6 20

 

counting the number of unique values will return 3 {20, 30, 40}. OTOH, the percentage of use for each size is:

20: 50%

30: 33.3333%

40: 16.6667%

[Bempster]

Maybe I'm shooting for the wrong thing. The second scenario looks more like what I need. I would also like to show the number of times each is used. Based on your example it would be 

20: 3 - 50%

30: 2 - 33.3333%

40: 1 - 16.6667%

Any idea on how I would go about making a record that would get me there?

[comment]

See the attached.

SummaryPercentage.fp7.zip

[Bempster]

Thanks for the help Members. You definitely have me on the right track. Only thing now is my  sPercentage is coming up 0. Could it be due to my Value field (Plate Cylinder) being a calculation?

(DieInventory::Size Around + DieInventory::Space Around) * Plate #Around * 8,     Result Number

[Bempster]

Yeah!!! I figured it out and got what I needed. Ended up using a bar chart because it showed the occurrences more clearly. thanks again.