I'm still wondering about this.
(It is probably not a very appreciated practice to 'bump' a post upwards the way I'm doing right now, so I promise only to do it once).
bump is appropriate!
Where are you placing the values of the result? If you have it as a field and include the select based on the account, then you will have only those values.
There is no field names for coding, so it is hard to explain but assuming
you need one more criterion
ExecuteSQL ( "select COUNT (*) FROM Contactmoments WHERE FollowupType = 'Call' AND AccountManager=? " ; "" ; "" ; someTable::AccountManager)
Ok, I managed to get back to this. My apologies for first bumping this up, and then getting busy with other work.
Dear beverly Thanks.
Where am I placing the the values of the result, you ask. I'm not sure I understand.
ExecuteSQL ( "select COUNT (*) FROM Contactmoments WHERE FollowupType = 'Call' " ; "" ; "")
cause I would like its values to go straight into the graph, split per accountmgr, just as it did for the Count(Objects::ID).
I think your're heading the direction of: Creating a new calc-field in the contactmoments-table, with the calc being ... err...
Or wait, maybe I need to create 5 global fields, counting respectively 'Call', 'Follow up' etc. ...No that won't work cause then they won't be split per accmgr.
I'm stuck. In the end my question is: What could I type under "Data" to make FM count all contactmoments with the followup type 'Call'? FM has shown in the two succesful tables that it can/will then split the data per account manager.
Dear user19752 Thanks.
I included your suggestion, (even though you can see above that my line of thought is that FM seems to be able to make the distinction between the accountmgrs based on the x-axis-definition), so I made it:
ExecuteSQL ( "select COUNT (*) FROM Contactmoments WHERE FollowupType = 'Call' AND Firstname=? " ; "" ; "" ; AccountManagers::Firstname)
But all goes to zero then. I did it for "Call" and for "Follow up":
I'm not there yet...