About dgwann

dgwann · ‎11-20-2023

No, just says null now on the x-axis.

dgwann · ‎11-16-2023

I have an index that provides a Date and a row count to populate a line chart on a dashboard using DBConnect. The data looks like this: Date Submissions 2023-11-13 7 2023-11-14 35 2023-11-15 19 When the line chart displays the data, the dates show up like this: 2023-11-12T19:00:00-05:00, 2023-11-13T19:00:00-05:00, 2023-11-14T19:00:00-05:00. Is there some setting/configuration that needs to be updated?

dgwann · ‎10-18-2023

I ended up using the chart command instead of stats and got it to come out correctly. Thanks again!!

dgwann · ‎10-17-2023

Okay, I'm getting closer. I get a line chart to show up now. However, I need 3 different lines representing the 3 different customers and the Number of submissions for each day. I just need to get the SPL right. Thanks for your assistance and patience!!

dgwann · ‎10-12-2023

I've done exactly as you said, but it's still not working. What kind of visualization type should I select to get a multi line graph? I'm running on a clustered environment using SQL Server 2016 and using DBConnect. My field in the dashboard still says it is waiting for input. I updated the Indexes.conf files and did the Rolling Restart on the Index Clustering Manager node.

dgwann · ‎10-06-2023

I want a dashboard panel to display the line chart, the query should be run in the background every 30 minutes to an hour and update the display. So I assume I mean that I want to directly execute the query on the DB and display results. I've created the Input. Do I need to create an Output? I don't want to update the database at all, just read it.

dgwann · ‎10-06-2023

@gcusello Where do I put those blocks of code you sent? Do I put them somewhere in the dashboard builder, or in the DBConnect for the Input? Like I said, I'm very new to this.

dgwann · ‎10-06-2023

I have a DBConnect Input defined that produces the following output: Date Group_Name Number_of_Submissions 2023-10-02 Apple 780 2023-10-03 Apple 1116 2023-10-04 Apple 1154 2023-10-05 Apple 786 2023-10-06 Apple 699 2023-10-02 Banana 358 2023-10-03 Banana 760 2023-10-04 Banana 254 2023-10-05 Banana 1009 2023-10-06 Banana 876 2023-10-02 Others 1265 2023-10-03 Others 1400 2023-10-04 Others 257 2023-10-05 Others 109 2023-10-06 Others 1709 I want to have this data displayed on a Dashboard as a multi-line chart, x-axis is the Date, y-axis is the Number of submissions, and there should be different color lines representing the different groups. I am new to Splunk. Very new. I need succinct instructions pls. Thanks!!!

Posts	8
Solutions	0
Karma Given	1
Karma Received	0
Member Since	‎09-20-2023

Online Status	Offline
Date Last Visited	‎11-16-2023 11:01 AM

Dates showing up in line charts are reformatted to...

Add a DBConnect Input to Dashboard

Re: Dates showing up in line charts are reformatte...

Dates showing up in line charts are reformatted to...

Re: Add a DBConnect Input to Dashboard

Re: Add a DBConnect Input to Dashboard

Re: Add a DBConnect Input to Dashboard

Re: Add a DBConnect Input to Dashboard

Re: Add a DBConnect Input to Dashboard

Add a DBConnect Input to Dashboard