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.
I have a data output with two columns, "group ID" and "work time" - work time is manually filled in and some values are blanks.
What I'd like to do is replace the null values with averages for that group - as an example:
Group | Time
1 | 5
1 | 5
1 | [null]
2 | [null]
2 | 10
I'd like the null value to be replaced with the average of the groups.
Can someone explain how I can achieve this? I've experimented with imputation and multi field formula but am a bit stuck.
I'd use a summarize tool and group by the group field and calculate the average (without nulls) for each group. You can join that back to your data and use a formula like:
I always like to communicate the paradigm for solving a data problem in Alteryx is pretty much "as you think through the problem".
In this case, you want to...
I've attached an example of how this works.
Beat me to it, @MarqueeCrew. :-)
My example is basically the same, but a bit different.