Kem Azlan

I try to refer on creating the javascript custom progess indicator from this link (https://community.spotfire.com/articles/spotfire/javascript-custom-progress-indicator-for-tibco-spotfire/). Is it possible to add 'Cancel' button into progess indicator to cancel all background task in Spotfire?

Hi Niko, I am trying to get with my IT team whether upgrading TERR is possible or not. Here are the steps that I followed: Hopefully it helps.

Hi Spotfire team, I try to run some TERR script in my Spotfire, but keep getting error as below: The error message: TIBCO Enterprise Runtime for R returned an error The data function 'TEST' could not be executed. Error in .loadNamespaceImpl(package, path, keep.source, partial) : error executing useDynLib for dynamic library 'rlang' from package 'rlang' loaded from C:/Users/mnorazla/DOCUME~1/TERR/X86_64~1/6.0 : Error in library.dynam(chname = chname, package = package, lib.loc = ... : Foreign binary rlang could not be loaded eval(script, envir = .GlobalEnv) eval(script, envir = .GlobalEnv) withCallingHandlers({ DBI::dbConnect(odbc::odbc(), Driver = "SnowflakeDSIIDriver", standardGeneric("dbConnect") .standardGeneric(base::quote("dbConnect"), base::quote(new(structure("standardGeneric", odbc::odbc loadNamespace(pkg) .loadNamespace(package, lib.loc, keep.source, partial, quietly, .loadNamespaceImpl(package, path, keep.source, partial) .createImportEnv(nsinfo, package) loadNamespace(i) .loadNamespace(package, lib.loc, keep.source, partial, quietly, .loadNamespaceImpl(package, path, keep.source, partial) .createImportEnv(nsinfo, package) loadNamespace(i) I try to look on the workaround that has been provided (link: TERR error "Foreign binary rlang could not be loaded", from a CRAN package that has been installed using install.packages() or TERR Tools. (tibco.com)) , but unable to solve the issue. Maybe is there another way to solve the issue? My TERR version is 6.0.1.

Hi David, no worries on above statement. I figured out on the error. The link should be ended with semicolon and single bracket.

Hi David, thanks for the response here. However I tried to set configuration block as above but when I tried to proceed the link, it kept give the error message as below:

Hi Spotfire team, I just want to know whether is there a way to create a Spotfire Dashboard link with a specific tab? For example: http://server_name/spotfire/wp/analysis?file=/folder_name/dashboard_name&[selected tab on dashboard]

Ignore formula above. Here is the correct formula: If(Len(String([REVENUE]))<16,Concatenate('$',If(Len(Split(String([REVENUE]),'.',1))<=3,Split(String([REVENUE]),'.',1),If(Len(Split(String([REVENUE]),'.',1))<=6,Concatenate(Left(Split(String([REVENUE]),'.',1),Len(Split(String([REVENUE]),'.',1)) - 3),',',Right(Split(String([REVENUE]),'.',1),3)),If(Len(Split(String([REVENUE]),'.',1))<=9,Concatenate(Left(Split(String([REVENUE]),'.',1),Len(Split(String([REVENUE]),'.',1)) - 6),',',Mid(Split(String([REVENUE]),'.',1),Len(Split(String([REVENUE]),'.',1)) - 5,3),',',Right(Split(String([REVENUE]),'.',1),3)),If(Len(Split(String([REVENUE]),'.',1))<=12,Concatenate(Left(Split(String([REVENUE]),'.',1),Len(Split(String([REVENUE]),'.',1)) - 9),',',Mid(Split(String([REVENUE]),'.',1),Len(Split(String([REVENUE]),'.',1)) - 8,3),',',Mid(Split(String([REVENUE]),'.',1),Len(Split(String([REVENUE]),'.',1)) - 5,3),',',Right(Split(String([REVENUE]),'.',1),3)),' ')))),'.',Split(String([REVENUE]),'.',2)),'')

Ignore formula above. Here is the correct formula: If(Len(String([REVENUE]))<16,Concatenate('$',If(Len(Split(String([REVENUE]),'.',1))<=3,Split(String([REVENUE]),'.',1),If(Len(Split(String([REVENUE]),'.',1))<=6,Concatenate(left(Split(String([REVENUE]),'.',1),Len(Split(String([REVENUE]),'.',1)) - 3),',',Right(Split(String([REVENUE]),'.',1),3)),If(Len(Split(String([REVENUE]),'.',1))<=9,Concatenate(left(Split(String([REVENUE]),'.',1),Len(Split(String([REVENUE]),'.',1)) - 6),',',Mid(Split(String([REVENUE]),'.',1),2,3),',',Right(Split(String([REVENUE]),'.',1),3)),If(Len(Split(String([REVENUE]),'.',1))<=12,Concatenate(left(Split(String([REVENUE]),'.',1),Len(Split(String([REVENUE]),'.',1)) - 9),',',Mid(Split(String([REVENUE]),'.',1),2,3),',',Mid(Split(String([REVENUE]),'.',1),5,3),',',Right(Split(String([REVENUE]),'.',1),3)),' ')))),'.',Split(String([REVENUE]),'.',2)),'')

Hi @Kirsten Smith (she/her). I might figure out on the formula to convert the column. Here is: If(Len(String([REVENUE]))<16,Concatenate('$',If(Len(Split(String([REVENUE]),'.',1))<=3,Split(String([REVENUE]),'.',1),If(Len(Split(String([REVENUE]),'.',1))<=6,Concatenate(left(Split(String([REVENUE]),'.',1),Len(Split(String([REVENUE]),'.',1)) - 3),',',right(Split(String([REVENUE]),'.',1),3)),If(Len(Split(String([REVENUE]),'.',1))<=9,Concatenate(left(Split(String([REVENUE]),'.',1),Len(Split(String([REVENUE]),'.',1)) - 6),',',Mid(Split(String([REVENUE]),'.',1),3,3),',',right(Split(String([REVENUE]),'.',1),3)),If(Len(Split(String([REVENUE]),'.',1))<=12,Concatenate(left(Split(String([REVENUE]),'.',1),Len(Split(String([REVENUE]),'.',1)) - 9),',',Mid(Split(String([REVENUE]),'.',1),3,3),',',Mid(Split(String([REVENUE]),'.',1),6,3),',',right(Split(String([REVENUE]),'.',1),3)),' ')))),'.',Split(String([REVENUE]),'.',2)),'') Noted that the formula works for only positive value and up to billions.

Hi Kirsten, yes, the column should be in String since I try to append the table later after I manage to convert as above. I tried on Data/Transform data option, but it not worked as expected.

Hi, I just want to check it out whether is there a way to convert some column (in type real) into string with format where (can add $ and thousands separator) using Spotfire expression? I try to avoid using TERR or Python script to convert them since it may impact the engine in server when loading the dashboard.

Thanks, David. Really appreciate your response here.

Thanks @Magnus Rylander. It really helps me.

Hi @Heleen Snelting. Alternatively, maybe I can reuse the code sample in this topic: But, all the color that I have applied into color scheme grouping, will be reset to default color. Is there any IronPython code to create color scheme grouping along with below color gradient settings (Noted that the visualization is in Table): I also hope this helps.

Hi Heleen. Thanks for the reply. I tried to refer on this topic: However, the code above is for creating new color scheme grouping and then add some column into it. But I try to figure out if we need to add new column from the data into color scheme grouping that has been created into Table visualization, but I cannot find the suitable code to configure this. I hope this helps.