Get the Max Value for Consecutive Periods

[#1]

Hello,

I have a table with ids and periods. I need to get the max value for the column consecutive periods.

I created a column named consecutive periods, but now I need to get the max value for the field consecutive periods for each id.

The thing is that I can't use the max function because the column consecutive periods is an expression and it shows me null values.

What I need is to obtain a result like the following:

I should have something like this, hiding the columns periods and consecutive periods using a simple table graphic:

Notes:

I would need this as an expression in my table because the periods are dynamic and they vary according to a slider object.

Thanks for your help!

[MK_QSL]

Like This?

[#3]

I would use that solution if I had fixed periods.

But as I asked before, I have something like this with a slider object that make the periods dynamic:

I attach the file with the slider object.

Thank you!

[#4]

David,

I found 1 more issue in v1, so there is v2.

Please let me know if my demo gives you expected results.

I'am still trying to find more elegant way to calculate your indicator....

regards

Darek

[#5]

You should use AGGR function and get the max.

[#6]

Pushpendra,

of course you are right.

But there is problem of counting number of Consecutve periods before this max.

Please look on my demo. I think, it gives good results, but expression is not very elegant. Maybe you will find better way?

regards

Darek