Weekly Challenges
Solve the challenge, share your solution and summit the ranks of our Community!Also available in | Français | Português | Español | 日本語
IDEAS WANTED
Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA
Got it all sorted except could not figure out how to get the word "September" in the total row.
I see how now (after reviewing other's total)
SpoilerI suppose I could transpose the row to a column, name it, then transpose back, right?
What did I learn?
- Got better at the datetimeformat function (but more to go)
- Padleft function
- Adding a total to the results (including label for that row)
Process:
- Used padleft and then datetimeparse to convert the time to a usable format
- Calculated number of minutes from sunrise to sunset with datetimediff
- Calculate the change in minutes of daylight from prior to current day (using Multi-Row tool)
- Used datetimeformat to reformat to desired output
- Renamed Sep to Date
- Filtered out null row
- Used Marquee Crew's Add Totals tool to calculate total of Day Length Diff
Revised
Original
What did I learn?
- Got better at the datetimeformat function (but more to go)
- Padleft function
- Adding a total to the results (including label for that row)
Process:
- Used padleft and then datetimeparse to convert the time to a usable format
- Calculated number of minutes from sunrise to sunset with datetimediff
- Calculate the change in minutes of daylight from prior to current day (using Multi-Row tool)
- Used datetimeformat to reformat to desired output
- Renamed Sep to Date
- Filtered out null row
- Used Marquee Crew's Add Totals tool to calculate total of Day Length Diff
Revised
Original
