URL grouping

Hello,

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

type=home room_number=3 <br /><br />type=office<br /><br />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.

Find more posts tagged with

Reporting

Accepted answers

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

All comments

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

Quick Links

Unanswered Questions

Error in Amplitude React Native SDK - "Cannot set property 'cookie' of undefined"
Hello! In React-Native mobile project we have error: Amplitude Logger [Error]: Failed to set cookie for key: AMP_TEST. Error: Cannot set property 'cookie' of undefined Error Component Stack: ``` The package version is "@amplitude/analytics-react-native": "1.5.1", Steps to Reproduce: * Initialize Amplitude with our API key…
Send IP on native events for first party tracking
We implemented first party tracking using the basic JS SDK on the browser and pointing the payload to our servers like this: amplitude.init(AMPLITUDE_API_KEY, { serverUrl: serverUrl, autocapture: { attribution: { excludeReferrers: [/domain1\.com$/, /domain2\.com$/], }, formInteractions: false, fileDownloads: false, }, });…
Events for an Android background app
My Android app is primarily a background app. Does Amplitude track events for such an app? Please let me know.
Modifed the Change over time retantion graph
here is the referance graph: https://app.amplitude.com/analytics/demo/chart/new/363tk5og In this graph, retention is currently being calculated based on the next day, but I want to analyze it based on the previous day instead. Example: For July 27, we should compare retention against July 26, not July 28. * So for 1-day…
Landing page analysis data table
Hi everybody! I need your help with a client request: my client is used to analyze landing pages performance with the standard report from GA4 and I need to create something similar in Amplitude. What I already have: * session entries grouped by page URL * purchase event calculated as session totals grouped by page URL and…