The image below is from a simple excel sheet. I am trying to recreate this excel chart within Filemaker.
Within Filemaker our Team submits a weekly report of the total number of leads they processed and, of the total leads, the total number of qualified leads processed. We currently have to use Excel to generate a pie chart and then paste that image into the Filemaker report. If I can get the chart to display in the weekly report, we can eliminate the use of Excel.
So, each week a user will create a new weekly report, which creates a new record. Within the new record, or weekly report, the team member enters the total number of leads processed in a field and then, of the total leads, enters the total number of qualified leads processed in another field.
If possible I would like to have the report then display a pie chart accurately showing the percentage of qualified leads within the total number of leads processed.