Challenge #338: Let's Summarize!

[goreca]

My solution for the updated files:

Spoiler

[bajajankit]

The Output shared in the input file is wrong !!! 

Infact, there is a bug during round-off the digits for the columns - average rating and average number of reviews.😀

Output shared in the file :

if you notice, the line item for Jorge Ben should come first and the line item for Ennio as Jorge has more average number of reviews.

My Output : 

Solution Attached

Spoiler

[gaoa]

My solution:

Right([rel_date],4)

Spoiler

[alacoume]

My solution:

[maxbowman]

Spoiler

Didn't know there was a concatenate function in the summarize tool, so here is a terrible way of getting to the answer!

[michael_apau]

[JPPPP]

Solution attached

Spoiler

[mindyzhang99]

My try!

[minhthu1012]

My solution to #338

[PratikPP]

My First Challenge. 

I had a fantastic learning experience and was able to apply the practical knowledge gained to my work.