Hi - The below expression works great, however, I need to make it return values only if "SpLimitLowValue" is > 0. Nothing I try is working. Please help!
Count({<ActualNumeric={">0"}>} If(ActualNumeric<SpLimitLowValue, ActualNumeric) or If(ActualNumeric>SpLimitUpperValue, ActualNumeric))
/
(Count({<ActualNumeric={">0"}>} If(ActualNumeric>SpLimitLowValue and ActualNumeric<SpLimitUpperValue, ActualNumeric))+
Count({<ActualNumeric={">0"}>} If(ActualNumeric<SpLimitLowValue, ActualNumeric) or If(ActualNumeric>SpLimitUpperValue, ActualNumeric)))
If you uncheck "Suppress Zero-Values" on the Presentation tab, the line will show up, it's just all zeroes. Without knowing your data or what you're trying to do, I can't say whether they should be zeroes or not.
When the dimension is “location” or “test” or “line” the red line has values. It’s only when I change the dimension to month the red line disappears. All I want is to be able to display the data by month in a line chart without the red line disappearing. The other charts are great, but I don’t know why changing the dimension to month would only affect the red expression. Thank you.
