How to multiply two separate columns with the same timestamp in different rows
I'm having an issue trying to calculate this in Spotfire, where it would be extremely easy in excel. I have a data set that is imported from a source and automatically sets it in a table like the following:
|Timestamp||Column A||Column B|
In another column I want to have column A multiplied by column B for each of their respective timestamps. For instance, the first row would be 100 * 1, as they bot hcorrelate to 1/1/2019. Any information on this would be great, thanks!