Time Series Chart - Populating Data issue

[ahmedsaeeed907]

I am trying to populate the data in the Time series chart here, I’ve tried the following:

• Using The Generic Tags Like Sine and realistic, It’s Works Properly✅

but here is my issue, i configured my own tag and made it as historian tag to store the data periodically in MySQL, And it works fine here, So once i go to the chart and populate it with this tag history, it doesn’t work, it shows data that has only date and the other column i of values is empty.

<< Note >> When i make a name query for this works fine like in the second picture

so could anyone help me, and what’s the better option to populate the chart generally

[Alejandro_Alaco]

In the XY chart the way it works:

You create a datasource with this structure:

Then you call it on the serie like:

Then you add it to the xAxes like:

so the result if you use multiple datasets would be:

I guess for Time Series Chart is the same process.

[ahmedsaeeed907]

Nothing Works unfortunately

[Alejandro_Alaco]

You using dataset as timestamp...you should with jython separate the date and the rest of the columns...

I use a jithon like:

	# === Same logic, no ordering ===
	if not (hasattr(value, "getColumnNames") and value.getRowCount() > 0):
	    return []
	
	cols = [c.strip() for c in value.getColumnNames()]
	if "Código" not in cols or "Valor" not in cols:
	    return "No se encontraron las columnas 'Código' y 'Valor'"
	
	i_cod, i_val = cols.index("Código"), cols.index("Valor")
	
	def to_float(x):
	    try:    return float(str(x).split()[0])
	    except: return None
	
	series = []
	for r in range(value.getRowCount()):
	    codigo = value.getValueAt(r, i_cod)
	    v = to_float(value.getValueAt(r, i_val))
	    if codigo and v is not None:
	        series.append({
	            "t_stamp": codigo,
	            "process_temp": round(v, 2),
	            "output_temp": None
	        })
	
	return series

Then yo get the date and the value separated like:

Then you can use it on your graph as explained before

[ahmedsaeeed907]

I think using script here, will be kinda complicated
i wanna get the features of the tag history binding
i can do this using named query, but tag history doesn’t work

[pturmel]

Considering the Speed column of your history result is empty, then it must be your history binding. Tag path typos ad/or incorrect datetime boundaries are most likely. You haven't shown that binding configuration/details.

[ahmedsaeeed907]

here it is the binding of the tag history
and the values of that tag in mysql

[ahmedsaeeed907]

here is the tag configs itself

[pturmel]

@ahmedsaeeed907

tag configs itself

No, that is the UDT definition. Show that tag in the UDT instance.

[ahmedsaeeed907]

here it is

[ahmedsaeeed907]

there’s a point here as well, i make mysql as a history provider, and i assigned some tags to it even though it’s empty when i try to pick up a tag from it

[pturmel]

You show a symbolic OPC Item path to Siemens PLC with the IA native server. This can only be a v8.3 beta, and therefore is (was) in the wrong category.

Posting beta topics in the main Ignition category is misleading and irritating to volunteers like me.

[ahmedsaeeed907]

could ypu please lemme understand that to know where is the problem. becusae i am still practicing what i just learned from the course

[robertm]

What’s being said is that apparently you’ve downloaded 8.3 which is Beta only and has a separate support channel. 8 3 is a significant Deviation to 8.1.x, and so we need to know that and it should be posted in the 8.3 section.

[pturmel]

Courses for v8.3 aren't yet released. What made you choose an unreleased Ignition version for this exercise?

There is no way for us to know if your difficultly is caused by you or some nuance of the beta.

[ahmedsaeeed907]

I got it now, sorry about this point it’s my bad though
thanks for your time