identify two keys with highest average popularity ratings ?
That's copy and paste from the current advanced examYou have the dataset, the question, the options, the time.... you got study for that nowBreakdown 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 togetherI 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!
may i know that two keys with highest average popularity ratings ?
which value shall i select
above avg top 2 or
top 2
if you know the answer please provide me details solution i didn't get the question ?
You will have to group by Key, not date, date is only for filteringHave 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
I am getting different results
You are very close, the idea is correctBut 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 valuesMake sure the structure of the date field is correct, be careful to do not mix days with months
I used excel power query for parse the things. I don't things so its wrong . will try in alteryx
Yeah, looks about right, practice using Alteryx later tho, will help understanding how all tool worksBut them looking at the image, are you taking "year" in consideration when filtering the data?
all data are associate with 2022 so i am filtering out on months (month = "March or April "). For more details refer final_data sheet
Discussing any exam questions on the Community is prohibited.
Hi all.
This is a violation of our Certification policies as you are sharing an exam question, the dataset, and possible solution. To protect the integrity of our exams, we have policies in place that need to be followed by everyone in the Community. You will be contacted directly, and this post will be removed by the Community team. Please email Certification@Alteryx.com for more questions.
Noted. Please delete entire post
