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

Compare records in chart


  • Please log in to reply
6 replies to this topic

#1 appleskrott  newbie

appleskrott
  • Newbies
  • PipPipPipPip
  • 4 posts
  • FM Application:11 Advance
  • Platform:Mac OS X Lion
  • Skill Level:Beginner

Posted 21 February 2012 - 06:22 AM

I have a newbie question. Hoping someone can help me out, or point me in the right direction.

I have a file with two main databases:
1. employees
2. how each employee does in sales per day.

So I have nice lists with a day-to-day sale overview for each employee.

Easy to make a chart for each employee - but I would like to do a graphical comparison as well.

Now I would like to make a layout where I can compare "Employee #1" and "Employee #2" in a "line chart". The chart would have one lines for each employe showing sales over time. The horizontal x-axis would show dates, and the vertical y-axis would show amounts.

The best solution would be a simple finished solution with two drop down menus for choosing two employees - and that this generates a chart. The chart should be look just simple like this:

employee.jpg

Does anyone know how do I make this work?


Thanks,
Appleskrott
  • 0

#2 comment  consultant

comment
  • Members
  • 24,185 posts
  • Time Online: 328d 23h 39m 36s

Posted 21 February 2012 - 07:56 AM

The chart would have one lines for each employe showing sales over time. The horizontal x-axis would show dates, and the vertical y-axis would show amounts.


That sounds simple enough - provided both employees worked on the same days. Otherwise it gets much more complicated.
  • 0

#3 appleskrott  newbie

appleskrott
  • Newbies
  • PipPipPipPip
  • 4 posts
  • FM Application:11 Advance
  • Platform:Mac OS X Lion
  • Skill Level:Beginner

Posted 21 February 2012 - 10:10 AM

That sounds simple enough - provided both employees worked on the same days. Otherwise it gets much more complicated.


Yes, the days are the same. I have tried a couple of different approaches, and my problem is that I can only choose one employee at a time. When I try to choose two employees the graph disappears. How do I solve this?
  • 0

#4 comment  consultant

comment
  • Members
  • 24,185 posts
  • Time Online: 328d 23h 39m 36s

Posted 21 February 2012 - 11:16 AM

Yes, the days are the same.


If you are sure of that, try it this way:

Attached Files


  • 0

#5 appleskrott  newbie

appleskrott
  • Newbies
  • PipPipPipPip
  • 4 posts
  • FM Application:11 Advance
  • Platform:Mac OS X Lion
  • Skill Level:Beginner

Posted 21 February 2012 - 02:42 PM

If you are sure of that, try it this way:


Thank you! That worked perfectly for me!
  • 0

#6 appleskrott  newbie

appleskrott
  • Newbies
  • PipPipPipPip
  • 4 posts
  • FM Application:11 Advance
  • Platform:Mac OS X Lion
  • Skill Level:Beginner

Posted 22 February 2012 - 01:10 AM

One problem though. I seem to get the dates of some records in the wrong order. Starting with the newest date instead of the oldest. How do I fix this? And why does it only happen with a few employees?
  • 0

#7 comment  consultant

comment
  • Members
  • 24,185 posts
  • Time Online: 328d 23h 39m 36s

Posted 22 February 2012 - 04:19 AM

Try sorting the two relationships by Date.


And why does it only happen with a few employees?


Could it be because they backdated their data?
  • 0




FMForum Advertisers