Upgrading Server to version 22.1? We’ve enabled the faster AMP engine by default. Read about how these system settings changes might affect you.

We’re aware of an intermittent issue with our My Alteryx login and are actively working to have the issue corrected. If you run into an error when logging in, please try clearing all cookies or accessing the community on a different browser. Thank you for your patience!

Dev Space

Customize and extend the power of Alteryx with SDKs, APIs, custom tools, and more.

Analysis on data

8 - Asteroid

Hi all,

I to analysis this data. Which activity support best in all the column. I'm thinking to use Formula tab but not sure cross tab or Summarize activity can help? I'm confused.


AccountCatergory2NameDecNovOctAverage of all monthsDeviation from the AverageDelta from nov to decDelta from oct to nov
10 GeneralSoftware  351.66    
10 GeneralPassword239.53214207.9    
10 GeneralUK16816171.9    
10 AdminSystems152153155    
10AdminAA 77212    
10 AdminBB282      
22 - Nova
22 - Nova

Hi @AS 


Here is how you can do it. Hope this works for you.




Not sure whats the calculation for Deviation from the Average


Hope this helps : )

8 - Asteroid

Thanks this helps a bit. 😊