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, 200817 yr by Guest
moved out of open solutions

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, 200817 yr by Guest