Not a customer? Click the 'Start a free trial' link to begin a 30-day SaaS trial of our product and to join our community.
Existing Cisco AppDynamics customers should click the 'Sign In' button to authenticate to access the community
03-09-2021 05:35 AM - last edited on 03-09-2021 10:13 AM by Ryan.Paredez
Hello,
In my EUM Dashboard, I want to add a pie chart of referrers so it appears as in the attached image
for example, there is more than one value of google referrers.
I want to group referrers so that all referrers that contains google.com are considered one group (google referrer) and all contains (Facebook.com) has value of Facebook and so on .
I don't need to show distribution based on each unique value
How can I do this?
note: the used query as below
SELECT referrer, count(referrer) FROM web_session_records WHERE referrer IS NOT NULL
Thanks
^ Edited by @Ryan.Paredez for readability.
03-09-2021 11:18 PM
Hi Amr
You can use the substring & Index ADQLfunctions.
Something like
SELECT substring(referrer, 9, indexOf(referrer, '/', 3)-9), count(*) FROM web_session_records WHERE referrer IS NOT NULL
Might need to adjust a little bit
Ciao
User | Count |
---|---|
1 | |
1 | |
1 | |
1 | |
1 |
Thank you! Your submission has been received!
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form