weekly Time set

zbeat
Occasional Contributor

weekly Time set

Hello,please help me.

Start time is the first Monday of each month.

Daily data are expressed by week,How to set the time?

for example:

input:5/1 100,5/2 200,5/3 100,5/4 200,5/5 200・・・6/30 100

want to output :May

            week 1 = 5/3(Mon)~5/9

            week 2 = 5/10~5/16

            week 3 = 5/17~5/23

            week 4 = 5/24~5/30

            week 5 = 5/31~6/6

             June

            week 1 = 6/7(Mon)~6/13            

            week 2 = 6/14~6/20

            week 3 = 6/21~6/27

            week 4 = 6/28~7/4

      

 
 

 

 

3 REPLIES 3
MarkWarren
Expert

Re: weekly Time set

What do you mean when you say the input data is "5/1 100"?
If you have a line item dimensioned by time and data that has separate time values then you can import in to that line item easily. If the format is text as this suggests then you need to fix the source data so that it is in a better format to be consumed easily in to Anaplan.

Can you elaborate on the issue a bit and the data, perhaps with screenshots?

zbeat
Occasional Contributor

Re: weekly Time set

hello.good day!

  the data:

zbeat_4-1621907618685.png

zbeat_5-1621907673585.png

Weekly results are presented separately。

 

 

 

 

abhi1017
Super Contributor

Re: weekly Time set

Hi  @zbeat 

 

Assuming the entire data is received as a bulk.

1. Create a unique list based on the transaction data. 

2. Create a module dimensioned by list created above and lineitems in the excel/source. 

3. Covert/transform the lineitem in date form depicted above into the required week format.

4. Now, use week formatted lineitem to pull the required data from the trasactional module using SUM/LOOKUP functions.

 

Hope it helps.

~ABhi