Chart Views: Group by issue

Chart Views: Group by issue

Techies, Brainiacs and Wizards--

I have an app (written under free version) that captures consumer information about creditors. The main form captures the zip, state, dollar value, opinion questions, etc. It appears that the database behind the forms is creating a unique id for each user--which is good--exactly what I want!

So here is the trouble--I want the bar chart/pie chart to group the  total dollar amount by state.  What is happening is the chart is grouping the dollar value by state by id--I've gone into the chart options--using the state only for the group-by, but still.. I get the dollar value by state by id.
(see what happens to Georgia [GA] here: https://creator.zoho.com/paula.ditallo/copy-of-creditor-behavior-survey/#View:Dollar_Value_by_State_Area_Chart)

I don't see where else I can alter this--at least not with the drop down options available when building the view. Does anyone have any suggestions?

Also, I would like to compare a non-dollar value y axis against a non-dollar value x axis...
something line Reasons by State -- but the view creation for the charts  seems to allow only  the dollar value (or the other numeric/int value ) ID for one of the axis points.
-- any advice on this?

Thanks,
--P