I made these tables in one sheet and on the same sheet, I would like to display a pie chart which shows how many blog,product and vacancy pages are visited. This means, I want to make a pie chart of below mentioned table (this table is in my mind , not in the sheet)
To make a pie chart, I used the similar formula (mentioned above)
dimension - if((WildMatch(landingPagePath, '*/blog*') or WildMatch(landingPagePath, '*/product*') or WildMatch(landingPagePath, '*/vacancy*')) , landingPagePath)
measure - sum(pageviews)
The result of abpve formula was that, I got pie chart of below mentioned table
Can anyone help me with formula to be put in pie chart dimensions or measure fileds ?