AnsweredAssumed Answered

How do I Create This Pie Chart?

Question asked by joshuaw07 on Mar 1, 2017
Latest reply on Mar 2, 2017 by jbrown

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.

 

Screen Shot 2017-03-01 at 9.04.26 AM.png

Outcomes