Distinct Count

[chrisrgr]

I have made a database for a school project that lists all the affordable housing units in the country. Each record has the information of the developer that built the unit.

I need to be able to list the top 10 developers that build the most units. In SQL there is a distinct count command, can someone please show me how to do this in FMP 9

[mr_vodka]

This post should help you get started.

Ranking

[chrisrgr]

That ranking function makes sense but in my case I am going off of unique phone numbers for developers. So how would I be able to show the "statistical mode" of these phone numbers? I thought about adding all the numbers to a global field and using a pattern count but not sure how to do it, or if this is even the right approach.

Ultimately I would like to run a report that shows the top 10 developers that developed these housing projects.

[chrisrgr]

doesn't look like the file will upload right off of my server must be a firewall problem

[comment]

Try a report with a sub-summary by developer. You can re-order your sort by a summary field (which would be a count in this case).

[chrisrgr]

Here is the database file

Affordable_Housing.fp7.zip