At Inspire Europe this week? Join the session "Amplify your Learning with Weekly Challenges" in Little Gallery at 11:15 to solve this challenge in a group learning session!
Not at Inspire unfortunately 😞
My solution
Hi Everyone,
My first weekly challenge here - ran out of time to get on to the bonus round!
I'd never used the mod function before, and learned alot from this article!https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Modulo-mod-Function-Not-just-for-Evens-and-Odds/ta-p/31989
Interesting to see some of the different approaches!
Cheers,
James
Thank you Inspire Europe! It was a fun challenge.
The last bonus bit kept giving me the wrong answer. Finally I realised the problem was that I was sorting my answer as a string, not a number, so getting the wrong results!
Not as fun as being at Inspire...but it'll do! 🙂
Took me a while to interpret the bonus question correctly.
OK, really really glad to have this dataset. Visited London for the first time this past May and while on a riverboat on the Thames, Tower Bridge opened to let through a cruise ship coming up river. A tour guide on our boat was very loud and adamant that this was an incredibly rare event - it only happens a couple dozen times per year, she said. Some simple googling in the moment proved that wasn't true, and maybe we just didn't understand what she was saying was so rare. Glad to see that the data shows it isn't very rare at all!
But this did take me awhile, particularly the tricky interpretation issue with the bonus question. Finally got around to it though.
Wish I was there in London with everyone!
I wish I was at #Inspire19 in London! But at least my new license plates are here:
My solution attached.
Solution attached. Spent a while on the bonus question since I didn't see the logic. I understand the method proposed in the solution, but don't agree that it will give us the most likely time to see a lift.
Nice challenge!
I think that either the bonus answer as provided is not correct, or if that is the desired answer, the bonus question ought to be reworded. The given solution suggests that the 2pm hour on Sundays in August is a good time to see the lift, but really it was just very busy during the 2pm hour on a single August Saturday (2015-08-30) and was never in operation during that hour/month/day combination at any other point in the dataset, thus giving a high “average”. This solution penalizes hour/month/day combinations where the bridge regularly lifts a few times and isn’t accounting for the majority of occasions in which the bridge lifts ZERO times during the 2pm hour on August Sundays.
Consider the 9 on Saturdays in July combination. There are a whopping 24 lifts on 2016-07-30, along with a single lift during that window on two other days. 9 on Saturdays in July has a total of 26 lifts in the dataset, more than twice as many times as the provided solution. The solution suggests that because 12/1 is greater than 26/3, you’re going to be more likely to see the bridge lift on 2pm on August Saturdays. This doesn’t make sense.
A better solution would be to just find the hour month day combination which occurs the most in the dataset (15 on Saturdays in September occurs 29 times).
The most correct solution probably requires summing the number of lifts during each hour/day/month grouping and dividing by a count of the number of Saturdays, Sundays, etc. in each month during 2015 – 2018.
Hello @TonyA
I noticed the same thing; it happens that Saturdays in September have the most frequency of lifts
Got it. Not much trouble on the first 3, but struggled on the Bonus
Found the instructions on the Bonus a little confusing. Would have helped to have said take the average of the hour and day for each month, or something like that
Wish I am in Inspire!
Fun one! Wish I was at Inspire!
My solution:
First one in a long time for me, thanks for the quick little challenge 🙂
Hi! Here my solution 🙂
This is solutions 1-3 from top to bottom.
Here is my solution... with Bonus!
I'll try to be present at the next Inspire
My first weekly challenge - completed the first three parts in the session at Inspire (thanks guys!) and the bonus tonight afterwards.
Found the first three parts straightforward enough, but the bonus was a little odd. My interpretation of the question seems to be a lot different - there were 17 August Sundays between 2015-2018. For the answer to be "12" in hour 14, there'd need to be on average 12 lifts in that hour across the 17 August Sundays, and so 204 in total. I only find 12 in total across the dataset.
That said, my input dataset seems to be different to those others have used. I start off with 3,740 records, whereas I note that another from this thread I downloaded shows 3,948. Have I gone wrong somewhere?
Would be fun to be at Inspire Europe right now.
Thank you sir/ma'am may I have another! 😄
Seth
