Hi,
I can get the chart function returning results and displaying, but it isn't what I though it was. Can the chart function add columns of the same name?
I have a DB with lists of peoples name, against an event type, and I put a '1' value in thee for good measure for a count in EXCEL if needed. Many of the names are entered into the DB dozens of times against the same type of event or different. Does the chart have the ability to add by same type. For instance if I was in the DB 15 time and attended 7 meeting, 5 training, 3 drive, could the chart show that. It would be in the DB as 15 separate lines.
If not is there a simple script that I can write that would output that kind of result?
Current Result output as attached, you can see what I mean by wanting to count the events of similar type. So I want it to return Monthly Meeting 2, Officer Meeting 2, The rest would be one. At the end of a calendar year this result would be huge otherwise. We only have 7 event types for reporting.
DB looks like, attached. Dont need it to sort by name as this is being called in the selection process through a table and article_id= in the web address.
Thanks.
I can get the chart function returning results and displaying, but it isn't what I though it was. Can the chart function add columns of the same name?
I have a DB with lists of peoples name, against an event type, and I put a '1' value in thee for good measure for a count in EXCEL if needed. Many of the names are entered into the DB dozens of times against the same type of event or different. Does the chart have the ability to add by same type. For instance if I was in the DB 15 time and attended 7 meeting, 5 training, 3 drive, could the chart show that. It would be in the DB as 15 separate lines.
If not is there a simple script that I can write that would output that kind of result?
Current Result output as attached, you can see what I mean by wanting to count the events of similar type. So I want it to return Monthly Meeting 2, Officer Meeting 2, The rest would be one. At the end of a calendar year this result would be huge otherwise. We only have 7 event types for reporting.
DB looks like, attached. Dont need it to sort by name as this is being called in the selection process through a table and article_id= in the web address.
Thanks.