David Boot-Olazabal

Hi Prashant,
I've found it. This is used to search the filter hierarchy on specific levels: https://docs.tibco.com/pub/sfire-analyst/14.4.0/doc/html/en-US/TIB_sfire_client/client/topics/en-US/search_in_hierarchy_filters.html (see the bottom part of the page).
When you want to search for let's say Q1, you can do that for the specific Quarter level, but also on the All level (if you have that box checked in the hierarchy properties). It is meant to search through large hierarchies in an easier way.
But it doesn't do 'anything' related to filters directly.
Kind regards,
David

Hi Sophia,
Some of the settings, like font and font size for the axis can be altered via the menu Visualizations -> Canvas Styling -> Edit custom themes:

The other settings are hard-coded into the mod. Any changes to that, would require changes in the source code. As it is available on our github site: https://github.com/spotfiresoftware/spotfire-mod-area, you can access it, make a fork and perform the changes you need.
Kind regards,
David
 

Hi,
Yes, this is possible.
You can give the active tab a different color then the rest. You do this via Visualizations->Canvas Styling->Edit custom theme...
Via this window, on the Details tab, you can set the color (background as well as text) for the active page tab in submenu Page Navigation area.
In the below picture, you can see that I have changed the background color to purple and the text to light green. :

But beware of the text coloring, as this affects all tabs:

Kind regards,
David

Hi Prashant,
You may be able to achieve the same using iron python script (depending on what you want to hide):
Kind regards,
David

Hi Arunabha,
The Axis Binding property is used to bind an expression to the axis. You can find more information via our API documentation:
https://docs.tibco.com/pub/doc_remote/sfire-analyst/14.3.0/doc/api/TIB_sfire-analyst_api/html/P_Spotfire_Dxp_Application_Visuals_Axis_Binding.htm
Kind regards,
David

Hi Kem,
Yes there is. Please have a look at this community article about configuration blocks:
Look for the part 'URL parameter' where it is explained how you can define the tab to be opened. Also, as I found some differences between browsers when it comes to encoding. Firefox, Edge and Chrome worked perfectly with the %22 encoding for " (in the link: https://spotfire-next.cloud.tibco.com/spotfire/wp/analysis?file=/Samples/Introduction to Spotfire&configurationBlock=SetPage(pageTitle="TabName"));.
Kind regards,
David

Hi Funny Cat,
There is the out of the box export functionality in Spotfire, concerning tables and crosstabs. This functionality will not work for other visualizations, like bar charts, line charts, etc. Those can be exported as image (.bmp) after which you may be able to add them in Excel. However, that will not be an option yet, given your Spotfire version. There are iron python code snippets available to export a data table to excel: from client only or from web player
If your need is to export other visualizations, what you can do, is have a look at a similar question here. It is based on Python code, rather than Iron Python. Although it is about exporting visualizations to PowerPoint, you may be able to use the same approach for exports to Excel, using a different Python library.
Kind regards,
David

Hi Prashant,
I don't think this is possible, certainly not with the out of the box functionality that lets you style individual rows only (instead of cells which you are looking for).
I also didn't have luck with custom expressions for the summation of the columns, as the Grand Total is derived automatically based on the cell values (you can't create your own Grand Total and insert it). Last option I tried, was to add an empty row below and tried to add the custom expression in there as well. That also failed, since the extra row became part of the cell values 'block'.
So, all things considered, I would advise you to create an enhancement request which can style cell values of a grand total individually, via our ideas portal https://ideas.spotfire.com/.
Kind regards,
David

Hi,
You can add the expression in the cross table as you mentioned. And you can also use the OVER functions to achieve this in a calculated column.
Consider the below screenshot, where I have copied a small part of your dataset. I have used the OVER function in the crosstab columns of Total Milestones and Actual Time to calculate the Revenue per Project:

The expression used is this one:
<[Data Table].[Project] NEST Sum([Data Table].[Total Milestones]) OVER ([Project]) NEST [Data Table].[Hour rate] NEST Sum([Data Table].[Actual Time]) OVER ([Project])>.
The Revenue column is a calculated column, based upon your formula.
Kind regards,
David

Hi Frank,
Annoying indeed. I would advise you to create a support ticket via https://support.tibco.com.
As it is a problem in the software, this is the best and quickest way to address the issue.
Kind regards,
David

Hi Navaneetha,
Without knowing any further context, I can see that the error message provided, speaks of: "Failed to execute query: [simba][bigQueryJDBCDriver](100032) Error executing query job. Message: 400 Bad Request".
So, somewhere in the provided SQL statement, there is something off. Not sure where this exactly is, but the provided query is invalid:
{ "code": 400, "errors": [ { "domain": "global", "location": "q", "locationType": "parameter", "message": "Syntax error: Unexpected ")" at [1:2620]", "reason": "invalidQuery" : "status": "INVALID_ARGUMENT" } (HRESULT: 80131509) If possible, I would advise to run the same query directly on the database, so it may be easier to find out where the root cause lies for the invalid query.
Kind regards,
David

Hi Vincent,
Please have a look at an earlier topic about this:
It may give you the solution you're looking for, as it discusses the changed settings in Chrome and a way to fix that.
Kind regards,
David

Hi Jlary,
Color coding based on expressions is possible in Spotfire.
Having said that, I'm not sure if I follow the proposed logic and the color coding in the screenshot.
The first condition is "if the Evol N N-1% column is > 0 then I color in red and green for the rest, IF call classification = CARENCE". To me, that means that whenever the classification is CARENCE and the Evol N N-1% is greater than 0, the color should be red. Else it should be green. This matches the coding, since the Evol N N-1% is smaller than 0.
But the second condition "if the Evol N N-1% column is > 0 then I color in green and red for the rest, IF call classification = EXTREME EMERGENCE ", I would have expected the same green color, since the Evol N N-1% is greater than 0 and the classification is EXTREME EMERGENCE (which matches the condition and the color should be green).
Is there a typo in one of the 2 conditions or your example perhaps?
In any case, no matter how your conditions would look like, I would advise to create a calculated column that looks like this:
CASE  WHEN ([Classification]="CARENCE") AND ([Evol N N-1%]>0) THEN "RED"
WHEN ([Classification]="EXTREME URGENCE") AND ([Evol N N-1%]>0) THEN "RED"
ELSE "GREEN" END
You can use this column to color code the two Evol columns, using the next set up:

Kind regards,
David

Hi James,
I have attached a dxp example, with two trellis options (Spotfire 14.0, so I hope you can open it). I have added the capacity as part of the initial data table, so you can easily set up a threshold line. The data model looks like this:

And the end result looks like this (from the first trellis option):

I hope this is what you were looking for.
Kind regards,
David
Trellis with Team capacity.dxp

Hi Arenti,
Please have a look at this code. It might be the solution that you are looking for.
Kind regards,
David

Hi Dagfinn,
I have downloaded your dxp once more, and this time I could see the script. I now see what you did (and what I missed in my script).
The solution I proposed in my earlier responses, can still be used in your script. Just copy the parts for each of the pages and point them to the name of the page. That synchronizes the slider value on all pages and zooms each map equally in or out.
I have attached the dxp with the changes in the script.
Kind regards,
David
Mapmarkersize v05042024.dxp

Hi Francisco,
Right, I can reproduce the error message with the initial CASE statement.
What we need to take into account, is the way we combine different types of data format (so real and string). It's always kind of tricky with date calculations.
I have created a working CASE statement, although you have to replace the StartDate and EndDate variables with your own Date variables of course:
CASE
WHEN [EndDate] IS NULL THEN NULL
WHEN Today()>[StartDate] THEN DateDiff('day',Today(),[EndDate])
WHEN [EndDate] > [StartDate] THEN DateDiff('day',[EndDate], [StartDate])
ELSE 0 END
As you can see, the outcomes of each and every rule is either NULL or a number and that is something the Spotfire engine is accepting.
Kind regards,
David

Hi Martin,
You can find a date picker here: https://spotfired.blogspot.com/2014/07/two-popup-calendars-start-and-end-date.html.
The dates that you have set, has to be stored in a document property. And that document property can then be used as a trigger for the on-demand query.
In the below example (not on a date field), you can see how to set a property as input for an on-demand query:


Kind regards,
David
 

Hi Tyler,
I was able to make it work, although the TERR code seems a bit outdated.
My initial mistake was that I did not create the export sub folder in the path. Have you configured the path and/or does the export sub folder exists?
The error shown above, might indicate you have to install the rgeos package as well. You may try that one as well.
Also, would it be possible to share your dxp file, so we can have a look at it? The included demo dxp in the Exchange package, does still work for us. So we're interested to see why your dxp is failing.
Kind regards,
David

Hi Kumud,
You can extent your data limiting formula with another if statement, where you 'capture' NULL values in the [Date of Balance].
Not sure what you want to do when the Data of Balance is NULL, but that should be handled in that particular if statement (such as a default date or skip the entire part).
Kind regards,
David

Hi Jon,
Sorry for the confusion. I have found a working solution, using iron python.
This is also referred in other article: 
https://community.spotfire.com/forums/topic/3108-button-to-reload-prompt-on-spotfire/
 
Here is the code I used in my dashboard:
from Spotfire.Dxp.Framework.ApplicationModel import * def Refresh(): # define script parameter "table" to be refreshed     table.Refresh() ps = Application.GetService[ProgressService]() ps.ExecuteWithProgress("refresh title", "refresh description", Refresh) When you create this iron python code, and put it behind a button in a text area, be sure to uncheck the "Execute in transaction" as well as add a parameter for the data table that needs to be refreshed:

This worked for me in Spotfire 11 as well as Spotfire 14.
Kind regards,
David

Hello Kem,
I don't see any possibility for this at the moment. The properties you mentioned are the ones Spotfire offers. There seems to be no IronPython example (from this article) available, that would give you what you are looking for.: 
What I can see in our ideas portal (https://ideas.spotfire.com/ideas/TS-I-7853), is that a similar idea has been put forward. You may vote that idea up, as its current status is 'Future Consideration'.
The only way you have the ability to freeze a number of columns, is in a table visualization. There you can set the number of frozen columns (Properties>>Appearance). But that would mean you have to rebuild your cross table in a different way and probably lose functionality.
Kind regards,
David

Hello Barbara,
This article might be a good starting point for you: https://community.spotfire.com/articles/spotfire/spotfire-data-table-source-view-api-overview/.
Kind regards,
David