The most recent content from our members.
It would help me SPLIT various utm paramaters and other identifier strings, saving the new parts as number properties. Also, the math functions only work with number values, which has restricted me. Someone else in the community has already suggested this idea in the…
When looking up some user i am getting invalid date time and no events performed by them (but they are interacting in the app)i am using segment sdk in front end (react native) to track the events of the user but is identifying the user on the server side * Has anyone faced this issue before? * Any fixes or debugging tips?…
I am trying to build custom business regions by grouping users by countries in my application. Specifically, I want to group users into the following categories: * If the Country contains "United Kingdom" or "Ireland," then group them as "UKI." * If the Country contains "Switzerland," "Germany," or "Austria," then group…
Is there any way to reference the time of an event in a derived property formula? I am trying to create a derived property that calculates the difference in time between a date in a user property (the users account creation date) and the date of the event being measured. I have gotten it to work using the TODAY() function,…
Hei, How can I create a derived property that evaluates an array event property? I have this clause in my derived property: IF( PROPERTY('array_property', 'event')>10000000, "bigger", "smaller") Will this chek every array element or just the first or the sum? If I segment by the redirved property with total events, will it…
I’m trying to create a derived property that has a value based on event name. If it ends in “Viewed”, it is a “Pageview”, ends in “Clicked” it’s a Click. Otherwise it’s Other. What am I doing wrong in this?
Hello, team. We have a user property (‘Install at’) in the format of date and time. Is it possible to truncate it to the date if we have the Growth plan but no Govern add-on? I am able to create a new user property, but I am not able to add any formula to it. This new property has the status 'Planned. Also in the next…
I’m am looking for some assistance using derived properties to calculate a new flag for Trialing Expired based on a string field and a date stamp field. We have a user property for membershipStatus with a value of “trialing” and date/time field for Trial Expiration Date and Extended Trial Expiration Date formatted like…
Our goal is to understand users' engagement in the first 14 days since sign up (see day per day event usage) through a stickiness chart. We were trying to use a derived property to calculate this date range based on today's date and user's sign up date but we haven't been successful. Any idea on how we can achieve this?…
I’m trying to use the timestamp of an event, as a property. I want to count the distinct days in which an event has been triggered, by doing a distinct count of the day of its timestamp property. Is this possible? This is something that’s easily doable with Mixpanel. I’m able to find Server Upload Time, but that’s in UTC.…
It looks like you're new here. Sign in or register to get started.