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

balajilolla2
9 - Comet
Spoiler
Solution Attached
FranciscoR
7 - Meteor

Completed

Spoiler
Solution
Screenshot 2023-07-24 205053.png

 

Rana_Kareem
9 - Comet
Spoiler
Challenge 381.png

jacobcarman
8 - Asteroid
Spoiler
Screenshot 2023-07-24 180736.png

My solution

JoshuaM
8 - Asteroid

Probably didn't need an iterative macro but still a great use case on when to use one (When you have a set of criteria/logic that's met at a certain record in the dataset). Nonetheless, practice makes performance :)

Spoiler
snap.png

snap 2.png 

AkimasaKajitani
17 - Castor
17 - Castor

My solution.

 

Spoiler
wc381.png

rohityaman
8 - Asteroid

Solved!

 

Spoiler
Challenge_381.jpg
AkimasaKajitani
17 - Castor
17 - Castor

My solution using Designer Cloud(Designer Experience)

 

Spoiler
wc381_dc.png

Sebastian_Chaieb2
8 - Asteroid
8 - Asteroid

I see that no one used Running Total tool 🤔

Spoiler
Capture.PNG

Sebastian_Chaieb2
8 - Asteroid
8 - Asteroid

Hi,

I had same issue with uploading screenshot (directly from snipping tool via copy) but if I save it first in the folder as *.jpg and then drag it here it is working. 

Lets try it :)