Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Normalizing Quarterly Data to Monthly Data

cjsnets10
6 - Meteoroid

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  
         
ProductDateCount   ProductDateCount
Product A1/31/202123   Product A1/31/202123
Product A2/28/202143   Product A2/28/202143
Product A3/31/202154   Product A3/31/202154
Product A4/30/202125   Product A4/30/202125
Product A5/31/2021243   Product A5/31/2021243
Product A6/30/202153   Product A6/30/202153
Product A7/31/202156   Product A7/31/202156
Product A8/31/20217   Product A8/31/20217
Product A9/30/20214   Product A9/30/20214
Product A10/31/2021324   Product A10/31/2021324
Product A11/30/2021345   Product A11/30/2021345
Product A12/21/2021786   Product A12/21/2021786
Product B3/31/202199   Product B1/31/202133
Product B6/30/2021300   Product B2/28/202133
Product B9/30/2021400   Product B3/31/202133
Product B12/21/2021900   Product B4/30/2021100
      Product B5/31/2021100
      Product B6/30/2021100
      Product B7/31/2021125
      Product B8/31/2021125
      Product B9/30/2021125
      Product B10/31/2021300
      Product B11/30/2021300
      Product B12/21/2021300
1 REPLY 1
Felipe_Ribeir0
16 - Nebula

Hi @cjsnets10 

 

Please see if it is this

 

Felipe_Ribeir0_0-1665536069952.png

Just this row i did not understand, it should become 3 rows of 133 count each right?

Product B9/30/2021400

 

If the provided answer helped you to solve the problem/was correct, please accept it as a solution :)

 

Thanks.

Labels