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

[migueldelval]

Hi Cristoph,

Could you explain a little bit your question? Or attach an example.

Regards

Miguel del Valle

[Anil_Babu_Samineni]

Perhaps this

Count(Interval(Len(Date#(Datefield,'DD.MM.YYYY')),'0','1') FieldName)

[chrisg]

Hi Miguel,

here we go:

number of intervals based on the value 1 and to count all intervals

but i need a solution in the diagram

manx thx

[Anil_Babu_Samineni]

Like this

PFA

[chrisg]

Unfortunately this does not work - sorry

[marcus_sommer]

I'm not sure if a pure gui solution will be possible but with some script-precalculation it might be solvable. Maybe this one within the attachment could be a starting point.

- Marcus

[chrisg]

Many thx - that is helpfull!

[anagharao]

Hi, You could use class as well.

[chrisg]

Many thx - very nice approch