How to count all possible values of a field in a file

[Yupp]

I need al solution for a count of all possible values of a field. In the example file there are only two fields (Id, name) and 18.000 records. I reality I have 200.000 records and 20 fields. I need to make graphical representations of the number of occurrences of (almost) each field.

For instance:

time > how many at 01:00, 02:00 etc

place> how many in NY, Dallas, LA, Chicago

day> how many on monday, tuesday etc

Can someone give me a solution using the sample file below. The sample file has a count function for the preview. But I need to process the results, so preview is not working for me.

Yupp

test.zip

Edited June 13, 2008 by Guest
moved out of open solutions

[SurferNate]

There are at least three or four ways to get what you want. I can tell you that a self join based on any field for which you want a summary is a good place to start. Also, make sure that everything is STORED and INDEXED. On 200K records, if you have unstored or non-indexed values in your relationship, you will most likely have to wait a long time each time for your results. Others here will recommend scripting and reporting on subsummary values. It all depends an the specific output you need.

P.S. - That's an excel file. You will almost always get better results here if you build something close to what you want in FM and post it.

P.S. - You might want to look into GetSummary() also.

Edited June 14, 2008 by Guest