In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Tool to compare

aparna0208
9 - Comet
‎05-07-2019 12:45 PM

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.

Preview file
9 KB
Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

2 REPLIES 2
Aguisande
15 - Aurora
15 - Aurora
‎05-07-2019 01:01 PM

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

 

 

Reply
0 Likes
aparna0208
9 - Comet
‎05-07-2019 01:05 PM

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

Reply
0 Likes
Fall Release Webinar
Alteryx One Admin Experience
Labels
Top Solution Authors
View All