TIBCO Spotfire

I have an analysis that has a number of pivots and joins off of a main pivot table. I am trying to create a method for the user to be able to select the columns used in the data aggregation of the main pivot table, which then carries forward to all the other linked tables. I have created four drop-down...

Any help would be greatly appreciated... I have a dataset of people. Each person has different activities they may engage in and amount of calories they may burn. In a HIGHLY simplified state, it essentially looks something like this: Participant Time Calories Burned Activity John 12pm 141 Running John...

Hello, I am new to Spotfire. I have data that looks at the Heart Rate of a number of subjects across a number of conditions. With the expression "Min([HeartRate]) OVER ([SubjectID])" I can create a box plot to evaluate the distribution of minumum Heart Rates. My question is, can I create an...

First add a total column to the table, using Insert, Calculated Column Sum([count]) As TotCount Then in the cross-tab, specify custom expression as Sum([count]) / First([TotCount]) and format the output at percentage

I have a new calculated column based on two columns - x as a % of y. How can I control the aggregation so that [x as a % of y] is always maintained at all levels of viewing data? Setting the aggregation rule as avg does not work because it depends on the number of rows (and would work only if the level...

I have a situation that has me stumped and I don't think it should. Let say you have say you have sales data with a hierarchy for the product that goes Departmen>Group>Category>Item. Each item has a unique price. There is a sales target assigned at the Category level. It easy to create a...

Perfect! the problem were the integer values, Thanks a lot!

Hi Guys, I´m stucked with the same problem: Sum(if([MONTH]="6",[IMPORTE],0)) as [June], Sum(if([MÊS]="7",[IMPORTE],0)) as [July], Sum(if([MONTH]="6",[IMPORTE],0)) - Sum(if([MONTH]="7",[IMPORTE],0)) as [Difference] I have the amount of money expended on month "6"...

Hi Guys, I´m stucked with the same problem: Sum(if([MONTH]="6",[IMPORTE],0)) as [June], Sum(if([MÊS]="7",[IMPORTE],0)) as [July], Sum(if([MONTH]="6",[IMPORTE],0)) - Sum(if([MONTH]="7",[IMPORTE],0)) as [Difference] I have the amount of money expended on month "6"...

Hello, Is it possible to remove the aggregation setting e.g.,"Sum()", "Count()" when I changed the axis columns? That means default no aggregation and change axis columns without any aggregation. Thanks, Archer