Time Filter

I would like to filter the module to only show items (daily) for the current month period. Any suggestions on the best way to achieve this? My current Time setup is: Calendar Type: Calendar Months/Quarters/Years The time scale of the module is set to Days.

Accepted answers

All comments

peter_mcanena

You can't limit the module to contain only data for the current month - not at the moment anyway, because time subsets are still not available. But you can filter the view so that only the current month is displayed.

If that's what you want to do then you should add a boolean line item called Current Month? with the formula

MONTH(START()) = MONTH(CURRENTPERIODSTART()) AND YEAR(START()) = YEAR(CURRENTPERIODSTART())

and then add a filter where Current Month? = TRUE. You can then save that view on a dashboard or whatever.

This approach uses the current month as defined under Time Settings. Unfortunately there's no way to pick up today's date from the server; you need to manually update the current period for this to work.

harish_bk

Hi You can have few line items
1) 1st Line Item: Date or Month number
2) 2nd Line Item: use parent function or Month function and derive the month
3) 3rd Line Item: Boolean formatted, if current month is same as second line item then true else false
4) Filter the module based on the 3rd line item
5) Use the other line items to complete your module

May be you can optimize it further but the main catch would be filter by the boolean formatted line item.

Quick Links

Can you help?

Unanswered questions

ANAPLAN XL View
Hi, I need help in pulling a specific view in Anaplan XL. The first grid should display attributes of various projects, while the second grid should present the monthly financial data for these projects. Thanks in advance.
Add list members to a selective access list
Hi, I am working on a solution where the User should only have access to write/edit the list members that they add from an Action on the frontend. This action adds another list member to a selective access list. The problem is, in order to run the action, you need access to the entire list, so you would see all list…
Dimensionality Issue
Hi ALL, In my model, I have Need stored at a 'D3' RS Group level. I need to use this Need in another module at the G5 Location level. I currently have a mapping module where each G5 Location maps to a D3 RS Group. This Module uses D2 Role as dimension. but the line item I've to find the RS Group (Find D3 RS Group = 'FIND…