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

Accepted answers

All comments

Akhtar.shahbaz

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

Sai_Bharadwaj_Venati

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?

JaredDolich

@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.

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.

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).

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

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.

Quick Links

Can you help?

Unanswered questions

Dimensionality - Formula Help
I have a Price module where customers are ranked based on their unit prices. I also have a Comparison module, where I want to display the names and unit prices of top-ranked customers for comparison. The model includes a Customers list. In the Comparison module, I want to write formulas to bring in the customer names and…
Can there be a duplication in Process ID's
Can there be a duplication in Process ID's
Using Polaris and Classic
Client has spoke models built in Classic and now considering building Data Hub in Polaris in order to deal with sparsity. On the surface this seem possible but likely a bad idea. Has anyone done anything similar to this? Specifically, what did you have to do to ensure that data was compatible? Any thoughts or suggestions…