Can I configure a chart to respect a dynamic Time filter?

I have a chart with Time on the x-axis. The saved view used to create the filter has a filter applied to Time. The initial view published on the dashboard respects the filter. However, when I change the selections in my driving filter, the chart is not updated.

See example screenshot below.

Chart with Time.png

Accepted answers

alec_judd

Hi Ryan,

In your saved view, set the formula for the line item that is your filter equal to "TRUE". Then you can create the chart and publish to the dashboard. After the chart is on the dashboard, you can update the filter line item formula to either remove it or change the logic. Any time you have to make the chart dynamic with filters, you just need to make sure the filter is set to TRUE before creating the chart for it to work.

Regards,

Alec

All comments

alec_judd

Hi Ryan,

Regards,

Alec

allison_slaught

Great explanation. While this technique is a great way to reduce maintenance (e.g., you wouldn't need to republish charts most months/quarters), maintenance will be required when extending the model's calendar or time ranges.

For example, if the chart contains 2017 & 2018 when published and you advance the model timescale to include additional year(s), you will need to republish the charts to display/filter the additional year(s).

Best,

Allison

LipChean_Soh

Hi Ryan,

Sometimes i used Numbered List Custom Time for this.

Firstly, we need a module that has a line item with a reference month, eg Ref Time.Current Month with Format: Month. This Ref Time.Current Month could be updated automatically or manually input by Admin.

Then assuming we want to create a dynamic rolling 18 months, let's create a numbered list, i.e. Custom Time with the following properties:

1. Display (Format: Text) = Name(Final Month)

2. Add Mth (Format: Number) = Manually input with 0, 1, 2, .... 17

3. Final Month (Format: Month) = Ref Time.Current Month + Add Mth

Now assuming we have a source module where we want to display the values in a chart (let's call it Sales) with Entity, standard time as lists, and there's a line item called Value, eg Sales.Value

Finally we can create a module for the purpose of the dynamic graph. Assuming it has Entity, Custom Time as list, and there's a line item called Value, eg Graph.Value = Sales.Value[lookup: Custom Time.Final Month].

The benefit of this approach is that you need not publish this chart every time (probably every month if you want a monthly rolling forecast), and the Custom Time will dynamically show the relevant months. The downside of this approach is that you do need to create another module just for this charting purpose, and we might get into a workspace discussion.

Thanks,

LipChean

rob_marshall

Allison,

If you set the dynamic time filters with Time Ranges, you will likely not have to do as much maintenance.

Rob

allison_slaught

@rob_marshall wrote:
Allison,

If you set the dynamic time filters with Time Ranges, you will likely not have to do as much maintenance.

Rob

Thanks Rob! Very exciting benefit that came along with time ranges.

Quick Links

Can you help?

Unanswered questions

How have you from-scratch built lot-level, geo-based Inventory Consumption?
We’re working on modeling inventory consumption at the lot level, accounting for shelf life considerations, since we need visibility into which lots may not consume—both for risk reporting and E&O analysis. Each item may have customers with different shelf life requirements. For example, item A may need 270 days for some…
How to Design Simulation Planning in Anaplan with Multi-Level User Input and Step-by-Step Logging?
Hi Anaplan Community, I'm working on a simulation planning model where users need the flexibility to input pricing adjustments at any level of the product hierarchy, and I’d love your guidance on best practices. 📌 Scenario Overview: We have a 4-level product hierarchy: Brand Category Sub Category SKU (lowest level) The…
ADO File Upload - Semicolon Delimiter
Hi, Based on the regional settings, my default delimiter/separator for CSV files is a Semicolon. In the classic way of uploading a csv file, I was able to select the delimiter. When using ADO, I don't have the option to select a delimiter. Uploading a Semicolon delimited file returns an error, or an upload with only one…