Re: calculate the maximum number of consecutive months where a field is equal to zero
Thank you for your quick reply. Unfortunately the qvw you included is not what i want to achieve.
What would be great for me is to add a new collumn (let's call it, "Max consecutive month flag") next to the table during load time, not in a chart afterwards, where only for those months that are in the maximun consecutive period the value will be equal to 1 and for all the rest months it would be equal to zero. If a month ihas a zero value in the transactions field but it is not in the maximun consecutive perdiod the value of this flag should be equal to zero, in this example the record for id = "2" and month = "August" (the last record of my example).