Google Analytics and chart

[Anonymous]

Hi all
I am using Google Analytics to get the page views for 3 websites and i have a bar chart chart with the page view.

www.123.com
www.example.com
www.ABC.com

However for one of the website, www.ABC.com, i used the landing page and used conditional column
if "landing page" contain /mysistersite/ then Subdomain else www.ABC.com/mysistersite

How do i get the chart to display:

www.123.com
www.example.com
www.ABC.com
www.ABC.com/mysistersite

I can't show the file due to the data, hope someone can advice.
Thank you.

[v-eachen-msft · Accepted solution]

Hi @Anonymous ,

You could create a new column to get the result.

Column 2 =
VAR _search1 =
    SEARCH ( "/", 'Table'[Column1], 1, 0 )
VAR num1 =
    IF ( _search1 = 0, 0, _search1 - 1 )
VAR _search2 =
    RIGHT ( 'Table'[Column1], LEN ( 'Table'[Column1] ) - num1 - 1 )
VAR _search3 =
    SEARCH ( "/", _search2, 1, 0 )
RETURN
    IF ( _search3 = 0, 'Table'[Column1], LEFT ( 'Table'[Column1], num1 ) )

Here is the result for your reference.