I just found that a few properties in our lexicon are denoted as strings instead of numbers. When looking back, I realized we were logging this data with a “$” in front of the float value. We would like to be able to do numerical comparisons and calculations with this data, and while it is easy to fix the incoming values, I could not think of a good method to remove the $ from the legacy data. I was considering making a lookup table converting strings with a $ to the same number (without a $), but it seemed tedious and would require me creating an entirely new property instead of updating the currently used one. Does anyone have any advise? Thank you in advance.
Login to the community
Login with Mixpanel Account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.