PFA the attached data.
I want to generate the counter column marked in red.
if someone could assist that would be great!!
thanks
Solved! Go to Solution.
Hi @sanjit11
If you can explain the logic behind the counter column we will be happy to help you out 🙂
So Basically ,
Each component name has a fixed set of criterias.
For each function name a component with its set of criterias can occur only once.
But as you can see in rows 14 to 19,
For "XYZ" , "Checks" with its criterias "G H and I" has occurred twice
so the counter there is 2
I hope this makes sense 🙂
Hi @sanjit11
Here is how you can do it.
Workflow:
1. Using summarize groupby on Functional Team, Component/Survey Name and Criteria. And get count of avg score (can be any column).
2. Using join tool with key Functional Team, Component/Survey Name, and Criteria to join it back to the data.
Hope this helps : )
@atcodedog05 thts great, thanks a TON!!
Happy to help : ) @sanjit11
Cheers and have a nice day!
User | Count |
---|---|
18 | |
14 | |
13 | |
9 | |
8 |