How to plot contents from dynamic query

[yuwu10112358]

Hello,

I would like to be able to plot data return by a dynamic query, where the schema of the table is not fixed. Ideally I would like to plot one line per column of data, with the legend being the column labels of the data table. Is it possible to set this up using canvas charts (or other charts)?

Thank you in advance!

[rocuinneagain · Accepted solution]

Regular Expressions can be used to define axes instead of a data source column:

 https://code.kx.com/dashboards/canvascharts/#regex-for-data

[dfallon]

Same can be done for Data Grid columns too if needed: https://code.kx.com/insights/1.2/microservices/dashboards/datagrid.html#column