1. 

   elb98rm, Member

   Is it possible to specify different levels of summary for different areas of summary?

   By this I mean:

   Data

   1 | 1 | 1 | 2 | 3
   1 | 1 | 1 | 2 | 3
   1 | 1 | 1 | 2 | 3
   -----------------
   3 | 3 | 3 | 6 | 9

   1 | 1 | 1 | 2 | 3
   1 | 1 | 1 | 2 | 3
   1 | 1 | 1 | 2 | 3
   -----------------
   3 | 3 | 3 | 6 | 9

   1 | 1 | 1 | 2 | 3
   1 | 1 | 1 | 2 | 3
   1 | 1 | 1 | 2 | 3
   -----------------
   3 | 3 | 3 | 6 | 9

   max 1 | max 1 | max 1 | max 2 | max 3

   ^
   The above table shows raw data, sums them for each group, but on the "total" only shows a "max" value.

   i.e - can you specify different summaries (and turn off/on) for each limit_summary_level
   So - sum @ level 2, nothing for level 1, max for level 0 etc etc..

   Cheers
   Rick
2. 

   myDBR Team, Key Master

   Rick,
   there is no separate command for that. You can, however, do it quite easily with some JavaScript by simply removing the results you do not need.

   select 'dbr.hdr', 'A';
   
   select 'dbr.sum', 'B', 'C', 'D', 'E', 'F';
   
   select 'dbr.max', 'B', 'C', 'D', 'E', 'F';
   
   select A, B, C, D, E, F
   
   from mydata
   
   order by A;
   
   select 'dbr.javascript', "$('.summary_level0 div:nth-child(1), .summary_level1 div:nth-child(2)').remove();", 'onload';

   --
   myDBR Team
3. 

   elb98rm, Member

   I'd suggest you add this: it's a good feature to have in future.

   In the interim: this is a great hack! :)
   Thanks

Reply

You must log in to post.