This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
No it was a redundant post because I added comments to my original post, and then I thought to just rewrite the original post (making the comment redundant).
I didn't really know how to delete the comment so I wrote something silly
That being said, I just found a way to make it work (cf attached) :)
I sorted on share, and then used a multi-row formula
Basically: if share is sorted descending, then a new respondent means that record has the highest share
The second row after this one is automatically the second highest share
if [respondent_measurement] != [Row-1:respondent_measurement] then 1 elseif [respondent_measurement] = [Row-1:respondent_measurement] AND [Row-1:best_competitor] = 1 then 2 else 0 endif
My only unresolved issue is that I actually wanted to make my multirow formula a text (I wanted "best_competitor" and "second_best_competitor", not 1 and 2). However, I kept getting error messages until I converted them to 0, 1 and 2.