We have two apps on different platforms reporting different event properties.
Android: reports a number as an event property
iOS: reports a string which is the “Number Unit” and not just a number
Because of this, we can’t get a property sum for iOS.
We can fix our tracking code for future events, but we need to be able to fix our past events.
I didn’t see anyway to perform any string conversions of any sort, but how can we do this?
Best answer by ning.chang
View original
+10
Hey
Afaik, once the data is ingested in Amplitude in a given datatype, it’s hard to change the underlying value.
Here’s a post for added context on datatypes-
You are correct. There isn’t any string conversion feature that I’m aware of in the platform which could help in your case. If you think this could be a valuable feature depending on your use case, you can submit your idea/requests in here .
Hope this helps!
+3
There is an option in the Taxonomy API to update an event property (see Update an Event property: https://developers.amplitude.com/docs/taxonomy-api on this page), but I have never tried it myself and don’t know if it would even apply or do any good in your case.
There is a workaround if the number of different values your property may get is limited, i.e. ten or fewer. If that’s the case, you could create an Event Segmentation query where each value of the event property is set up as its own event (like this). Then you can use the custom formulas to calculate your sum. It’s not pretty, but it’ll help you in a pinch.
+7
Hi
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.