Dashboards & Visualizations

How to remove blank spaces from table in dashboard in splunk ?

bagarwal
Path Finder

Hi Everyone,

I am creating a dashboard with multiple stats report. And I want to remove unwanted blank spaces that appears in the table. Is there any way to remove these blank spaces so can make the dashboard look even more better. Screenshot attached.

alt text

alt text

0 Karma

Satsan
Engager

I am also facing the same issue and please find my query and not able to attach screenshots

index="wineventlog" host=myhostnames AND source="WinEventLog:Application" AND Type=Error | top limit=20 Message | eval Message=substr(Message, 13, 100) | table Message count | rename Message as "Error Desc", count as "Error Count"

0 Karma

Tom1187
Path Finder

Hi bagarwal.
I haven't tried this myself, but I found this answer, and it looks perfect for you:
https://answers.splunk.com/answers/24861/width-adjustable-table.html

if the accepted answer does not work for you, try the last comment on the page-

... | rex field=longfield max_match=0 "(?.{0,50})"
0 Karma

niketn
Legend

Seems like you have taken a screenshot with Dashboard Edit turned on. Can you take one without Edit?
Can you also tell whether table is only visualization in the row or is there something else in the same row (If possible take dashboard screenshot)?

Table should not have whitespace above it. Only whitespace is to allow for Table title. Do you want to take that out?

____________________________________________
| makeresults | eval message= "Happy Splunking!!!"
0 Karma

bagarwal
Path Finder

Hi Nikentnilay,

Thanks for your response. I have attached the screenshot in the main question page. I would like to eliminiate the white space between the two columns . I ran the stats command to display result in tabular format and between columns there are white spaces that's of no use. So need to delete or shrink the column length.

Thanks & Regards,
Binay Agarwal

0 Karma

oda
Communicator

bagarwal
Path Finder

Hi oda,

Thanks for your response. I don't want to remove the fields that contain null values . I want to shrink the column width as it is filled with blank spaces ( screenshot attached in the main question) .

Thanks & Regards,
Binay Agarwal

0 Karma
Get Updates on the Splunk Community!

Index This | How many sides does a circle have?

February 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

Registration for Splunk University is Now Open!

Are you ready for an adventure in learning?   Brace yourselves because Splunk University is back, and it's ...

Splunkbase | Splunk Dashboard Examples App for SimpleXML End of Life

The Splunk Dashboard Examples App for SimpleXML will reach end of support on Dec 19, 2024, after which no new ...