Arranging data for Similarity analysis

[Abdulmajeed Alkatheeri]

HI,

 

I have a set of time series data that i want to compare using similarity analysis.

However, i am struggling to understand how TIBCO takes the data table format and do the analysis.

 

I arranged my data in such way:

 

 

 

Date

Variable 1

Variable 2

Variable 3

Variable 4

 

 

05/04/2021

0.291969

0.091246

0.336067

0.215809

 

 

06/04/2021

0.119

0.125136

0.011521

0.601799

 

 

07/04/2021

0.839002

0.717615

0.064041

0.037511

 

 

08/04/2021

0.385569

0.861875

0.355186

0.597942

 

 

09/04/2021

0.871829

0.921401

0.410713

0.579216

 

 

10/04/2021

0.760025

0.485168

0.367521

0.788672

 

 

11/04/2021

0.236893

0.257049

0.213398

0.90398

 

 

 

Above example are just random numbers.

 

Then I plot the different variables in the y axis vs the date in the x axis.

and keeping the line by column name. but it does not work.

 

how should i arrange the data in this case.

 

Thanks