Hi everyone,
I'm working on a database view and I'm not getting the outcome I'm looking for. Grant it I'm not sure I'm able to with the 3 tables I'm including in this view, but your quick review and comments are needed.
Expected Outcome: We have applied a cost center to all end users, thus populated the Cost Center table according to our internal requirements. Since all callers will have a cost center associated, we need to pull a report on total incidents submitted per month and charge back to the caller's cost center on the amount of time spent to resolve the tickets.
Sample question to report on: What is the total time spent in resolving tickets for Cost Center name: Corp Serv, code: 123456, over the course of a month and which agent(s) had resolved those tickets?
My ideal report would be a multiple pivot table that has the list of Cost Center names & codes as columns and then the assigned to agents as rows with the time spent based on the information.
A screen shot of my attempted database view is below. When my cost center table is not active (1st screenshot), I'm able to pull some information but the Cost Center is empty. If I make it active (2nd screenshot), I get the error seen on the 3rd screenshot. Even if I make it left join, same result on an empty Cost Center field. I think I just need fresh and more experienced eyes on correcting my mistakes.
Screenshot #1
Screenshot #2
Screenshot #3
Appreciate your review and replies.
Thank you.
