topic Re: How to Splunk Dashboard Studio table column align left in Dashboards & Visualizations

How to make Splunk Dashboard Studio table column align to the left?

DPOIRE — Tue, 17 May 2022 14:41:10 GMT

Hi,

I created a table using Splunk Dashboard Studio (Absolute). However a column contains results like A, B, C, 0, 1.
A, B and C display align left and 0 and 1 displays aligned right.
I want all to be align left.

When selecting code option to add align command, I keep getting error and it does not align left.
How should I code this:

"options": {
"columnFormat": {"align": "left"}
}

Re: How to Splunk Dashboard Studio table column align left

vinod743374 — Mon, 16 May 2022 05:51:25 GMT

Here I am Pasted the Entire Table Code, You can find the align : center in that, you can implement the same in your table Code.

you can use left , Right, Center

{

"type": "splunk.table",

"dataSources": {

"primary": "ds_nbdmjwIg"

"options": {

"backgroundColor": "transparent",

"tableFormat": {

"rowBackgroundColors": "> table | seriesByIndex(0) | pick(tableAltRowBackgroundColorsByBackgroundColor)",

"rowColors": "> rowBackgroundColors | maxContrast(tableRowColorMaxContrast)",

"headerBackgroundColor": "> backgroundColor | setColorChannel(tableHeaderBackgroundColorConfig)",

"headerColor": "> headerBackgroundColor | maxContrast(tableRowColorMaxContrast)"

"headerVisibility": "none",

"columnFormat": {

"Parameter": {

"data": "> table | seriesByName(\"Parameter\") | formatByType(ParameterColumnFormatEditorConfig)"

}

"showRowNumbers": true,

"align":"center"

"context": {

"ParameterColumnFormatEditorConfig": {

"string": {

"unitPosition": "after"

}

"showProgressBar": false,

"showLastUpdated": false

}

Thankyou.

Re: How to Splunk Dashboard Studio table column align left

DPOIRE — Mon, 16 May 2022 17:34:56 GMT

Unfortunately, it makes no difference.
0 and 3 still aligned right instead of left ( R, S b ).

See attached

Re: How to Splunk Dashboard Studio table column align left

vinod743374 — Tue, 17 May 2022 04:33:04 GMT

Can you Please try this Code once,

{

"type": "splunk.table",

"options": {

"count": 100,

"dataOverlayMode": "none",

"drilldown": "none",

"percentagesRow": false,

"rowNumbers": false,

"totalsRow": false,

"wrap": false,

"tableFormat":{

"align":"> table |pick(alignment)"

"columnFormat": {

"messegetype": {

"data": "> table | seriesByName(\"messegetype\") | formatByType(messegetypeColumnFormatEditorConfig)"

}

"showRowNumbers": false

"dataSources": {

"primary": "ds_search_1"

"title": "Right Alignment",

"context": {

"messegetypeColumnFormatEditorConfig": {

"string": {

"unitPosition": "after"

}

"alignment": [

"left"

]

"showProgressBar": false,

"showLastUpdated": false

}

Let me know is this works.

Re: How to Splunk Dashboard Studio table column align left

JHannan — Fri, 03 Jun 2022 00:14:30 GMT

Your solution works, though I was being tripped up by two separate "option" clauses. I had drill downs enabled on my table, but left the other options default. This left the base "options" clause out, but a second "options" clause was nested on the eventHandlers clause. I had to change something to fix this. In my case, I turned on Column Formatting for two of the fields in the table.

This is my table with your alignment option added. Thanks!

"viz_tbl_cnt_by_user": { "type": "splunk.table", "dataSources": { "primary": "ds_qWJPJZ6C" }, "eventHandlers": [ { "type": "drilldown.setToken", "options": { "tokens": [ { "token": "tkn_user", "key": "row.identity.value" } ] } } ], "options": { "tableFormat": { "align": "> table |pick(alignment)" }, "columnFormat": { "identity": { "data": "> table | seriesByName(\"identity\") | formatByType(identityColumnFormatEditorConfig)" }, "usernames": { "data": "> table | seriesByName(\"usernames\") | formatByType(usernamesColumnFormatEditorConfig)" } } }, "context": { "identityColumnFormatEditorConfig": { "string": { "unitPosition": "after" } }, "usernamesColumnFormatEditorConfig": { "string": { "unitPosition": "after" } }, "alignment": [ "left" ] } }

Re: How to Splunk Dashboard Studio table column align left

surens — Thu, 05 Jan 2023 12:03:57 GMT

It's working

Thanks,

Re: How to Splunk Dashboard Studio table column align left

visvar90 — Thu, 27 Jul 2023 09:07:15 GMT

I have tried to center align the table using the method below. But the table always align the data to the left irrespective of center or right

Re: How to Splunk Dashboard Studio table column align left

vinod743374 — Thu, 27 Jul 2023 09:21:51 GMT

Try this Sample Dashboard Code and understand the code and then apply to u r scenario, it should work.

{

"visualizations": {

"viz_RVm8V48A": {

"type": "splunk.table",

"options": {

"columnFormat": {

"sum(bytes_in)": {

"data": "> table | seriesByName(\"sum(bytes_in)\") | formatByType(sum_bytes_in_ColumnFormatEditorConfig)"

}

"tableFormat": {

"align": "> table |pick(alignment)"

}

"dataSources": {

"primary": "ds_egVRJIic"

"context": {

"sum_bytes_in_ColumnFormatEditorConfig": {

"number": {

"thousandSeparated": false,

"unitPosition": "after"

}

"alignment": [

"center"

]

}

"dataSources": {

"ds_egVRJIic": {

"type": "ds.search",

"options": {

"query": "| inputlookup firewall_example.csv\r\n| stats sum(bytes_in) sum(bytes_out) count by host",

"queryParameters": {

"earliest": "-24h@h",

"latest": "now"

}

"name": "Search_1"

}

"defaults": {

"dataSources": {

"ds.search": {

"options": {

"queryParameters": {

"latest": "$global_time.latest$",

"earliest": "$global_time.earliest$"

}

"inputs": {},

"layout": {

"type": "absolute",

"options": {

"width": 1440,

"height": 960,

"display": "auto"

"structure": [

{

"item": "viz_RVm8V48A",

"type": "block",

"position": {

"x": 130,

"y": 80,

"w": 1240,

"h": 260

}

"globalInputs": []

"description": "",

"title": "Test"

}

If isn't work for u, can share u r sample data will help u accordingly.

Thankyou!

Re: How to Splunk Dashboard Studio table column align left

visvar90 — Thu, 27 Jul 2023 10:02:43 GMT

It worked for me. Thanks for the help. Really appreciate it.