Jump to content

  •  

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
  • 23,977 posts
  • Time Online: 319d 23h 30m 10s

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
  • 23,977 posts
  • Time Online: 319d 23h 30m 10s

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
  • 23,977 posts
  • Time Online: 319d 23h 30m 10s

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