Skip to main content
Solved

URL grouping

  • May 10, 2022
  • 1 reply
  • 679 views
W

Hello,

 

i have a question about charts. I have data with search criteria, for example:

type=home room_number=3 

type=office

room_number=2

And i want to group this to count how many rows is with specific dimension, in this example type will be 2.

Best answer by SheenaGreen

Hi @wubek , 

I wonder if derived properties could help here - note you do need access to the Amplitude Govern package to use derived properties.

 

If you use this function: REGEXEXTRACT(type, "[0-9]+")

You could then use this derived property in a chart and look at how many events had this property set to (none) vs. did not have this property set to none.

 

More info on derived properties here: https://help.amplitude.com/hc/en-us/articles/360058731292

View original
Did this topic help you find an answer to your question?

SheenaGreen
Super Helper
Forum|alt.badge.img+8

Hi @wubek , 

I wonder if derived properties could help here - note you do need access to the Amplitude Govern package to use derived properties.

 

If you use this function: REGEXEXTRACT(type, "[0-9]+")

You could then use this derived property in a chart and look at how many events had this property set to (none) vs. did not have this property set to none.

 

More info on derived properties here: https://help.amplitude.com/hc/en-us/articles/360058731292

W
1 person likes this
  • W
    wubek

Reply


Helpful Members this Week

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings