Displaying your data as a Calendar view
Problem Statement
Ever wonder how to display your data in a calendar format in Anaplan or simply just want to have a color-coded display based on a specific alert/indicator in a calendar form?
Step-by-step guide
We just need 2 simple lists Day of Week
and Week Number
to start with.
Then we need 2 modules Day of Week Mapping
and Calendar Map
to turn it into a calendar display.
For the Day of Week Mapping
module,
we just need Time
dimension at day level and Line Items
. I've included the screenshot of the Blueprint view for reference.
For the Calendar Map
module, we just need to bring all the lists together (Time, Day of Week, Week Number) with a simple SUM formula.
Publish the calendar map module into a Page and add a bit of formatting, display options, comment display and you will get a pretty useful display of Calendar in Anaplan.
Hope this is useful. Would love to see how you apply this technique. Please share them in the comments below.
Thanks.
Leo
Comments
-
Really amazing visualization!
1 -
This is great, thank you. Just started building something similar a week ago and this helps tie it together.
0 -
Hi Leo,
Thanks for sharing this! This is awesome!
Can you let me know what the Parameter.DOW number in the formula of Weeknumber increment is?
Thanks,
Amy
1 -
@pyrypeura @MJM glad to know this was useful.
With a bit more creativity, some of our colleagues have come up with something like this. Combining with the current date automation
and you will get an automated calendar view adjusted to the current month.Thanks,
Leo
0