Click the Start a free trial link to start a 15-day SaaS trial of our product and join our community as a trial user. If you are an existing customer do not start a free trial.
AppDynamics customers and established members should click the sign in button to authenticate.
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
^ Edited by @Ryan.Paredez for readability.
You can use the substring & Index ADQLfunctions.
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