I assume you want to stack this based on total time for each instance grouped on the 3 categories. I also assume your sample data above is 3 different fields, Start tiem, stop time and status.
First you will need to get your difference in time.
if your first two items are datetime fields you can use a datediff in a formula to get your total minutes. Called "Minutes" for this example:
datediff("n",{table.starttime},{table.enddtime})
I think for your chart you will need to select a stacked bar chart, on change of probably is Machine # and second the Active/Inactive field. Show value as the formula field
{@Minutes} set to summary as a SUM.
You might have to play around with this a bit depending on your overall design needs but hopefully this will get you on a good track.
IP Logged
