When you get that error, are you trying my last line of SQL code?
EasyCharts are great for grabbing tags (with historical logging option enabled) from the tag browse tree and dragging on. They’re not so easy for yours and similar situations. Not saying it can’t be done, but it’s Saturday night here and I’m burning the midnight oil with no access to MS SQL (just MySQL here at home). So let me get back to you on that, someone else may advise further before I can.
It looks like you are creating an easy chart per sql clolumn/tank ref… as per your example anyway. If this is the case then you might consider using a basic chart not an easy chart… they’re a lot more friendly for dragging on, clicking on data source, choosing sql query, then you have free reign to put the “number_column” as “other_name”.