+1Hello, 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 steps I want to calculate the date diff between today and that install date, to know the LT of the user, is it possible?
Best answer by Saish Redkar
Without the derived properties feature ( part of Govern Add-on ), it won’t be easy to split and truncate the user property value to display just the date part.
When you create a new user property, Amplitude will expect you to send that new property with events and move it from the planned phase.
So in absence of derived props, you will have instrument the date property as a new user property.
For your 2nd use case, you’ll again need derived props for calculation using the available date functions as shown in this post
Afaik, there isn’t much that can be done in absence of derived props apart from sending the desired calculations as additional custom user properties.
If your secondary use case is aggregating a set of users who joined between certain dates as isolated segments, then using either glob match / contains or <,> operators on your date time property will help to some extent.
Hope this helps.
+10Without the derived properties feature ( part of Govern Add-on ), it won’t be easy to split and truncate the user property value to display just the date part.
When you create a new user property, Amplitude will expect you to send that new property with events and move it from the planned phase.
So in absence of derived props, you will have instrument the date property as a new user property.
For your 2nd use case, you’ll again need derived props for calculation using the available date functions as shown in this post
Afaik, there isn’t much that can be done in absence of derived props apart from sending the desired calculations as additional custom user properties.
If your secondary use case is aggregating a set of users who joined between certain dates as isolated segments, then using either glob match / contains or <,> operators on your date time property will help to some extent.
Hope this helps.
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 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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
