CODEWITHSUNDEEP
spotfire
user9894150
user9894150

Reputation: 29

Rank based on Sequence of dates in Spotfire

I am new to Spotfire and would appreciate any help on this. Here is a sample data i am working on...

Well_ID    Date    Oil_Rate
1       8/30/17     614.62
1       8/31/17     614.62
1       9/01/17     873.07
1       9/02/17     873.07

And I need Something like below

Well_ID   Date     Oil_Rate    Rank
1       8/30/17     614.62     1
1       8/31/17     614.62     2
1       9/01/17     873.07     1
1       9/02/17     873.07     2

Can anyone help me with this? Thanks!

Upvotes: 1

Views: 1764

Answers (1)

Mark P.
Mark P.

Reputation: 1827

This simple Rank function should suffice: Rank([Date],Month([Date]),[Well_ID])

enter image description here

Ranks the Dates by their month and by Well_ID. other columns can be added as well to Rank over.

Upvotes: 3

Related Questions