How to calculate average per store number

Hello All,

I am having trouble how to calculate the average transit_year on each store number from 100 to 108 from a region area which is south.

I have an output of Stores ranging from 100 to 108. Each store has a # with a particular transit_year value.

If a store number has several transit_year value how do you pull that out and calculate its average and sort it to get the 5 highest average value.

If you can give me some examples, that would be great.

practice question 1.JPG

Workflow

Accepted answers

grazitti_sapna

Hi @mxledesma , if you have read the question carefully it itself says that TransInYear column represents the average number of transactions that customer made over the year, so there is no need of calculating the average transactions. Please check the screenshot for the solution.

Thanks!

All comments

fmvizcaino

Hi @mxledesma ,

You can use the summarize tool to calculate the averages, then use the sort tool to order from higher to lower and lastly the sample tool to filter the first 5 rows.

Best,

Fernando Vizcaino

2020-06-09 How to calculate average per store number.yxmd

grazitti_sapna

Thanks!

mxledesma

Thank you. It does say transinyear represents the average number of transactions. Wow, i should read question carefully. Also, I would looking at help and all the inputs that helped to understand the workflow. It is a learning curve. Again, thanks so much.

Michael ledesma

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703