We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

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

Challenge #381: Average Monthly Sales with a Twist

acwysor
6 - Meteoroid

My Solution 

Spoiler
image.png
RolandSchubert
16 - Nebula
16 - Nebula
Spoiler
381.png
Towers
11 - Bolide

enjoyed this one

patrick_digan
17 - Castor
17 - Castor
Spoiler
image.png
MadyeIBT
6 - Meteoroid

What a great way to start the week!

 

Spoiler
 
Capture.PNG

 

Pilsner
10 - Fireball

My Solution:

Spoiler
381.png

Gmajid786
7 - Meteor

A bit more of a unique solution shall we say. I had not encountered the multi row formula tool before so I wanted to do it with the tools I knew. first step was to identify the first non zero value month and use that as a baseline to match against the whole data set. I then converted into date time format as my identifier on where to begin the average calculation. Found out later i could have used the find and replace tool as well to assign an identifier against each month and do it that way as well! 

quinnmb
7 - Meteor

My solution

nSpire
8 - Asteroid
Spoiler
381.png
acarter881
12 - Quasar

Here's my solution. I don't think I'll ever understand how these Weekly Challenge sample solutions are prepared. It boggles my mind how the data type for sales is Double when it's clearly represented as FixedDecimal. My solution is more verbose than it needs to be, but it's because I wanted to match the sample solution.

Spoiler
image.png