Jump to content

  •  

Photo
MAC | PC

Stumped on charting



  • Please log in to reply
1 reply to this topic

#1 Russell Proctor  newbie

Russell Proctor
  • Newbies
  • PipPip
  • 2 posts
  • LocationLincolnshire, UK
  • FM Application:11 Advance
  • Platform:Mac OS X Leopard
  • Skill Level:Intermediate

Posted 16 July 2014 - 01:47 PM

I have a table that records defects found on production lines.

Record ID: URN
Defect: aDefect (bDefect, cDefect, etc)
Line: 01 (02, 03, etc)
FaultCount: 1 (calculation to set field at 1 to enable counting of fault)

I am trying to produce a stacked chart showing defects on the X-axis with the cumulative no of defect occurrences per line stacked on the Y-axis.

I have created a report grouped by defect:

ADefect
Line 01 3
Line 02. 4
bDefect
Line. 01. 5
Line 02. 3

And a report grouped by line:

Line 01
aDefect. 2
bDefect. 1
Line 02
aDefect. 1
bDefect. 4

To try and produce the graph but I am absolutely stumped.
Can any one point me in the right direction?

Regards,

Russell
  • 0

#2 Lee Smith  I like the v13 layout tools

Lee Smith
  • Staff
  • 10,204 posts
  • FM Application:13 Advance
  • FMGo:iPhone / iPod Touch
  • Platform:Mac OS X Mavericks
  • Skill Level:Expert
  • Membership:TechNet
  • Time Online: 235d 21h 15m 14s

Posted 16 July 2014 - 02:36 PM

 my Russell, welcome to the FM forums,

 

I moved  your topic from"FileMaker 13 General Discussion" to "Charting”, because your profile shows you are using FileMaker Pro 11. Also, we have a topic for  charting.

 

Please read the short description that accompany each topic area.

 

Lee


  • 0





FMForum Advertisers