Level 2 - Sprint 1 (User Story 3) - Time Range related

Highlighted
Regular Contributor

Level 2 - Sprint 1 (User Story 3) - Time Range related

Hi

The historic volume for FY19 was imported as below.

Star_0-1586825519385.png

 

and the following SYS13 Account SKU Filter system Module was created. 

 
 
 

Star_0-1586825947341.png

 

I then tested further with by changing the Time Scale to Week.

Star_1-1586826171552.png

and got the following results (changed the pivoting to reflect the below format)

Star_2-1586826255558.png

 

I am intrigue with the results above as we only loaded Historic Volume for FY19 under Time Range.  What is the reason for various weeks under FY20 'tick-marked'?

 

 

 

 

 

 

2 REPLIES 2
Highlighted
Super Contributor

Re: Level 2 - Sprint 1 (User Story 3) - Time Range related

Hi @Star 

 

You have Created "SYS13 Account SKU filter" module to filter out the Volume which is greater than 0 by using Timesum function, so it will filter all combination for all period which having values greater than 0.

 

Screenshot_280.png

 

It doesn't make sense as well if you have added the weekly Time scale.

  • It is same as the original module only difference is you have boolean formatted line item instead of number
  • You can't apply filter if you have time scale because it will be limited to week or year only not dynamic in nature
  • Screenshot_281.png

 

Hope this helps!

Thanks

Akhtar

Highlighted
Master Anaplanner/Community Boss

Re: Level 2 - Sprint 1 (User Story 3) - Time Range related

@Star 

 

TIMESUM should be used only when you have a timescale in the source and None in the TARGET Module. You define what all parameters do you need while using TIMESUM

 

For example

 

TIMESUM(X) - It will aggregate the values for all periods in the source and bring you one consolidated value into target

TIMESUM(-2,X,2) - It brings value for 5 periods (i.e, 2 in the past, one current and 2 in the future ) from source module and consolidate them into one value into target. Here Current period of the Model plays a vital role 

 

For more information please go through TIMESUM on Anapedia.

 

Hope that helps

Misbah