Graph counting issue
I am using the sum of the reciprocal technique to count the number of different sources of advertising we get each month from a list of 15 or so. I also want to add a second column on the graph to show the number of sources that actually result in an order being placed,. the find is based on my customers table, and there is a field in these records that has a number in it that shows the amount of orders placed. I only need to know if an order has been placed as opposed to how many. How can I add this to my graph? I have tried various field calcs but seem to only get the graph to count every record of the same source having an order even if only one record has placed an order... Any ideas?
Need to fix my sorting field first in case this is the issue! Thanks to PhilModJunk