I used ExecuteSQL to get myself 3 fields that represent:
1. Total number of records
2. Total number of records that made it to Level 2
3. Total number of records that made it to Level 3.
I am trying to create a Pie Chart to show the percentage comparison. I could also do a bar graph, that's fine too.
How do I select each field to be used in the chart?? It looks like I can only choose one field for the source data, which is confusing me. I'm used to Excel where you can just highlight a number of cells. I assumed FMP would be similar but fields instead of cells. Do I need to combine the fields myself first somehow?