tried something different for anything within 2 weeks. It seems to work a lot faster then previous thing i tried. here is what i did. Instead of using Job Run End Time i used Job Run Start Time
1. added data item to existing query. Called it 2Weeks and my expression was
_days_between(sysdate(),[Report Layer].[Job Run].[Job Run Start Time])
2. Then added filter to Query and wrote out query like this
[2Weeks] <= 14
It seems to work a lot faster if there is a better way of doing this would like to know.
Did you look at using the "Job Activity Date Range Filter" under Job Activity Filters? This is a OOTB filter. You will have to provide an expression to the dates inorder to get the data for the last 2 weeks.