Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this
Dimensions
1.Time
2.if(VALUE > $(LowThreshold), OBJECT) -- (Check box supress null value)
Measure:
-VALUE