This article explains how to reset the date filter to the last 3 months each time the dashboard is opened, using IronPython.
Introduction
This script can be triggered by updating the current datetime into a document property using a simple R script. IronPython script then is attached to this document property to trigger it every time the dashboard opens.
from Spotfire.Dxp.Application.Filters import RangeFilter,ValueRange from Spotfire.Dxp.Data.DataType import Date from System import DateTime from System.Globalization import CultureInfo myPanel = Document.ActivePageReference.FilterPanel # tablegroups is referring to table number 5 and it's date column myFilter = myPanel.TableGroups[5].GetFilter("Date_column") #print myFilter lblFilter = myFilter.FilterReference.As[RangeFilter]() lblFilter.Reset() strMaxDate = lblFilter.ToString().split('=')[2][:-2] max = Date.Formatter.Parse(strMaxDate) min = max.AddDays(-91) #print min lblFilter.ValueRange=ValueRange(min,max)
Recommended Comments
There are no comments to display.