topic Re: Not able to display the column contents in table in Dashboards & Visualizations

How to display the column contents in table?

Sss — Tue, 20 Jun 2023 02:29:48 GMT

I have my report where I have written something like this-

|dbxquery query="select COLUMN1,COLUMN2,COLUMN3,COLUMN4
FROM TABLE1
WHERE COLUMN1 IN ('xyz') ",connection="XXX"

I have added this to my dashboard by using query-

| savedsearch rep1
| chart values(column3) AS Status BY column2 column4
| fillnull value="-"
| table column1 column2 ......

In my dashboard,values of COLUMN1 are not displayed.

Is there any way how i can display value of column1 i.e;xyz

Re: Not able to display the column contents in table

ITWhisperer — Mon, 19 Jun 2023 11:37:45 GMT

| chart values(column3) AS Status BY column1 column4

Re: Not able to display the column contents in table

ITWhisperer — Mon, 19 Jun 2023 11:43:15 GMT

On a less flippant note, please provide more detail.

Do you want to replace some of the existing data in the table, or have the column1 values as extra?

If you want them as extra, how are they to be combined with the existing data?

Re: Not able to display the column contents in table

Sss — Tue, 20 Jun 2023 04:26:03 GMT

I have used this command,but only column name is displaying without any data in that column.

Re: Not able to display the column contents in table

Sss — Tue, 20 Jun 2023 04:27:26 GMT

I dont want to replace any data,but have to include that Column1 which will display value as 'xyz'.

Re: Not able to display the column contents in table

ITWhisperer — Tue, 20 Jun 2023 08:16:59 GMT

You still haven't answered the final question. How does column1 relate to the other data you want to display?

For example, is there a one-to-one relationship between column1 and column2, or can there be multiple values of column1 for every combination of column2 and column4?

Re: Not able to display the column contents in table

Sss — Tue, 20 Jun 2023 09:13:11 GMT

The reamining column are with respect to COLUMN1,i.e; its related to that particular group say 'xyz'.

Re: Not able to display the column contents in table

ITWhisperer — Tue, 20 Jun 2023 10:11:15 GMT

That is not a very clear answer. Do you mean something like this?

| stats values(column3) AS Status BY column1 column2 column4 | eval {column4} = Status | fields - Status column4 | stats values(*) as * by column1 column2 | fillnull value="-"

Re: Not able to display the column contents in table

Sss — Wed, 21 Jun 2023 05:25:18 GMT

Thank you so much,it worked for me