3answers

Progress Chart

I have a field in my database called progress. This field for now is a checkbox set that has the choices, “Un Started” “In Progress” and “Complete”. Eventually I want an elaborate way to start determining the progress of certain tasks. For now this is a start to understand the way I will construct it. Is there a way to construct a chart that would take (let’s say) 8 tasks and average there progress field and summarize it to show an average bar of where there over all progress is. So I mean on a scale of 0 – 100 with 0 being “Un Started” 50 being “in Progress” and 100 being “Complete”. I also would like to know if you would have to use a script to show the found set of 8 (8 is just a number of tasks or a particular job could be 5, or 11) or is there a way to only chart for related records.

Chris Johnston

Answers

Chris,

Hello again!

Attached is a charting example that I created especially for you. I hope that upon reviewing it, you are able to understand how to setup a chart in your own FileMaker application!

FileMaker Charting Example.fmp12

Here's a screenshot of the example file. The example file consists of two tables: Jobs and Tasks. The Status field in the Task table is setup to contain a value ranging from 0 to 1 in increments of .1 (or 10%).

FileMaker Charting Example Screenshot - Grasp Learning

The two tables Jobs and Tasks are linked via the Job primary id. Here's a screenshot of the relationship graph.

FileMaker Charting Example Relationship Graph - Grasp Learning

Here's a screenshot of the Chart Setup. It's quite straightforward - I selected the "task::name" field as the data for the X-Axis and the "task::status" field as the data for the Y-Axis.

Grasp Learning Charting Example Chart Setup Window - Grasp Learning

FileMaker gives you a couple of options when selecting which data to include in the chart. For this example, I selected "Related Data" as the data that I wanted to include in the chart resided in a related table.

Grasp Learning Charting Example Chart Data Source - Grasp Learning

Cheers!

Kevin

Kevin Kurpe

That is EXTREAMLY helpful! Thank you so much!

I will be averaging Tasks, let’s say for a particular record I have 4 Task in progress and want the average of their progress. In another record I have 7 Tasks and I will average 7 to get the “progress” charted for the record. I can switch to radio buttons, I had setup my checkboxes so only on can be clicked, and if none are clicked it means “Un Started”. Eventually I want to have radio buttons that increment by ten and say 10%, 20%, 30%, or some other way but I want to average it for the X number of tasks for a given record. The X averaged will be the % of the records progress (hopefully charted).


If one record has 5 tasks

Task 1 = “Complete” (100%)

Task 2 = “Un Started” (0%)

Task 3 = “In Progress” (50%)

Task 4 = “Complete” (100%)

Task 5 = “In Progress” (50%)

Total = 300

Divided by 5 = 60% complete. The records tasks are 60% complete. So I am thinking I just need a calculation to get to 60% and then that is the only field that needs to be charted correct?

Chris Johnston

Thanks - loved the solution and clear explanation! Can I suggest a slight modification?

1. Value list
  • change 0, .1, .2, .3, .4, .5, .6, .7, .8, .9, 1
  • to 00, 10, 20, 30, 40, 50, 60, 70, 80, 90, 100
2. Chart - change y-axis data
  • from Task::status
  • to Task::status/100

Robert Jackson

Great idea! Yeah, that would make it much clearer to end users.

Thanks for the input!

Now that I used this incredible help provided by you guys, I have another question. I have a portal in solution that displays progress. This portal lets a user choose a level for a particular area of the current record. The typical breakdown of these areas are Concepts, ExFiles, Homework, Tasks, and Topics. I have represented this in a chart as well (pic). My question is how can create this chart so it is a cumulative representation of the areas in the record? So instead of listing each thing it shows the progress of all Concepts, ExFiles, Homework, Tasks, and Topics in one bar. I represent what I want to accomplish in a fictional pic here. Do have to setup my own calculations to do this or can charting be configured to categorize these areas and calculate everything?

Back to questions