Ah, the old ‘turn a table on its side’ problem. The only ways I know to do this are in a stored procedure or a python script. Doing it in python, you’d create a dataset dynamic property, and then respond to its component’s propertyChange event, generating a new database for your chart every time the source dataset changed.
To get you started:
if event.propertyName=="RawDataset":
ds = fpmi.db.toPyDataSet(event.newValue)
values = []
x=0
for yVal in ds[0]:
values.append([x, yVal])
x += 1
chart = event.source.getComponent("Chart")
chart.data = fpmi.db.toDataSet(["X","Y"], values)