Discussion

1
Replies
203
Views
PradeepG7936 Member since 2015 26 posts
CVS
Posted: 5 years ago
Last activity: 5 years 6 months ago
Closed

Multiple Levels of aggregate Data

Hello,

I want to create a report to display "Cover details", grouped by "subcase ID" and the "average elapsed time" for each "Flow action" of the subcase (Displayed across columns).

Something like this.

CoverID  CoverName CoverUser SubcaseID      FA1AverageTime   FA2AverageTime
1                 Test1               User1       101               2.34                          1.23   

                                                             102                3.4                           3.7

2                   Test2               User1      103              2.34                         1.23
                                                              104              3.14                          3.7
The solution iseasy if everything is grouped, but the details at the cover(Cover ID, Cover Name etc..) are specific to each Cover not grouped. This is where its getting tricky.

 

I have created a sub report on Subcase, joining it with the History to compute the average time. But when I add this sub report in the Cover main report, the cover details are getting displayed duplicately for each of the sub case instance as shown below.

 

CoverID  CoverName CoverUser SubcaseID    FA1AverageTime       FA2AverageTime
1                 Test1               User1       101               2.34                              1.23   

 1               Test1                User1         102               3.4                              3.7

2                   Test2               User1         103              2.34                             1.23
2                    Test2              User 2          104             3.14                             3.7

 

Any solution?

Pradeep

 

Reporting
Moderation Team has archived post
Share this page LinkedIn