Discussion

1
Replies
208
Views
Close popover
Pradeep Gunda (PradeepG7936)
CVS

CVS
US
PradeepG7936 Member since 2015 26 posts
CVS
Posted: April 16, 2015
Last activity: April 22, 2015
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,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Discussion, please write a new Discussion.