Jump to content

  •  

UPGRADE DEADLINE - SEPTEMBER 26, 2014!
FileMaker Inc. has a deadline for users of version 10,11, 12 as Individual box or volume licenses (with expired maintenance).
If you don't renew your maintenance and upgrade to FMP 13 you will no longer be eligible to upgrade, at the discount pricing.

Volume Licensing upgrade pricing for FileMaker Pro 13, FileMaker Pro 13 Advanced and FileMaker Server 13 will be discontinued.
Individual upgrade pricing for FileMaker Pro 13 and FileMaker Pro 13 Advanced will increase after September 26, 2014.
As of 27-September-2014, FileMaker 10 products will no longer be available for purchase or support.

http://help.filemaker.com/app/answers/detail/a_id/13865


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,136 posts
  • FM Application:13 Advance
  • FMGo:iPhone / iPod Touch
  • Platform:Mac OS X Mavericks
  • Skill Level:Expert
  • Membership:TechNet
  • Time Online: 228d 13h 6m 47s

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