Tuning Performance Task with Performance Ratings Subject Areas for Performance!
Summary
I've joined the subject areas together and it's VERY slowContent
I've created an analysis where I'm trying to derive the current in progress performance task from the Performance Task Status Real TIme and put it alongside the overall manager rating from the Performance Rating real time subject areas. Unfortunately, the analysis can take a VERY long time to run. Our users want lots of filtering options so there is quite a bit of prompted filtering available to them but even the bare minimum seems to slow it down drastically.
One time, I filtered the data to Canada and the US and the manage sessions screen believed it was still running after 2.5 hours of waiting. I tried again today and after 11 minutes and 38 seconds, I gave up and went back to looking at the analysis which cancelled the request in the log. (screenshot attached) I'm trying to understand why my analysis is so slow.