Is there speific business logic around the grouping? i.e. you would always select the text between the 4th and 5th slash?
Yeah so when I pull all the landing pages from the Google Analytics integration I want to be able to segment that traffic etc by category which will always be a set list of around 50.
This will allow the user in the dashboard to just select the given categories they want to see and not show all the categories
Id always want it to be grouped by the first sub folder so
Create a calculated field to extract that part of the URL. I think you'll need to tweak this formula slightly but it should get you 99% of the way there:
MID([URL],FINDNTH([URL],'/',4) + 1,FINDNTH([URL],'/',5) - FINDNTH([URL],'/',4) + 1)
This is trying to pull the text between the 4th and 5th slash.
Check this link to learn more about the string functions: String Functions
This didn't seem to work.
I tried to use the page path dimension from GA instead but that still doesn't pull the data
Using [Page] field ( ga:pagePath actually) this could work:
TRIM( SPLIT( [Page], "/", 3 ) )
This didn't work either the issue is for example my "landing pages" or content drill down have 1000's of URLs and I need to be able to group them in a tableua filter by folder
so /example/new-1 /example/new-2 all pull into the report as urls and I need to then group them like - Example so the list is much smaller and easier to segment the data
The calculation above is a (particular) result of Custom Split:
If '/' as a split delimiter doesn't do the job,
then REGEXP_ calculations would be of help.