Solved

URL grouping

  • 10 May 2022
  • 1 reply
  • 328 views

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.

icon

Best answer by SheenaGreen 10 May 2022, 21:57

View original

1 reply

Userlevel 4
Badge +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

Reply