Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Calculating accuracy and average accuracy

Sharathkrishnan
7 - Meteor

in the input file..I want to add a column and calculate accuracy.

 

Accuracy = (sales-validation)/sales

 

Accuracy has to be calculated only when validation value is not equal to zero

 

I want one more column average accuracy which is the average of accuracy column for a particular product and year

 

1 REPLY 1
OllieClarke
15 - Aurora
15 - Aurora

Hey @Sharathkrishnan 

Here's how you can get what you're after:

OllieClarke_0-1623322595072.png

 

In general, the formula tool let's you create new fields based on existing data (or update existing fields)

The summarise tool allows you to aggregate data, and the Join tool lets you combine different data streams to be 'side-by-side'

 

Hope that helps,

 

Ollie

 

Labels