I would suggest you to create a table which will consist of only two columns. UserID and number of submissions. Something like this.
count(SUBMISSIONID) as numbeOfSubmissions
resident <your primary table>
group by UserId;
and than just simply use histogram chart where you will use field numberOfSubmission.
That's it . Hope this will help you.