AnsweredAssumed Answered

Pie charts??? Comparing 3 field numbers.

Question asked by ezeitgeist on Dec 5, 2016
Latest reply on Dec 5, 2016 by ezeitgeist

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?

Outcomes