Is there a way (such as a script) that will allow to save and store values generated in a cross table on a weekly basis?

[Daniel Resendez]

 Purpose is to have a time series and track these values weekly and create graphs. The values are overwritten every time the data refreshes. I do not wish to store the data however on a weekly basis due to the large number of rows. Just wish to store the values outputted weekly in the cross-table calculations when the data is refreshed.

[Fredrik Rosell]

Hello,

This might not be the best way of doing this, but here are some random thoughts on the topic:

• For running operations on a schedule, I would look into using TIBCO Spotfire Automation Services (https://docs.tibco.com/pub/spotfire_server/12.1.1/doc/html/TIB_sfire_autsvcs_UserGuide/autoservices/topics/overview.html)
• Example of how to export visualization data from IronPython script: https://community.spotfire.com/s/article/How-to-Export-Table-Cross-Table-visualization-data-in-csv-file-using-TIBCO-Spotfire-Using-IronPython-Scripting
• Example of database writeback from IronPython script: https://community.spotfire.com/s/article/Using-net-System-Data-SqlClient-module-for-database-writeback-in-TIBCO-Spotfire-using-IronPython
• The Custom DateTime Function (https://community.spotfire.com/s/article/Custom-DateTime-Data-Function-for-TIBCO-Spotfire) could be used to run the script when the analysis is opened. From the description: "The main goal of the Custom DateTime Data Function for TIBCO Spotfire® is to enable the running of IronPython scripts on Analysis Open, Filter and Marking changes".