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

Use expression spanning two tables with over expression for the main table.

1. Open SuperstoreSales
2. Add Data Tables -> SuperstoreSales again, call it T2.
3. Insert a barchart, use <[Order Priority]> on the x-axis
4. On the y-axis write: Sum([Sales Total]) OVER (AllPrevious([Axis.X])) - Sum([T2].[Sales Total])

(x) Result: An error message saying "OVER expressions can only reference columns in the main data table."
(/) Expected: A correct error message (we ARE infact only referencing columns in the main data table), or a working plot since there is no technical issue why this type of plot configuration shouldn't work.
  • Attach files