Columns not showing up in tables chart

In Insights, I have a query and it runs properly in the query section and shows the data but when I try to display that data in the charts section (using table chart) the column names don’t appear in the dropdown and I get a ‘no data to display’ message.

Any suggestions?