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

Discussion posts and replies are publicly visible

Parents

0 sikhivahans over 7 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 7 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