How to Combine Fields That Have Been Transformed Via Formula | XM Community
Skip to main content

Hi all,

I know this may not be best practice, but I’m tasked with figuring this out all the same.

We are running a test for our satisfaction question within the same survey project - one containing a the question with an 11-point scale (Version A) and one containing the same question question, but with a 5-point scale (Version 😎.

I have figured out how create a formula that transforms Version A’s result into a result that would ‘fit’ within Version B’s 5-point scale. However, this new value is a standalone field that I would like to coalesce with results from Version B.  I know there is a Combine option, but since the formula created field is not Embedded data I cannot use it there.

@JoshB_33 With coalesce only one will be shown at a time. e.g if versionA isn’t available, it will use versionB. So if you have record that have both verA & verB, coalesce might not fit you because I what version will be prioritized?

If you already branch respondent to verA or verB of the survey then you can add them up and treat empty as 0. Like = (verA*5/11) + verB (just my example). 1 of them will be 0 and the result contain only the other one. 

Hope this helps

Leave a Reply


Terms & Conditions