Skip to Main Content
Spotfire Ideas Portal
Status Future Consideration
Product Spotfire
Categories Visualization
Created by Guest
Created on Feb 6, 2016

Insert calculated rows or columns cross table

Have the ability to insert rows or columns with custom calculations based on values presented in the table; so based on the table you have presented in the cross table, have an edit feature to allow for insert rows with calculations that can be applied to existing data in the cross tables. Think of it like excel - a way of easily prototyping results from an existing Spotfire cross table.

  • Attach files
  • Guest
    Reply
    |
    Apr 4, 2018

    I'd like to see each cross table have it's own set of columns just like any raw data table to make calculation reuse a lot easier. Currently I'm running these long spaghetti lines of calculations in my cross tables. Perhaps cross tables should be able to be run on already pivoted data (currently I'm having to unpivot data and re pivot it in the cross table), but I'm not really sure what implications that would cause.

3 MERGED

Ability to reference columns of a crosstable for usage in new column

Merged
I would like to use existing columns in a cross-table for calculating a new cross-table column. For example, There are two calculated columns with the sales of the current and the previous year. A third column would show the difference of those co...
over 6 years ago in Spotfire / Visualization 0 Future Consideration