Hi, I have an urgent bug in mixpanel. In the latest iOS and Android version, they started sending our subscription plan number property differently e.h. In the old version 1=free, 2=simple. 3=smart and now 0=free, 1=simple, 3=smart This mess up our data ๐ Is there a way to build a new custom property that will map value based on app version for example, for ios ver lower than xx.xx - 1=free, 2=simple, 3=smart In ios ver equal and greate than yy.yy - 0=free, 1=simple, 2=smart And the same with android Can we achieve it somwhoe? Mant thanks!
IFS lets you string together lots of IFs (if X then A, if Y then B). But since you are looking at two things (if version = X and plan# = Y THEN B), you will have lots of entries. And as in my case, since app version and android app version are cast as strings, I can't use ">" I have to explicitly state the conditions. You may prefer to do it the longer way with nested IF statements, so IF X THEN A ELSE IF Y THEN B, etc. Bc then you could use your existing property as the "else" result at the end. You list the old versions and values as the explicit nested IF statements and have the new version just be the ELSE at the very end.
