Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I create some point in time charts based on time rather than date .
I have various objects that has 5 stages, (Stage 1,2,3,4 and 5) that is needs to go through and each of these stages have a time stamp when acheived what I want to plot if possible is a stacked bar chart which shows the stages the object has passed through against the timeline
the axis I want are
Object Name
time (e.g current time plus or minus 1 hr)
with the stage values displayed as a stacked bar chart (grouped by object Name)
Hope this makes sense
Sue,
Is your data model ready?
Do you have 5 columns for stagetimes, like: stage1_time, stage2_time, ....
or rather 5 rows for each object with stage_number and time fields?
regards
Darek
The current data is set up as the later so rows for each object with stage_number and time fields
But I am currently working on producing a demo so can easily change this if this is a better way of working
Sue,
here is example for you with both data models.
regards
Darek