cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Bar Chart for User session query

matthew_k
Contributor

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

 

 

2 REPLIES 2

sebastian_kryst
DynaMight Leader
DynaMight Leader

You have to use group by name

sebastian


jonathan_schull
Dynatrace Advisor
Dynatrace Advisor

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