How to group similar referrers together?

[Amr.Gamal]

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.  

[Mario.Morelli]

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