question

matt k. avatar image
matt k. asked ·

Bar Chart for User session query

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


dashboarduser actions
10 |2000000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

Jonny S. avatar image
Jonny S. answered ·

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

Share
10 |2000000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

Sebastian K. avatar image
Sebastian K. answered ·

You have to use group by name

sebastian

Share
10 |2000000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

Space Topics

mobile monitoring dotnet synthetic monitoring reports iis chat kubernetes servicenow amazon web services mysql mainframe rest api errors cassandra dashboard oneagent sdk cmc application monitoring openkit smartscape request attributes monitoring developer community user tagging log monitoring services ufo syntheticadvisory activegate ip addresses auto-detection high five award oracle hyperion webserver uem usql iib test automation license web performance monitoring ios news migration management zones index ibm mq web services custom event alerts notifications sso host monitoring knowledge sharing reports browser monitors java hybris sap vmware maintenance window user action naming javascript appmon ai synthetic classic availability tipstricks automation extensions diagnostic tools session replay permissions davis assistant faq documentation problem detection http monitors server easytravel apdex aws-quickstart network docker tags and metadata cloud foundry google cloud platform synthetic monitoring process groups account usability dynatrace saas gui paas openshift key user actions administration user actions postgresql synthetic locations oneagent security Dynatrace Managed user management custom python technologies mongodb openstack user session monitoring continuous delivery citrix configuration alerting NGINX timestamp action naming linux nam installation masking error reporting database mission control jmeter recorder apache mobileapp RUM php threshold azure purepath davis scripting agent aix nodejs android