Could you please share any custom day level time scale hierarchy Fortnightly time scale For January (Jan 1 to Jan 15, Jan 16 to Jan 31 ). For Feburary (Feb 1 to Feb 15, Feb 16 to Feb 28 )
@Misbah, @Manjunath
Hey @HarishBabu ,
Could you please clarify what you are after?
Cheers!
I am trying to show the summary level Bi-Monthly instead of Month.
Instead of summing of days values in Month. I am trying to show 1 to 15 days in cycle 1 and 16 to end of month in cycle 2
Could you share best practices for that?
Hello @HarishBabu ,
It looks like you need to dimension your model as week and then create a set of fake time lists:
You could define how to split the months, it looks like you want to look at the number of days in every month and create the fake month breakdown on each of the halves. Then you will need to reconcile everything from day into months using timesum if I recall correctly.
Lastly, you could create actions with saved views so the list would populate automatically based on the items that you have within your time scope.
Hope that was clear.
Could you share anything related to custom time scale day level?
I am working on a use case where I need to display the top 5 lines of a module as individual lines, while grouping all remaining lines under an "Others" category. The module is dimensioned by multiple composite hierarchy lists, along with Time and Version. To achieve this, I need to use the RANK function with the Ranking…
We have an Integration Process in Anaplan CloudWorks created by User X - No WSA (originally Full Access with top-level Selective Access, now changed to Planner Read Only with Selective Access unchanged) and scheduled by User Y - with WSA , who also created the Integration Flow. Internal (Full Access) is enabled within the…
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…