Issue with Bar Chart Display

Ignition
,
1

Good morning,

I’m using the reporting module, specifically a bar chart. The chart should display one column with six rows of data from a SQL database. However, I’ve noticed that the first column isn’t showing up in the chart. In the image you can see the "3", that what I want included into the chart. From testing I can see that whatever is the first elment selected from the script (in this case Contamination) it will not be added to the bar chart but displayed along the bottom.

image

And this is how it looks in the XML viewer:
image

I’ve already verified that six segment colors are selected, but I’m unsure what else might be causing this issue. The data is logged in the DB correctly and is being displayed in a table correctly also. Any assistance would be greatly appreciated.

Thank you, Ryan

Here is my scrip:

SELECT
    dryline_pn_542645_test_3.contamination AS 'Contamination',
    dryline_pn_542645_test_3.crooked_insertion AS 'Crooked Insertion',
    dryline_pn_542645_test_3.folded_edge AS 'Folded Edge',
    dryline_pn_542645_test_3.cuff_rupture AS 'Cuff Rupture',
    dryline_pn_542645_test_3.connector_insertion AS 'Connector Insertion',
    dryline_pn_542645_test_3.other AS 'Other'
FROM dryline_pn_542645_test_3
WHERE dryline_pn_542645_test_3.time_stamp = (
    SELECT MAX(time_stamp) FROM dryline_pn_542645_test_3
)
2

You've tagged the question as "perspective". Should it be "reporting"? (They have little to do with each other.)

3

I think, You should add another first column in your query that hold the name or number of row. e.g.

SELECT
    ROW_NUMBER() AS 'RowNumber',
    dryline_pn_542645_test_3.contamination AS 'Contamination',
    dryline_pn_542645_test_3.crooked_insertion AS 'Crooked Insertion',
    dryline_pn_542645_test_3.folded_edge AS 'Folded Edge',
    dryline_pn_542645_test_3.cuff_rupture AS 'Cuff Rupture',
    dryline_pn_542645_test_3.connector_insertion AS 'Connector Insertion',
    dryline_pn_542645_test_3.other AS 'Other'
FROM dryline_pn_542645_test_3
WHERE dryline_pn_542645_test_3.time_stamp = (
    SELECT MAX(time_stamp) FROM dryline_pn_542645_test_3
)

Or use script to add the first column.