SQL data displays 1 on barchart

Question

I am four hours into R programming. When I create a barchart from a SQL Script I get all 1's for the bar values. Here are my steps:

states =dbGetQuery(con, "SELECT state, COUNT(*) FROM leads GROUP BY state")

when I do view(out) it give me this:

I then try and make a table:

state.freq <- table(states$state)
barplot(state.freq)

I end up with this, basically all 1's??

what is the format of states object,i mean array or json..can you cofirm? — Naga Sai A, Jun 18 '16 at 22:40
When I do typeof(states) = "list" When I do typeof(state.freq) = integer — ja11946, Jun 18 '16 at 22:46
states$state will get the response for you as FL LA AK NC and so on and you are making table of states... FL LA AK NC CO HI — Naga Sai A, Jun 18 '16 at 22:53
Change your query as below dbGetQuery(con, "SELECT state FROM leads") — Naga Sai A, Jun 18 '16 at 22:56
and try now ..it should work as expected because state.freq will take care of that count — Naga Sai A, Jun 18 '16 at 22:58
Yes, sir that worked!! Thank you. It's always fun and infuriating to learn a new language. Thanks again. — ja11946, Jun 18 '16 at 23:05
yes.. happy my answer helped you :) ..please mark it as answered and vote if possible :) — Naga Sai A, Jun 18 '16 at 23:06
With just comments I am not sure how to mark this answered and to vote for you. Perhaps if you put your comments into a solution then I can mark it and vote — ja11946, Jun 18 '16 at 23:11
sorry my bad..posted answer now :) ... now you can vote and mark as answered :) — Naga Sai A, Jun 18 '16 at 23:15

score 1 · Accepted Answer · answered Jun 18 '16 at 23:14

1

Change your query as below dbGetQuery(con, "SELECT state FROM leads") and it should work as expected :)

answered Jun 18 '16 at 23:14

Naga Sai A

1 Answers1