Question on Time setting Module

Hi,

Trying to create a Line Item "Week # of the Month" that will give me from 1-4 the week number of each month when referencing my "Reference Date"

ex) with Reference Date "2 Jan 19" the outcome will be Week 1 or in formula &"Week"&....

any help on this will do.

Thank you

Community_question_1_88873.PNG

Accepted answers

jasonblinn

I have done this with several staging lines. See if this achieves what you are asking for.

Week Start: Date Formatted, Week Time Scale, What it does: Shows the first date of the period, Formula: Start(),

Month Start:Date Formatted, Month Time Scale, What it does: Shows the first date of the period. Formula: Start()

Month: Time Period Month Formatted, Week Time Scale, What it does: Shoes what month a week is part of, Formula: Parent(Item(TIME))

Reset: Bool Formatted, Week Time Scale, What it does: Checks the first week in each month, Formula: Week Start = Month Start[Lookup: Month]

Week Number: Number Formatted, Week Time Scale, What it Does: Counts the number of weeks and resets each month, Formula: CUMULATE(1, Reset)

You would obviously want to set this up in a SYS module for Time, not use a subsidiary view for Month as well.

Let me know if you have any questions about this method.

Jason

All comments

jasonblinn

I have done this with several staging lines. See if this achieves what you are asking for.

Week Start: Date Formatted, Week Time Scale, What it does: Shows the first date of the period, Formula: Start(),

Month Start:Date Formatted, Month Time Scale, What it does: Shows the first date of the period. Formula: Start()

Month: Time Period Month Formatted, Week Time Scale, What it does: Shoes what month a week is part of, Formula: Parent(Item(TIME))

Reset: Bool Formatted, Week Time Scale, What it does: Checks the first week in each month, Formula: Week Start = Month Start[Lookup: Month]

Week Number: Number Formatted, Week Time Scale, What it Does: Counts the number of weeks and resets each month, Formula: CUMULATE(1, Reset)

You would obviously want to set this up in a SYS module for Time, not use a subsidiary view for Month as well.

Let me know if you have any questions about this method.

Jason

neg177

Hi Jason,

Thank you this was very helpful, but it is not working for the week day number in my Model (The Cumulate Function). Please advice.

Also I started Referencing my Line Items "Day of the Week Number" and "Month Number" to the "Start Day" Line Item. So those line items will be based off of "Start Day", but I would like as a second option to put a Boolean Line Item in that if you check that Boolean Line Item then you can choose a "Reference Date" for the Line Items "Day of the Week Number" and "Month Number" to be based on, how would I do this? If that does not make sense let me know. Screen Shots Attached.

Thank you

Community_Question_2_88978.PNG

Community_Question_3_88978.PNG

neg177

My apologies I added a screen show with a saved view of only Weeks so you can see what I'm talking about.

I want my Line Item "week number" to go from 1,2,3,4....1,2,3,4...ect, and not give me the week of the year. But it is not doing that with the Cumulate Function. Please advice.

Thank you

Community_Question_6_88990.PNG

Community_Question_7_88990.PNG

Quick Links

Can you help?

Unanswered questions

Create a Filter to show all the elements of that level based on selection in hierarchy
Hello Community members, Requirement Details: I have 5 levels of composite hierarchy list (A1, A2, A3, A4, A5). I have published a module in UX, Now the requirement is If user select a list member from A4 level in the context selector or Custom Filter I have to display all the list members under that A4 level. How can I…
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…