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…
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…
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)
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) .
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