Easy chart Upper bound Auto, lower bound fixed to 0

Miguel_Gomez · July 31, 2024, 4:32pm

Hello Everyone,

Need your help, I have an easy chart with 6 different pens. In the data base are negative numbers but our customer don't want to see that numbers.

Ignition is not letting me set the lower bound in 0 and the upper in auto.

I have tried to set the lower bound with 0 and bound the upper with scripts and queries but when I'm trying to get the max value of each pen is getting complicated with the queries and they will need more pens in the future.

Is there a way to do this? Fix the Y lower bound in 0 and the Y upper in auto?

Thank you

Transistor · July 31, 2024, 5:48pm

Would you consider doing it in the SQL query by returning zero for negative values?
If so,

What SQL engine are you using.
Show your query. (See https://forum.inductiveautomation.com/t/wiki-how-to-post-code-on-this-forum/77831.)

justinedwards.jle · July 31, 2024, 5:49pm

In the axes dataset, create an axis with the auto range column set to False and the lower bound set to zero. Then, use the name given to that axis in the axis column of the tagpens dataset for all six pens.

Miguel_Gomez · August 26, 2024, 10:05pm

The customer just wanted to not see that negative numbers and not spend too much time fixing that so I just did a condition to not save the negative numbers in the data base, so he will not see negatives from that day and everything was ok.

Thank you all