2 Replies Latest reply on Dec 5, 2016 11:23 AM by ezeitgeist

    Pie charts??? Comparing 3 field numbers.

    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?