Charting grouped data

[kiwiora]

Hi All,

 

Attached in excel is a graph I am trying to re-produce in Filemaker.  Sheet 1 is the pivot table and graph, Sheet 2 is the raw data as exported from FM.

 

I find charting difficult enough in FM, and am not even sure if FM can produce such a graph?  Basically, I'm at a complete loss!

 

Any guidance/assistance would be most appreciated.

 

TIA

 

Rundown of data:

count number of instances grouped (i.e 4 x 1 ; 2 x 2 ; 1 x 3 etc = x in 1-7 )

grouped by author; year

Graph.zip

[Nuos]

Ok so looking at the XL sheet you need a table with the following fields:

1. author name
2. Year
3. Days 1-7   (place a 1 if true;0 if false)
4. Days 8-29 (place a 1 if true;0 if false)
5. Days 30+  (place a 1 if true;0 if false)
6. Data Check [text with calc value = SUM(Days 1-7;Days 8-29;Days 30+)=1
   1. Go to options >> Validation If range is not between 1 to 1 >> error
7. sumDays 1-7 when sorted by author [summary field]
8. sumDays 8-29 when sorted by author [summary field]
9. sumDays 30+ when sorted by author [summary field]
10. sumDays 1-7 when sorted by year [summary field]
11. sumDays 8-29 when sorted by year [summary field]
12. sumDays 30+ when sorted by year [summary field]

Then add record for EVERY data point such that when you summarize you get the same totals

 

Now create layout in list view set to sort on author and year,  Place year under sort row for author.  In the sort sections of the layout add the corresponding field

 

This should re-create your spread sheet.

 

Once we can do this - we ... fiddle ... with the charting to get it to display - but that should be easier to figure once you got the data to display properly.

 

Let me know if I can help

Marcus Swift M.Sc. R.Psych
Lead Programmer
Humane Development

(780) 849-2171

[email protected]

www.humanedevelopment.com

Why Be Generic?

12-Mar-15