I have a table that we use to allocate work items to our Engineers, and each of these have a time estimate for how long the work item will take to complete, and these are updated when they start the work item, and also during the build should they hit unexpected issues which delays them.
We also have quotes that go out to prospects, which we break down into initial stages and estimate at this early point how long we think each stage will take (this is before the client has accepted the quote, so these cannot be work items).
We pre-allocate a quote to an Engineer, so if it comes in we know who will work on it; I want to include the quote time estimations into the same chart as the actual work item time allocation.
It would be prohibitively complex to move the quote stage time estimates into the work items table due to the huge amount of automation and follow-up actions that occur when we add work items to that table, so we really need to keep these separate.
Are there any solutions I can use where I can somehow merge these two data sets into a combined view, that I can use for charting both the time allocated to actual work items, and the time estimated for the stages in a quote, into the same chart?