Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Cristoph,
Could you explain a little bit your question? Or attach an example.
Regards
Miguel del Valle
Perhaps this
Count(Interval(Len(Date#(Datefield,'DD.MM.YYYY')),'0','1') FieldName)
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
Like this
PFA
Unfortunately this does not work - sorry
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
Many thx - that is helpfull!
Hi, You could use class as well.
Many thx - very nice approch