Count repetitions

[Jorgitopeter]

Hi everyone, I'm finishing my great brand new filemaker database! (my first data base!) It's an amazing soft!

But I can't find the function to calculate how many times does a number repeat in found records... I need to add that fuction to this script Audio Freak gave me:

-Enter Find Mode

-Set Field [Calls::Date_Time; Case( Customers:: Range_ "today"; Get(CurrentDate)...]

-Go to Layout...

-Perform Find

I attach a picture to explain you better. I also attach my table, and you all are invited to take a look at this beginner's database.

Thanks my dear teachers!! You make the learning easier for all us newbies B)

Table__look_at_the_report_layout_.zip

[Fenton]

I assume you're trying to find out how many times a City Zone shows up in the found set? I can think of a way to calculate the number for the found set. It uses the GetSummary (field; break field) function. Which requires two things, a Summary type field to summarize, and a Sort by the break field (City Zone in this case).

This would produce the number, in the record, for any found set. If however you want to show the count for a City Zone on the date of that record, a different method could be used, which would not require a Sort (or Summary field).

It would use a self-relationship on the City Zone AND the Date. Then it would count that:

Count ( Calls_CityZone|Date::Date)

It would always be the same for a record, no matter what the found set (even 1 record).

So, it kind of depends on exactly what you want as to which method. The GetSummary() method works always WITHIN the found set, and requires a Sort. The self-relationship method has nothing to do with the found set.

cct_BIEN3_Unificaci__n_fej.fp7.zip

[Jorgitopeter]

Thanks Fenton for your help. I was looking for the first option you gave me (I mean Getsummary fuction). But I just can't realize how to create a field which shows me the cityzone that shows up more times in the found set. I mean, I've created a field which tells me what is the maximum in "_cCount_CZ_getSUM", but I need a field that tells me which cityzone shows up that maximun times. I'll need answer the question "Which is/are the cityzone/s that shows up more times in the found set?"

Maybe I repeat things, but because of my bad English, I'm afraid you won't understand me. Sorry.

Thanks for the try! Good Luck

cct_BIEN3_Unificaci-__n_fej.zip

[Fenton]

I could much more easily show you "which one comes up the most times one a date", or "which one shows up the most in a particular week" (WeekOfYear), or "which one shows up most times in a month." Because those could be a self-relationship on known ranges. Showing which one comes in the found set is more difficult, and could likely be more easily "shown" in a sorted Preview report, or by looping through with a script.

So, really, is the business reason that you want to see how many in a fixed date range (date, week, month, year), or does it have to be whatever the found set is?

[P.S. I tried that Max() also. It seemed to work with all records, but did not in a found set; don't know exactly why.]

cct_BIEN3_Unificaci-__n_fej_2.fp7.zip

Edited December 17, 2007 by Guest