How to count the length of the intervall (in diagram)?

[chrisg]

Hello,

i would like to count the length of the intervall and the number of intervals in the diagramm.

(not in the script)

i have a date and a value 0 or 1

ex

1.1.2016  0

2.1.2016  1

3.1.2016  1

4.1.2016  1

5.1.2016  0

6.1.2016  0

7.1.2016  1

8.1.2016  0

9.1.2016  1

10.1.2016  1

11.1.2016  0

12.1.2016  1

...

so i do have:

- 2 intervall of the length of 1

- 1 intervall of the length of 2

- 1 intervall of the length of 3

Any approch?

Many thx

Christoph

[chrisg]

Hi Markus,

i just added

(previous(Value) = 0 or isNull(previous(Value)

so i do not have a problem when the interval starts with the fisrt date.

/Christoph