Bar Chart for User session query

[matthew_k]

I've created naming rules for user actions and hopefully this is the best way to chart this data for payments. My query is successful as a single value which is great, now I need a bar chart for the same count. Can I get an example on how to create a bar chart for this query and any other advice on a better mouse trap?

SELECT COUNT(usersession.userId) AS Users FROM useraction WHERE name = "My Payment Methods" or name = "Pay Now" or name = "Pay Selected Bills" or name = "Pay My Bills" or name = "Make Future Payments"

I need count charted, not response time. Examples are awesome. Thanks

[skrystosik]

You have to use group by name

sebastian

[jonathan_schull · Accepted solution]

Hi Matt,

To get this to display as a Bar Chart you will need to select the useraction name, as well as group the results by something (probably user action name in this case).

Try this query:

SELECT useraction.name AS 'User action name', COUNT(usersession.userId) AS Users FROM useraction WHERE name = "My Payment Methods" or name = "Pay Now" or name = "Pay Selected Bills" or name = "Pay My Bills" or name = "Make Future Payments" GROUP BY useraction.name

Jonathan