AnsweredAssumed Answered

Charting final summary values

Question asked by mq02 on May 31, 2012
Latest reply on Jun 1, 2012 by philmodjunk

Title

Charting final summary values

Post

Hi everyone,

I'm fairly new to Filemaker so bear with me if there is a relatively obvious/easy solution to this. I am trying to chart the FINAL summary values of a database that uses primarily checkboxes, but I can't figure out how to do it so that it only shows the most recent data (as opposed to the entire set). 

Essentially, I have

Item 1

Item 2

Item 3

...

Item 10

 

All have values of 1 if checkd, and 0 otherwise (I'm assuming it is 0 at least). I have two trailing summaries set for all of them, total and count. I want to do a stacked bar so that it shows the number checked on the bottom and number not checked on the top, and I want to do it so that all ten items are next to each other on the same graph. The farthest I have been able to get is graphing all ten seperately on different charts, with all of the summary values on it (i.e., if I have 8 records of all the items, all 8 summary values are graphed next to each other), but I only need the very last set. Is this possible? Hope that question makes sense (I attachhed an image to clarify). 

 

Thanks in advance. 

untitled.JPG

Outcomes