Display objects on a line chart only if at least one probe is above threshold

[rlewkowicz]

Hello,

I have found many problem resolutions on this forum and I find it very useful in my everyday work. 
This is my first post so far, because for the first time I couldn't find an answer.
All help is well appreciated!

Imagine following table:
OBJECT|TIME|VALUE
obj1|12:01|1
obj2|12:01|2
obj1|12:02|1
obj2|12:02|2
obj1|12:03|5
obj2|12:03|1

And an input box with variable "LowThreshold", which in this example is going to consist a value of 4.

Now, I want to create a line chart with objects where at least one probe had it's threshold crossed (VALUE > $(LowThreshold).
So the result would be the chart with only obj1(all 3 probes, not only the threshold-crossing one), because probe from 12:03 was above threshold and obj2 didn't had a single one above this value.

So line chart configuration should look like (of course it doesnt work 😞 😞
-TIME
-if(Max(VALUE) > $(LowThreshold), OBJECT,null())

Measure:
-VALUE

Regards,
Rafal 

[bharathadde]

Try this

Dimensions

1.Time 

2.if(VALUE > $(LowThreshold), OBJECT) -- (Check box supress null value)

Measure:
-VALUE