identify two keys with highest average popularity ratings ?

[AmolJadhav]

identify two keys with highest average popularity ratings ?

[RaphaelSilva]

That's copy and paste from the current advanced exam
You have the dataset, the question, the options, the time.... you got study for that now
Breakdown each step:
- clean the date field and filter for the range you want
- calculate the average ratings per key next 
- extract the top 2
- take the median mood for those two
- sum two values together

I can tell you the answer is either A or C - Now try to go thru the steps and find out the value :) you can do it!

[AmolJadhav]

may i know that two keys with highest average popularity ratings ?

which value shall i select 

above avg top 2 or 

top 2 

[AmolJadhav]

if you know the answer please provide me details solution i didn't get the question ? 

[RaphaelSilva]

You will have to group by Key, not date, date is only for filtering
Have a look on how the Summary tool works, it will make your life much easier in that exercise, it will be faster than using Excel as well.
Focus on learning how to do all manipulations inside Alteryx, don't use any external tools, you will learn much faster

[AmolJadhav]

I am getting different results

[RaphaelSilva]

You are very close, the idea is correct
But the data was messy at first, I can see you cleaned it outside Alteryx and I cannot see how did you extract the information.
Use Regex the parse the data to make sure you always pulling consistent information, that is valid for both dates (when applying filters) and values
Make sure the structure of the date field is correct, be careful to do not mix days with months

[AmolJadhav]

I used excel power query for parse the things. I don't things so its wrong . will try in alteryx

[RaphaelSilva]

Yeah, looks about right, practice using Alteryx later tho, will help understanding how all tool works
But them looking at the image, are you taking "year" in consideration when filtering the data?

[AmolJadhav]

all data are associate with 2022 so i am filtering out on months (month =  "March or April "). For more details refer final_data sheet