Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi !
please I need the average score for each problem with distinct response ID
Table :
Response ID | Score | Problem |
373135 | 25% | TV |
373135 | 25% | TV |
373094 | 50% | TV |
373130 | 100% | Mobile |
373160 | 25% | Mobile |
373234 | 100% | TV |
373234 | 100% | TV |
373234 | 100% | Mobile |
373234 | 100% | Mobile |
373234 | 100% | TV |
373234 | 100% | TV |
expected result :
Problem | Average Score |
TV | 58.33% |
Mobile | 75% |
Thanks in advance .
@wanass123 Could you please elaborate on the problem, sorry I am not able to understand your requirement and the expected output.
Thanks sidhiq for your reply , please check I modified the table score with % , data duplicated and I should not delete the duplicate , just I need to count the average problem score for distinct response ID please check table again .
Avg(Aggr(Sum(Score)/Count(Problem),ResponseID,Problem))