Forum Discussion

EaglesTony's avatar
EaglesTony
Post Prodigy
3 years ago

Need help grouping and averaging

hi,   I have a table as follows(btw name is irrevelant I think in this example, so thinking of removing that column):   Project     Name       Point ABC         Test1          30 ABC         Te...
Need Help
Kmcdonald's avatar
Kmcdonald
Helper III
3 years ago

Hi EaglesTony,

 

I got the desired result by a simple group by and using an average aggregation.

 

This is how I started:

 

Then from the "Transform" tab I chose "Group by".

 

 

Then I chose the criteria below.

 

 

Then I got the final result below.