Line graph showing count of multiple date fields

[ColonelGoat]

Trying to create a line graph that will graph two separate lines for two different date columns. Here is my data:

Acct Enrolled Trained
123 01/05/2009 02/12/2009
456 01/28/2009
789 02/03/2009 02/05/2009
987 02/05/2009 02/10/2009
654 02/12/2009 03/01/2009
321 03/03/2009 03/12/2009

I need a line graph that counts the number of dates in each month and plots each months results per date column.

I am pulling this data from SalesForce and tried to do a union in the Add Command function of the Database Expert but SalesForce won't let me do that. I keep getting an 'unexpected token error'.

Any idea?

 

[lbass]

Do you want to try the command route again? If so, please show a copy of your SQL query from database->show SQL query, and then also show the union command that you first tried.

-LB