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

ryan_kohn

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.

 

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

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.