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
5512 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 8 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
sikhivahans
over 8 years ago
@srikanthreddyp It should be fine as long as the following are taken into consideration:
1. Calculations are simple
2. Calculations are minimal in count
3. Calculations/formatting is a one-time activity as opposed to invoking on the fly(As shown in my text file earlier, you can do it one time or do it every time in the gridTextField)
4. On-demand query as opposed to querying each time when a SAIL component(that has saveInto) is interacted with. (Using load vs with)
At the same time, you can push everything into database provided if
1. Grouping is fixed as opposed to giving options to user to perform group by any field
2. Database view you have created is only for a single report as opposed to the usage of the same database view in the other areas for different purposes. (Simply speaking, limiting the view only for the current report)
On top of the above-mentioned points, consider the following options as well and these will give you much clarity as to which approach you should stick with:
1. Measure the SAIL interface performance
2. Load test(based on the amount of data that you expect down the line) the report
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
sikhivahans
over 8 years ago
@srikanthreddyp It should be fine as long as the following are taken into consideration:
1. Calculations are simple
2. Calculations are minimal in count
3. Calculations/formatting is a one-time activity as opposed to invoking on the fly(As shown in my text file earlier, you can do it one time or do it every time in the gridTextField)
4. On-demand query as opposed to querying each time when a SAIL component(that has saveInto) is interacted with. (Using load vs with)
At the same time, you can push everything into database provided if
1. Grouping is fixed as opposed to giving options to user to perform group by any field
2. Database view you have created is only for a single report as opposed to the usage of the same database view in the other areas for different purposes. (Simply speaking, limiting the view only for the current report)
On top of the above-mentioned points, consider the following options as well and these will give you much clarity as to which approach you should stick with:
1. Measure the SAIL interface performance
2. Load test(based on the amount of data that you expect down the line) the report
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data