Hi Alteryx Community,
I have a dataset that based on the product depends on the frequency of when the data comes in. Product A has data come in on a monthly basis and Product B comes in on a quarterly basis. I want to normalize the count of Product B to come in on a monthly basis and to spread out evenly based on the quarter. For example Product B Q1 2021 had a count of 99. I want the 99 count to be spread out 33 for Jan 2021, 33 for Feb 2021, and 33 for March 2021.
How Data Comes in | How I want it | |||||||
Product | Date | Count | Product | Date | Count | |||
Product A | 1/31/2021 | 23 | Product A | 1/31/2021 | 23 | |||
Product A | 2/28/2021 | 43 | Product A | 2/28/2021 | 43 | |||
Product A | 3/31/2021 | 54 | Product A | 3/31/2021 | 54 | |||
Product A | 4/30/2021 | 25 | Product A | 4/30/2021 | 25 | |||
Product A | 5/31/2021 | 243 | Product A | 5/31/2021 | 243 | |||
Product A | 6/30/2021 | 53 | Product A | 6/30/2021 | 53 | |||
Product A | 7/31/2021 | 56 | Product A | 7/31/2021 | 56 | |||
Product A | 8/31/2021 | 7 | Product A | 8/31/2021 | 7 | |||
Product A | 9/30/2021 | 4 | Product A | 9/30/2021 | 4 | |||
Product A | 10/31/2021 | 324 | Product A | 10/31/2021 | 324 | |||
Product A | 11/30/2021 | 345 | Product A | 11/30/2021 | 345 | |||
Product A | 12/21/2021 | 786 | Product A | 12/21/2021 | 786 | |||
Product B | 3/31/2021 | 99 | Product B | 1/31/2021 | 33 | |||
Product B | 6/30/2021 | 300 | Product B | 2/28/2021 | 33 | |||
Product B | 9/30/2021 | 400 | Product B | 3/31/2021 | 33 | |||
Product B | 12/21/2021 | 900 | Product B | 4/30/2021 | 100 | |||
Product B | 5/31/2021 | 100 | ||||||
Product B | 6/30/2021 | 100 | ||||||
Product B | 7/31/2021 | 125 | ||||||
Product B | 8/31/2021 | 125 | ||||||
Product B | 9/30/2021 | 125 | ||||||
Product B | 10/31/2021 | 300 | ||||||
Product B | 11/30/2021 | 300 | ||||||
Product B | 12/21/2021 | 300 |
Solved! Go to Solution.
Hi @cjsnets10
Please see if it is this
Just this row i did not understand, it should become 3 rows of 133 count each right?
Product B | 9/30/2021 | 400 |
If the provided answer helped you to solve the problem/was correct, please accept it as a solution :)
Thanks.