Summary:
‘first_search_time’ tracks the duration between when the user sign-ups and makes their first search. I can see that in uniques (first screenshot), but I’m unable to get an average of them across all users (second screenshot).
What am I doing wrong?
Best answer by Saish Redkar
View original
+10
Hey
Just under the Properties metric, you’ll get the Average of Property Value option in the measured as dropdown. This will graph the average of the first_search_time property value, similar to this chart
You can also use the PROPAVG(A) formula under the Formula metric to get the same result.
Note: To use this metric, the property value must be an integer. It looks like the value on Feb 5th is captured as “22s” and not “22”. Can you verify this?
Let me know if I have interpreted your use case correctly. Hope this helps.
+8
Hi!
Saish gave come great tips for calculating Average! To add onto Saish’s note in your first screenshot you are sending ‘22s’ as a value for your property. That value would be considered a string because of the ‘s’ at the end of the ‘22’. Therefore, the "Property Sum" metric will not work on that property. The property metrics ("Property Sum", "Property Average", and "Property Histogram") only work for strictly numbers. I'd recommend updating your instrumentation to send only numeric values. Then, you can use all the tips Saish gave!
Let me know if I misunderstood anything.
Best,
Sydney
Hey
Just under the Properties metric, you’ll get the Average of Property Value option in the measured as dropdown. This will graph the average of the first_search_time property value, similar to this chart
You can also use the PROPAVG(A) formula under the Formula metric to get the same result.
Note: To use this metric, the property value must be an integer. It looks like the value on Feb 5th is captured as “22s” and not “22”. Can you verify this?
Let me know if I have interpreted your use case correctly. Hope this helps.
I tried both ways, and I’m still getting 0 as the average (screenshot below).
Are you suggesting the problem is that the event property is a string, and not an integer? Do I need the value to be ‘23’ instead of ‘23s’?
+10
Yup. You have to send the property value as integer since the property computations only work on numeric values.
Yup. You have to send the property value as integer since the property computations only work on numeric values.
That makes sense, thanks!
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 username or e-mail address. We'll send you an e-mail with instructions to reset your password.
