Skip to Main Content
Spotfire Ideas Portal
Status Future Consideration
Product Spotfire
Categories Custom Expressions
Created by Guest
Created on Mar 17, 2018

Self joins to calculate changes

Hi,

I need help with this in Tibco Spotfire 7.6

I have columns

[Name] [Manager] [Director] [Date]

Rahul     Rohit          Ravi          Jan-18

John      Jessica       Parul         Jan-18

Tj           Manu         Raghav      Feb-18

Rahul       Rohit        Rashid        Feb-18

John       Jessica      Parul          Feb-18

 

I want to display only those values in table visualization if Hierarchy of [Name] [Manager] [Director] changes or new is entered as compared to previous month.

 For this example the result should be 

Tj         Manu     Raghav         Feb 18

Rahul   Rohit     Rashid         Feb-18

  • Attach files