Jump to content

How to prevent duplicates and ensure 'latest date' is displayed in multiple columns and from multiple data sources

Ian Levoi

Recommended Posts

The idea of my Spotfire Dashboard is to display the most current configuration of a machine. Below is a simplified version:






Wheel Serial Number

Date (2)

Axle Serial Number

Date (3)

Car Serial Number




















But it is not quite so simple because the Wheelsare moved and installed in a different Axleand the same with Axlesin different Cars..

The Date, Date (2), Date (3) are the test dates of each corresponding part. A part is tested every time the configuration changes.

This data canvas attached shows how the the test data tables combine to create the 'Current Car Config' data table.

Important: The [Wheel Serial Number] is used as a Unique Identifier to link the 3 tables.

My problem is that I need to limit/filtermy data to ensure the following:


Each part should only appear once in the table at any one time.

The latest configuration should always be displayed.

If a Wheeltest date [Date] is later than a Axletest date [Date (2)], the wheel is not installed therefore the columns [Date(2), [Chassis Serial Number], [Date(3)], [Car Serial Number] should be empty.

If a Chassis test date[Date (2)] is later than a Cartest date [Date (3)], the Chassisis not installed therefore the columns [Date(2), [Chassis Serial Number], [Date(3)], [Car Serial Number] should be empty.


I've been struggling trying to adapt the following formulas to achieve this:


I've also tried using Max Date expressions which will not work either.

Please help!

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...