Bar Chart not displaying all values in data table

The rank would be part of the named query.

Alternatively:

  • Add a custom property called rawData
  • Bind rawData to the named query
  • add a propertyChanged script
if event.propertyName == 'rawData':
	rawData = event.source.rawData
	
	headers = list(rawData.getColumnNames())
	data = []
	
	for i in range(rawData.getRowCount()):
		data.append(['{}-{}'.format(i+1, rawData.getValueAt(i,0)), rawData.getValueAt(i,1)])
	
	event.source.data = system.dataset.toDataSet(headers, data)

image