want to display data on group by in grid.

Hi All ,
I have requirement, where i want to display data in below format based on group by (Group By on Vendor, Region , Country, REquest Type , SLA breached) bet ween two particular dates.

Where No. of requests = Count of requests which are complete after deadline
Total No. of request = Count of requests which are complete after deadline + Count of requests which are complete on time
% SLA breached = % of requests which are complete after deadline in total no. of requests.

My challenge here is getting *% SAL Breached and no. of requests and total no. of requests between two dates using query entity.


Can't we achieve this with query entity.

please suggest any other approach.

Thanks

OriginalPostID-254415