Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
10 replies
Subscribers
7 subscribers
Views
4674 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
want to display data on group by in grid.
Srikanth Reddy P
A Score Level 1
over 7 years ago
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
Discussion posts and replies are publicly visible
Parents
0
harrys
over 7 years ago
I would try to do as much as possible via the database, for performance reasons. A stored function (www.mysqltutorial.org/mysql-stored-function/) might help with the calculations, depending on how you write the view.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
harrys
over 7 years ago
I would try to do as much as possible via the database, for performance reasons. A stored function (www.mysqltutorial.org/mysql-stored-function/) might help with the calculations, depending on how you write the view.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data