Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Unable to calculate average sales for each employee, considering ONLY the first 3 con.

Singhraani
5 - Atom

 

Determine the average sales for each employee, considering ONLY the first 3 consecutive months beginning from the month they made their first sale of the year.

For example, if an employee did not make any sales in January and February but made some sales in March, the calculation would start from March. Therefore, the average would be computed based on the sales recorded in March, April, and May, even if there were no sales in April or May.

1 REPLY 1
gawa
16 - Nebula
16 - Nebula

hi @Singhraani 

Your question is the exactly same as Weekly Challenge #381. You can refer to solutions posted by others, if you need quick answer.

https://community.alteryx.com/t5/Weekly-Challenges/Challenge-381-Average-Monthly-Sales-with-a-Twist/...

 

Labels
Top Solution Authors