Good morning. Sorry for the delay in responding. I wanted to put together a file for you.
Here are some basics: you can set up a chart to show data from "Related Records" (Look at the "Data Source" tab of the char tool). I created a zSystem table and related from this to the Items table using a Cartesian Join.
I used two fields in my example: A "daysDue_c" field and "DaysDue_Text_c" field. The first field here finds the number of days between today and the DueDate of the item. I also created a summary field that does a count of the records. When I then go to sort the chart data (Data Source) by the DaysDue, this summary field does the counting for me.
The 2nd chart is a chart based off ExecuteSQL. As I say in my notes, I prefer this kind of chart. Instead of using a data source of "Related Records", I use "Current Record (delimited Data). This allows me to ignore the layout context and put the chart pretty much anywhere.
I hope this is helpful to get you started. Feel free to ask questions...
(I purposefully didn't explain EVERYTHING. I hope you can pick this apart and learn something more)
DueChart.fmp12.zip 113.5 K
Thanks Jeremy, that's awesome!
I don't understand it yet, but I can see that it works and therefore I should be able to pick it apart when I get a chance to revisit this. I look forward to learning something new out of it.
Just one question - in the home layout, your note says that the SQL layout "...uses one layout and you can change what is shown on the chart by the dropdown." What dropdown are you referring to?
Thanks again. I've finally gotten around to working on this and getting it to work.
I think they key part was making sure to sort the chart in the "Data Source" panel of the Chart Setup box.