Fetching Count of Status from DB

Question

Hi 
 I have requests available in database and i need to fetch the count of status based upon the data ("Open","In-Progress", "Closed"). So i am using query aggregation function and fetching the count. But now i have fetch the delta value based upon dates mentioned. For Example last week count of open status is 20 and current week open status count is 40 i need to fetch the delta value which is (40-20)=20. So if i use query aggregation function i need to make 2 database calls one for fetching the status for last week and one for present week which has some effect on performance. 
 Can anyone suggest me the best approach to complete this requirement. 
 Thanks in Advance.

mayurm168 · Answer

If you wish to handle all logic single DB call, you can fetch last 2 weeks data from DB at once and than you can manipulate it at Appian level.

yeswanththiyarir · Answer

Hi Krishna, 
You can get all the data using a query rule. and then create another expression rule with the required inputs and functionality to get the results as desired. 
Thanks, 
Yeswanth.