how to create rating table

Question

Hi team,  I want to create a new column called "Rating" based on rating from 1 to 5.

Customer Id     total no of ratings  five star ratings       four star ratings     three star ratings    two star ratings    one star ratings

4356                       21                           4                           7                             4                                6                            0

8234                       19                           9                           3                             3                                3                            1

9845                       34                           15                         6                             5                                5                            3

the data looks like this. I want to create a new column with rating.... please help. thank you.

rag329 · Answer

Thanks a lot team @grazitti_sapna @geraldo  I will check and get back here

grazitti_sapna · Answer

@rag329 Following is the solution you can try at your end.

Rating = ([five star ratings]*5+[four star ratings]*4+[three star ratings]*3+[two star ratings]*2+[one star ratings]*1)/[total no of ratings]

geraldo · Answer

@rag329

an idea to start
follow an example workflow

RATING.yxmd