topic Bar Chart for User session query in Dashboarding

Bar Chart for User session query

matthew_k — Wed, 31 Aug 2022 10:02:01 GMT

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

Re: Bar Chart for User session query

skrystosik — Wed, 31 Jul 2019 14:32:33 GMT

You have to use group by name

sebastian

Re: Bar Chart for User session query

jonathan_schull — Wed, 31 Jul 2019 14:39:33 GMT

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