Organizing my data

Answers
-
Depending on how your raw data is structured, some combination of "Aggregate" or "Generate Aggregation" or "Pivot" should do the trick. If you post a sample of your data and your process, people here will probably be able to be more specific.
2 -
What @Telcontar120 said. One of the best set of operators for tabulating and organizing data is the Aggregate, Generate Aggregate, Join, Append, and even the Generate Attribute operators.
2 -
Many thanks for your replies. How to write the avge() function in the function expressions area ?
0 -
You can use the expression editor to browse through all the functions that are available in "Generate Attributes". Just click on the little notepad icon on the function expressions bar. It's very helpful. The average function is AVG(numeric,numeric,etc.)
1