I have several machine operations with columns in a live data model
Operation Number, Machine, Start date, End date, Operation duration.
I want to check how much work I have in queue time at a single machine for last 90 days.
Only operations which are yet to be started on a given date contribute to queue time. So for a selected date from a 90 day period.if selected date is less than start date or if start date is blank then return machine and operation duration. Then sum machine duration on a single day and build a line graph with last 90 days on x axis, queue time( total operation duration) on y axis, legend is different machines.
This needs to be run consecutively for every date for past 90 days in a live data model.
