Questions tagged [spotfire-analyst]
67 questions
2
votes
1 answer
How to find out if the user has moved from one page in Spotfire to another page?
I have a calculated value displayed on different pages in Spotfire. I want this value to be reset to zero, everytime a user moves from one page to another page.
I am not sure how to find out if the user has changed the page or not? Using Iron…
2
votes
1 answer
Limit max day of Data for all months
I need to calculate, over months, the value of Sales in every month limiting the max day of my data = my Day(DateTimeNow()) - 1.
Examples:
Today is 25 of march, i wanna see in my bar chart the total of Sales until day 24 for january, february and…

Ricardo
- 63
- 5
1
vote
1 answer
Spotfire calculate difference with respect to previous row value
I have a data as below. I have created column "difference in values" manually, the calculation is value at 8:15 AM - value at 8:00 AM which is 2 in second row and so on for all values of column Tushar and Lohit respectively. How can i do this…

Tushar Lohit
- 11
- 2
1
vote
0 answers
TIBCO SPOTFIRE KPI
i have a kpi depending on a property setting (check-box). Then in the check-box list i have two different value: a, b (corresponding to the values in column propertycolumn).
Depending on this value i want to calculate a kpi value in this way: SUM of…

Fabvar
- 11
- 1
1
vote
1 answer
Spotfire to Power Query
I am converting a Spotfire report to Power BI and am stuck with one of the calculated column. I have the below calculation in Spotfire:
when
([Target Date]>=DateAdd("day",-DayOfWeek(DateTimeNow()),DateTimeNow())) and
([Target…

Priyanka2304
- 200
- 3
- 16
1
vote
1 answer
Spotfire - count a status change
And is it possible in Spotfire to use a calculated field to count a status change every time it changes from 0 to 1? e.g. if (previous row = 0 and current line =1, sum, else empty)

Eduardo Azevedo
- 11
- 1
1
vote
1 answer
How to change Integer 20200224 to date 24/02/2020 in Spotfire (Expression ?)
In spotfire I have a loaded column with integer 20200224 I would like to change this to date 24/02/2020 with a transformation and expression ( or an other way if possible) .

Steven Reynders
- 11
- 1
1
vote
0 answers
Configuring Spotfire 7.02 Display Engine
I'm using an outdated Spotfire version (7.02) on a client and got stuck while trying to use an

Oliver Drummond
- 680
- 1
- 6
- 19
1
vote
1 answer
Is there a way to sort strings in the colums in alphabetical order in spotfire?
The column in spotfire have strings such as CDBAF, Is there a way where this string can be sorted in alphabetical order, eg: CDBAF to ABCDF

Mayur
- 11
- 2
1
vote
0 answers
Multiple Custom Expression with conditions for single bar chart
I have been trying to calculate "Overtime" in a single chart for an analysis. The data table looks like this:
Name _Hours _Shift Type
Tom___5.5 ____ Long
Dick ___6 _____ Long
Harry__7.7 _____Short
Jon ___4.5 _____Short
Tom ___5.6 …

Smarajit Chakraborty
- 11
- 2
1
vote
2 answers
Using Spotfire functions when connecting to a Database connection
I'm connecting my Spotfire to Postgres database. After connecting to the db some of the functions are not available in Spotfire. I want to know if there is a way I can be connected to the database and still use all the Spotfire functionalities. I…

shivam sarin
- 35
- 6
0
votes
1 answer
Spotfire : Load already created pickle file from data function in spotfire
Has anyone tried calling in a pickle file already created from spotfire's data function?
There is too little information about using pickle file from data function.
If anyone has used it, please provide a simple example of calling the pickle file…

Yuriel
- 3
- 1
0
votes
1 answer
Export Spotfire to Powerpoint in Python
I've found a ironpython script that supposedly works and exports Spotfire visualizations to a Powerpoint presentation:
import clr
import spotfire
clr.AddReference("System.IO")
clr.AddReference("Spotfire.Dxp.Application.Visuals")
from System.IO…
0
votes
1 answer
How to get list of user having access to TIBCO Spotfire report?
Kindly suggest a rough idea to implement this :
We have close to 40 TIBCO Spotfire reports and all reports have dedicated ACTIVE DIRECTORY(AD GROUP) to restrict the users to access it .
Now we want to create a dashboard for listing all the reports…

Teju MB
- 1,333
- 5
- 20
- 37
0
votes
0 answers
Spotfire to DAX Power BI conversion
Trying to covert Spotfire calculated column in DAX
case
when ([SIHP]=0) or ([SIHP] is null) then null
when (Max([SIHP]) over (Intersect([Job ID],Previous([SIIN],1))) is null) and (Abs([SIHP] - [NSHP])>50) then "Fail"
when Abs([SIHP] - [PSHP)>50 then…