174605 - no subject - Hi, say I have a case to count a total s

We have discussed this just recently. Our solutions were: Add a field that holds a date that is always the first of the month in which the meeting was created. This way you can aggregate on this field. The other solutions was to have a process that is running in a certain interval to create the data for reporting purpose in a separate table/CDT.

hi stefanh, so is there other way to done it without CDT manipulation? i.e using function. So far i found out that month() function returns integer and with apply(), it can become an array of submitDate in integer. From there on I'm stuck at how to construct an sum array that consist of the sum of the same number in the previous array. i.e. from submitDate array {1,1,1,1,2,2,2,3,3,4,4} to am array of {4,3,2,2}.

This will work, but is not efficient as processing data in SAIL is considered slow. Think of having several hundred or thousands of meetings. It is best practice to let the database do the heavy lifting. A third solution would be to create a view in DB which uses a DB function to display the month and does the aggregation in one step.

Ah, I forgot about the data efficiency consideration. Thanks