Max consecutive aggregation

[peter_25]

 

Hello, I'm new to spotfire. 

I would like to count the six consecutive months that occurred.

I tried using the previus function. But it didn't work.

If you can help me use some function to bring the result.

tks

[David Boot-Olazabal]

Hi Peter,

You can try to achieve the above with a simple data function, that stores the marked months to a document property.
In the attached dxp file (Spotfire version 14.4), you can see how I have done it.

The solution concerning the data function itself, can be found here: https://spotfired.blogspot.com/2015/10/update-doc-property-trigger-ironpython.html.

The attached dxp file also has a working iron python script, but the output only lists the values in string format (but if that what is required, that will do as well). If you prefer the iron python way, you may need to find a way to break the list down into values that can be summarized (one way of doing that, would be to store the values in a new data table, but I guess that defeats the purpose of 'just' summarizing consecutive months).
The iron python script comes from our iron python snippets page: 

 

 

Kind regards,

David

Consecutive months.dxp