Max Value in rangesum(above(Mark, 0, rowno()))

[#1]

Hi there,

I am facing this problem to which I seam close to solve but I just can't get it done.

I have this type of data all sorted by timeStamp.:

timeStamp                      Mark            Name

10/11/2011 01:16          +1                    myName

10/11/2011 01:22          +1                    otherName

10/11/2011 01:30          +1                    myName

10/11/2011 01:30          -1                    myName

10/11/2011 08:37          -1                     otherName

10/11/2011 08:37          +1                    myName

10/11/2011 09:09          -1                    myName

10/11/2011 09:09          -1                    myName

When I create a graph with "timeStamp" as a Dimension

and

rangesum(above(sum(Mark), 0, rowno()))   as an expression

I get a graph with accumulated Mark to a each date on the x-axis. (only one name is selected)

But I would like to get only the peak value of accumulated Mark of this graph and with "Name" as the Dimension.

So in this case 2 for myName and 1 for otherName.

The original Data is as above but with lots more Names.

I hope this is clear enough.

many thanks for an answer

[swuehl]

Christian,

in your chart with dimension Name, try

=max(aggr(rangesum(above(sum(Mark), 0, rowno())) ,Name,timeStamp))

as expression.

Hope this helps,

Stefan

[#3 · Accepted solution]

Hi Steve,

thank you for the quick reply.

Unfortunately this results in "No data to display" within the graph.

but it seems to work by omitting the sum

=max(aggr(rangesum(above(Mark, 0, rowno())), Name, %timeStamp))

Christian is now very happy 🙂