Charting on non-primary fields

edited 12/09/19 in Smartsheet Basics

I have an Risks, Action Items, Issue, Decision and Questions.. (RAIDQ) sheet. The description is the primary column (field). I have created a few reports using the RAIDQ as the source sheet. I want to create a charts in a dashboards RAIDQ by Priority, RAIDQ by Status, RAIDQ by Category.

I am unable to select any other column (field) in the chart other than the primary column (field).

Any ideas will be helpful !