# Charting grouped data

This topic is 2822 days old. Please don't post here. Open a new topic instead.

## Recommended Posts

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

##### Share on other sites

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

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
Humane Development

(780) 849-2171

[email protected]

www.humanedevelopment.com

Why Be Generic?

12-Mar-15

##### Share on other sites

This topic is 2822 days old. Please don't post here. Open a new topic instead.

## Create an account

Register a new account