Hello,
i have a question about charts. I have data with search criteria, for example:
type=home room_number=3
type=office
room_number=2And i want to group this to count how many rows is with specific dimension, in this example type will be 2.
Page 1 / 1
Hi
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
Welcome to the Amplitude Community!
If you don't have an Amplitude account, you can create an Amplitude Starter account for free and enjoy direct access to the Community via SSO. Create an Amplitude account. You can also create a Guest account below!
If you're a current customer, select the domain you use to sign in with Amplitude.
analytics.amplitude.com analytics.eu.amplitude.comor
Welcome to the Amplitude Community!
If you don't have an Amplitude account, you can create an Amplitude Starter account for free and enjoy direct access to the Community via SSO. Create an Amplitude account. Want to sign up as a guest? Create a Community account.
If you're a current customer, select the domain you use to sign in with Amplitude.
analytics.amplitude.com analytics.eu.amplitude.comor
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.