Jump to content

Charting grouped data


kiwiora
 Share

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

Link to comment
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

 

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

Link to comment
Share on other sites

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

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.