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

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.
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

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

Sign in to reply

Verify Answer

Cancel

Children

No Data