Jump to content
We've recently updated our Privacy Statement, available here. ×

Compare time from timespan data for logical operators

Sudhansu Mishra

Recommended Posts

HI , I've a timeSpan column data in the form of HH:MM: SS.xxx. I'd like to use a normalization operation for data visualization as follows: Sum([ValueY])/Sum(If[TimeX]='11:45:00.000', [TimeX],0) over (All[TimeX]) But I get an error /warning which means it's unable to compare the [TimeX] values to absolute time 11:45:00.000 which is a value in the column. Could someone help me understand how to use logical comparators with timestamp data Error: Invalid type for function call '='. I've to use an inverted comma for the absolute timestamp or else Spotfire returns an expected error.
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...