Code to prepare a Comparison Result table.

[jerinvarghese]

Hi All,

Need help in a Splunk code. Below is the data am having and a sample Table how the output looks like.

Input data: 

From	To	Latency
CATRC	CACCO	43.94
CATRC	CATRC	0
CATRC	GBLCO	148.61
CATRC	GBLHD	88.06
CATRC	INMCO	283.96
CATRC	CACCO	43.94
CATRC	CATRC	0
CATRC	GBLCO	148.61
CATRC	GBLHD	88.06
CATRC	INMCO	283.96

Required Output Table: 

	CACCO	CATRC	GBLCO	GBLHD	INMCO
CACCO	0	43.94	167.54	131.97	305.64
CATRC	44.61	0	148.61	88.06	283.96
GBLCO	167.54	148.61	0	3.51	137.96
GBLHD	131.97	88.06	3.51	0	5.5
INMCO	305.64	283.96	137.96	5.5	0

Challenge in getting Code for both X and Y axis in the table.

[jerinvarghese]

thanks that shows the data, but some challenge in showing the latest data/ latest latency value.. 

[ITWhisperer]

You will need to explain that more - the original question has been answered, correct?

Is there another question?

[jerinvarghese]

related doubt on the main program, If i want to add a sparkline to that that, how can i get it.

[ITWhisperer · Accepted solution]

| xyseries From To Latency