How to do Dynamic Charting in Anaplan?

Highlighted

How to do Dynamic Charting in Anaplan?

Hello everyone,

I'm currently trying to show dynamic charts on dashboards -> for example whenever I select a month - Jan it should show the last 3 months data i.e only Nov, Dec, Jan data, if I select Mar then it shows Jan, Feb, March data on the dashboard.

I'm able to get this filter on Module but on the charts, I'm not able to get it properly.

Filter logic used:-

Month dimension.PNG

Dashboard i got once i published the chart:-

OT Hours DB.PNG

Dashboard i got once i changed the month from Jan to Dec

OT Hours - 2.PNG

Ideally, the 2nd dashboard should have Oct, Nov, Dec data. When i changed the month to Nov it's showing only Nov data

 

Thanks & Regards,

Sai Bharadwaj 

3 REPLIES 3
Highlighted
Super Contributor

Re: How to do Dynamic Charting in Anaplan?

Hi @Sai_Bharadwaj_Venati 

 

You can try below steps:

1. Create a view which will act as a source for your graph, remember this view should have whole time scale with filter but formula for your final filter should be TRUE.

2. Create the graph and publish the graph to a dashboard

3. Now change the formula for your final filter (in your case "previous 3 month (including current month)" )

 

The graph will sync according to the selection of month.

 

 

Thanks

Akhtar

 

 

 

Highlighted

Re: How to do Dynamic Charting in Anaplan?

Hi @Akhtar.shahbaz , it worked but what i didn't understand was how having a filter true, publishing chart, changing the filter to the formula of the last 3 months worked while my source module i have taken the formula to last 3 months & published dashboard didn't worked? Any idea?

Highlighted
Master Anaplanner/Community Boss

Re: How to do Dynamic Charting in Anaplan?

@Sai_Bharadwaj_Venati 

I really like @Akhtar.shahbaz answer and I'd like to share some additional optimization ideas for you.

Rather than putting all your filters in your charting module, you might consIder using system modules.

This would be in line with the D.I.S.C.O. method and best practices as outlined by @DavidSmith.

 

Start by creating a system module that has the month selector.

Last3Months002.png

 

Next create another system module that only uses time as a dimension. In our case month.

Create two line items, a Boolean, one for months only and set to "TRUE"

Create a second line item for the last 3 months and lookup the current period from the other system module.

The advantage of doing it this way is that you only calculate the filter once and then reuse it in your chart module which you will see in a bit.

Last3Months001.png

Our chart module only contains one line item, the value you want to chart. No filters, lookups, or periods are needed here because we don't want to keep recalculating them for ever month (or product and location if you have those dimensions too).

Last3Months003.png

 

Apply a filter to your chart module from the two line items you created in your system module.

Last3Months004.png

 

Save the view and use this for your chart.

When you add the month selector to your dashboard and change it your graph will dynamically change to reflect the last three months.

 

 

Last3Months005.pngLast3Months006.png


Jared Dolich