Rectangles * Color & Dimension

[Jarvis]

I would like to be able to generate bar chart rectangles and be able to affect their

color & dimension based upon values in two seperate fields.

Field 1 would contain a list of possible work stations

Field 2 would estimate how long something would be in process at each work station.

For example:

If a task takes place in workstation A, color of rectangle = blue.

If a task takes place in workstation B, color of rectangle=red.

If task takes ten minutes to complete, rectangle is 10mm in length.

If task takes twenty minutes to complete, rectangle is 20 mm in length.

Is there a way to make this happen in FM6?

[slstrother]

Go to Database Pros and search on bar charts or progress bars. You can likely find a solution you can modify for your needs.

[Lee Smith]

What you are referring to is sometimes called a timeline. Although the bar chart referred to by slstrother, will get you started, having created a timeline in the past myself, I think you need to know that it is no easy task, just to see a 10 min red bar or a 20 min blue or green or whatever. You have to create lots of calculation fields, in fact, one for each increment of the hour you will be using (i.e. 12 for 5 min increments, 6 for 10 min increments, 4 for 15 min, etc.), and you need to cover the hours form the start of your work day to the end. Also, you will only be able to view about 60 increments of time on screen regular monitor).

Take a look at what I consider the sweetest timeline available and download a demo of Appointments 1.x from http://www.dwdataconcepts.com/

HTH

[Philland]

You should be able to do this with a long "Case" calculation and a bunch of container fields. Each container having a blue or red bar of varying length in it and the case statements written to call one container or another with the calculation result set to be a container.

The smaller the time increments you chart the more containers with different length bars you'll need.

Phil Welsher

[Lee Smith]

You should be able to do this with a long "Case" calculation and a bunch of container fields.

Do you have an example file of this technique?

Lee