I'm not sure if this is intended behavior, but when I have data keys that start with a number, even when that number is in string format, for example:
data["2023"] or data[key] where key = str(system.date.getYear(system.date.now()))
The data is available in the XML preview, but when used on a component everything returns as <N/A>
This is the script I was using, trying to make unique datasets for each year with a key that is the string value of the year:
currentYear = system.date.getYear(system.date.now())
startYear = system.date.getYear(system.date.getDate(2015, 11, 1))
test = range(currentYear, startYear-1, -1)
yearKeys = []
for number in test:
yearKeys.append(str(number))
yearlyData = []
for year in quarterLists:
headers = ["Period", "Actual", "Budget", "Variance", "Variance Pct"]
dataset = system.dataset.toDataSet(headers, year)
yearlyData.append(dataset)
for i in range(len(yearKeys)):
data[yearKeys[i]] = yearlyData[i]
if I change the script to make the "yearKeys" start with a letter it works as expected; all the data shows up in the reporting components, etc. If this is just a limitation in the way that the reporting module allocates data keys, that's fine. I already got the workaround of just starting the key with a letter so no worries either way.
I'm using Ignition version 8.1.24, Reporting Module 6.1.24