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

erick258 over 9 years ago

Hi, say I have a case to count a total submitted per month and plot them in line/bar chart base on its submitted date. Anyone got some insight how to produce an array consist of the monthly total submitted?

I'm using such CDT as below image.

Discussion posts and replies are publicly visible

Parents

0 Stefan Helzle
A Score Level 3
over 9 years ago

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.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Stefan Helzle
A Score Level 3
over 9 years ago

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.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data