Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAFYI :
The comment box on the start workflow has "since June 2013" but the challenge stated "since July 1, 2013".
The solution attached uses date filter of "DateTimeParse([Date],"%Y-%m-%d")>='2013-07-01'" which is wrong. It should have used JUNE and not JULY.
QUOTE
Identify the number and percentage of tickets since June 2013 which include the following categories of food
UNQUOTE
OUTPUT:
Potential Meal Deal Total %
10964 15497 70.7491772601149
EXPECTED OUTPUT USING RIGHT DATES:
Total Meals Potential Meal Deal %
17977 12751 70.929521054681