Reportit Time Interval Cal for Graph over threshold Value

[sukanta]

Hi,
Need to calculate the total time of a particular graph crossed threshold value..
Any help??

[browniebraun]

Here an example with a threshold of 95%. The result will be in seconds:

Code: Select all

f_rnd(f_num*step*f_dot(maxValue*0.95)/100)

It is always recommend to use a variable instead of a fixed threshold value. That keeps your report configuration flexible and avoids to create superfluous report templates.
At first define a variable returning the percentage of an individual threshold:

Code: Select all

e.g.
Maximum Value = 95
Minimum Value = 50
Default Value = 75
Type = Drop-down
Step = 5

After that you can use the variable in the calculation formula:

Code: Select all

f_rnd(f_num*step*f_dot(maxValue*c1v/100)/100)

Best regards
-Andreas-

[sukanta]

It is not working when the graph has only two Value like 1=UP, 2=DOWN.

Giving 127.50 k as output

[browniebraun]

What did you expect?

Please clone your report, reduce the number of interfaces to a single one, run the report in debug mode via CLI and send me the logfile, please.
I'll have a look at it.

Best regards
-Andreas-