Solved

Breakdown and Filter properties using delimiter

  • 1 April 2021
  • 2 replies
  • 44 views

Hi,

 

My properties include a folder path, is there a way to filter or breakdown using delimiter?

 

Thanks

Eran

icon

Best answer by nick 9 April 2021, 18:55

View original

2 replies

Userlevel 2
Badge +2

 

Hi Eran -

So sorry for the delayed reply here. I work at Mixpanel and would love to help you out here. 

You can certainly breakdown a report based on a delimited value using custom properties

You’ll want to choose your event, then in breakdown, choose “Create a Custom Property”

​​​​

From there, you’ll name the new property and use split function. 

If the property were “Folder” and the value were resources/objects/photos/jpg123, you would type “split,” then in the (), hit period, which will pull up a property dropdown, and you would then select “Folder,” and write your split as follows:

 

If you want to use the delimited value repeatedly, make sure to click “Save” rather than “Apply,” and it will then persist across reports.

 

Please let me know if this doesn’t get you what you need, and I’m happy to revise my answer. 

Thanks!

Thank you so much for you answer and sorry for the delayed response.

This is great, exactly what I was looking for.

Problem solved.

THANK YOU!

Reply