Robert Eaton Posted July 30, 2020 Share Posted July 30, 2020 Hey All, I have a calculated column using the following formula DateDiff([One Year Forward From Date Approved],Today()) the data type is timespan of course and it works great on the .dxp file dashboard however I receive this error message when the dashboard is saved onto a server for sharing The following columns are no longer valid: Days Until Renewal Due Because of this I am left with a blank column and a visual which is not correct. Does anyone have any thoughts or solutions I am trying to find a solution not involving Iron Python or any other type of script if possible but will explore that if need be. Thank you Link to comment Share on other sites More sharing options...
Fabian Duerr Posted July 31, 2020 Share Posted July 31, 2020 I'm curious. Which version of Spotfire are you using. I use 7.11 and there is no built-in Today() function. Link to comment Share on other sites More sharing options...
Kirsten Smith (she/her) Posted July 31, 2020 Share Posted July 31, 2020 Did you change the source of your data Did it go from Imported to In-database When dealing with in-db data not all Spotfire functions are available. Link to comment Share on other sites More sharing options...
Robert Eaton Posted August 3, 2020 Author Share Posted August 3, 2020 The formulas are in the database. fabd you have a great point i think the version is the problem. The .dxp file version is 10.4 but on the server it is version 7.11 and this creates the issue. Does anyone know how to fix that problem. I've already asked and am told our server is 10.4 but when the program saves it to the server it becomes 7.11 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now