<p><span style="font-family:calibri;">Version: Mars.1 Release (4.5.1) Build id: 20150924-1200</span></p>
<p> </p>
<p><span style="font-family:calibri;">I am witnessing some strange behavior when I use a running aggregation in a group table. I have created a simple example report that illustrates this behavior.</span></p>
<p> </p>
<p><span style="font-family:calibri;">The example has one Data Source which is a flat file that is bound to a single Data Set. The data have for columns:</span></p>
<p><span style="font-family:calibri;">Time (TimeStamp Type)</span></p>
<p><span style="font-family:calibri;">Event (String Type)</span></p>
<p><span style="font-family:calibri;">Track (Integer Type)</span></p>
<p><span style="font-family:calibri;">SeqNo (Integer Type)</span></p>
<p> </p>
<p><span style="font-family:calibri;">The report uses the Track and SeqNo columns in a table that is grouped on the Track column. </span></p>
<p>The RcountTBL column is a running count aggregate of the SeqNo column that aggregates at the table level.</p>
<p>The RCountGRP column is a running count aggregate of the SeqNo column that aggregates at the track group level.</p>
<p>Each column has a sum aggregate in the group footer cell.</p>
<p> </p>
<p><span style="font-family:calibri;">The resultant table looks like:</span></p>
<p> </p>
<p><span style="font-family:'courier new', courier, monospace;">Track SeqNo RCountTBL RCountGRP</span></p>
<p><span style="font-family:'courier new', courier, monospace;">1000</span></p>
<p><span style="font-family:'courier new', courier, monospace;">1000 1 1 1</span></p>
<p><span style="font-family:'courier new', courier, monospace;">1000 2 2 2</span></p>
<p><span style="font-family:'courier new', courier, monospace;">1000 3 3 3</span></p>
<p><span style="font-family:'courier new', courier, monospace;">1000 4 4 4</span></p>
<p><span style="font-family:'courier new', courier, monospace;">1000 5 5 5</span></p>
<p><span style="font-family:'courier new', courier, monospace;"> 15 15 1</span><span style="font-family:'courier new', courier, monospace;">​</span></p>
<p><span style="font-family:'courier new', courier, monospace;">​1001</span></p>
<p><span style="font-family:'courier new', courier, monospace;"><span style="font-family:'courier new', courier, monospace;">1001 1 6 1</span></span></p>
<p><span style="font-family:'courier new', courier, monospace;"><span style="font-family:'courier new', courier, monospace;">1001 2 7 2</span></span></p>
<p><span style="font-family:'courier new', courier, monospace;"><span style="font-family:'courier new', courier, monospace;">1001 3 8 3</span></span></p>
<p><span style="font-family:'courier new', courier, monospace;"><span style="font-family:'courier new', courier, monospace;">1001 4 9 4 </span></span></p>
<p><span style="font-family:'courier new', courier, monospace;"><span style="font-family:'courier new', courier, monospace;">​1001 5 10 5</span></span></p>
<p><span style="font-family:'courier new', courier, monospace;"><span style="font-family:'courier new', courier, monospace;"> 15</span></span><span style="font-family:'courier new', courier, monospace;"><span style="font-family:'courier new', courier, monospace;"> 40 1</span></span></p>
<p> </p>
<p>Obviously the sum aggregate in the group footer cell is not calculating the correct value. It's returning the running count of the group's first row only. All of the running aggregation, including ones created from the aggregation extension point, exhibits this behavior.</p>
<p> </p>
<p>I've seen bug reports on similar problems with aggregations and group with charts but not tables. Is this a known bug? If so, where can I find information on it? Any known workarounds?</p>
<p> </p>
<p>So my real goal is not to use running count aggregate in such a manner. My goal is to use a custom running aggregation that calculates the difference in the timestamps between rows. It works fine except for this anomaly that exists for all running aggregations.</p>
<p> </p>
<p>Attached is a zip file of the report</p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p><span style="font-family:'courier new', courier, monospace;"><span style="font-family:'courier new', courier, monospace;"> </span></span></p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
