Create a report with monthy totals

[RSAAdmin]

Has anyone found a way to create a report that shows monthly totals, spanning over several months?

For example, I'm looking for a way to create a graphical report that shows the total number of MessageID's

per month, over a several month period.  Something like this would be used to show the number of failed

logins per month ( May, Jun, July, etc. ). 

Within the Create/Modify Report Window when you select fields there is NOT an option

for selecting something like "DATEFORMAT(Event Time, 'yyyy-mm')". 

Daily totals can be reported with the "DATEFORMAT(Event Time, 'yyyy-mm-dd')" selection, but

I've found no way to report on monthly totals spanning a several month time period.

Is there another way of accomplishing this task without the missing "DATEFORMAT(Event Time, 'yyyy-mm')"

field option?

Thanks,

Mike

[AlanLaurencelle]

Understanding that there is no yyyy-mm format, a work around would be to use a csv output and then put it together in another reporting package - it could be a simple as Excel. 

From a roadmap perspective, we are _planning_ on enabling better trending functionality to do analysis like this.

Best Regards,

Alan

Message Edited by alan.laurencelle on10-31-200812:58 PM