topic Is there any way to display single accurate values within each cell of the table? in Splunk Search

Is there any way to display single accurate values within each cell of the table?

Sss — Thu, 15 Jun 2023 00:27:59 GMT

I have used search query like this-

| savedsearch REPORT1

|chart values(COLUMN3) AS Status BY COLUMN2 PROCESS_ID| fillnull value="_"|table COLUMN2 VAL1 VAL2 VAL3 VAL4 VAL5 VAL6 VAL7......

and I got result like below,

here,the values are repeated within each cell(i.e;few cells are having multiple values say '_' & 'F') and few columns are null.

Is there any way to display single accurate values within each cell of the table.

Re: Table value specification

ITWhisperer — Tue, 13 Jun 2023 12:11:25 GMT

Try something like this

|chart values(eval(if(COLUMN3="_",null(),COLUMN3))) AS Status BY COLUMN2 PROCESS_ID| fillnull value="_"|table COLUMN2 VAL1 VAL2 VAL3 VAL4 VAL5 VAL6 VAL7......

Re: Table value specification

Sss — Thu, 15 Jun 2023 04:28:24 GMT

I tried this but got the same result.