Adding Logic to the Calculated Trend
Leveraging the IF Statement
To begin, you decide that you want to define a potential environmental threat. You do so by declaring that your equipment is at risk when the air temperature is over 90 degrees, the humidity is above 85, and the wind speed is below 5 miles per hour. You decide that you would like to measure the frequency in which the cooling fan is operating (off equals a value of 0 and on equals a value of 1) during these "at-risk" periods.
if([Cooling Fan Off/On]=0,if([Humidity]>85,if([Wind Speed]89.9999,[Cooling Fan Off/On],'!NODATA!'),'!NODATA!'),'!NODATA!'),'!NODATA!')
Once entered, you overlay the calculated trend onto the Cooling Fan chart and color it yellow. You can now easily visually differentiate when the "at-risk" conditions are present and the cooling fan is not operating.
if([Cooling Malfunction]=0, if([Gear Temperature]>470,[Gear Temperature],'!NODATA!' ) ,'!NODATA!')
I started the trend calculation and then dragged the new trend line up onto the Cooling Fan trend, setting the bottom scale of the Gear Temperature to 470 and locking it into place with the Cooling Fan's low scale of 0. The end result is a visual overlay of Gear Temperature when at risk directly on top of Cooling Fan when it is not operating. I added a limit with shading to make the trend stand out, and drilled down specifically on the time interval where the machinery was at risk.