I possess a spotfire record which refreshes everyday and this refresh adds a business day (i.y. 6/21, next refresh will add 6/22 and therefore on). I want my filtration system (range filtration system) to continually stage to the latest date by default (i.e. nowadays it will stage to 6/21, down the road 6/22 and therefore on) How do I carry out this?
Scarlet KnightScarlet Dark night
Spotfire Expert Quiz Spotfire Quiz: This Spotfire Expert Quiz contains set of 60 Spotfire Quiz which will help to clear any exam which is designed for Expert. 1) how to go about setting up data source and create information link. I wrote this script to clear out my markings and filters when I am setting new values. This can also be used as a general purpose reset button for your users in.
2 Solutions
Another method is certainly to use a calculated line that generates a filtration system for 'Max Date'. This calculated column will get recalculated every period the data refreshes.
For illustration, if a column is made with this computation:
if (mydateColumn=Max(mydateColumn),'Yes','No')
Just established the filtration system to 'Yes' and when the data refreshes the dashboard will always default to showing the latest date.
user3472649consumer3472649
There are 2 various methods I would do this: Python screenplay turned on with property or home modification or button OR an manifestation in your visualizations.
If you would like to do a Python Software and don't mind users/yourself clicking on a button or currently have Document Attributes that transformation you could induce off of them, then attempt this:
TABLE is definitely a parameter of the table I'm targeting the transformation for. However you can loop through furniture or contact it out specifically in the program code.
Additionally, if you'd choose to have got it simply fixed up on its personal without any scripting you can filter each creation separately with the following expression positioned into your 'Restriction by Reflection' area under the Data Tabs in the visualization's qualities:
DATECOL = Date(DateTimeNow)
Python provides its advantage of addressing the whole document (like newly created visuals) but demands a button to established it off or Javascript to automate it which may lead you to want to use the limit by manifestation choice.
In one of my earlier answers I move through making use of JavaScript to automated button clicking of python scripts: Spotfire Move Automatically. I have got run into a couple problems with the JS not really working in the internet player but it might be cross web site issues with how we set up our internet player machine here. Works excellent in the desktop computer version though for sure.
Area♦
clesiemo3clesiemo3
Not really the solution you're searching for? Search other questions tagged spotfire or question your own query.