topic Tool to compare in Alteryx Designer Desktop Discussions

Tool to compare

aparna0208 — Thu, 13 Jun 2024 21:41:31 GMT

Hi,

I am trying to see if there is any share increase between two quarters (Q3 and Q4) and if so how much was the increase compared to prior quarter. I have attached sample data with three columns. Could someone help me out with the tools to implement the logic. I tried using different formula and filter tool but didn't get the expected output. Thank you in advance.

Re: Tool to compare

Aguisande — Tue, 07 May 2019 20:01:00 GMT

Hi @aparna0208

A simple formula ([2 Quarters Ago Asset Shares(Q4)] - [3 Quarters Ago Asset Shares(Q3)] ) should do.

If results are positive, amount increased, if negative, the value decreased

Re: Tool to compare

aparna0208 — Tue, 07 May 2019 20:05:12 GMT

Perfect @Aguisande :) This is exactly what I was looking for and it worked. Thank you so much:)