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