topic Re: chart graph help in Splunk Search

chart graph help

surekhasplunk — Fri, 27 Nov 2020 03:35:50 GMT

Hello,

I have data in a lookup file which i am appending everyday instead of indexing.

Time Device Infra Average Tool1 Tool2
11/26/2020 03:56 6223 95 88.41 95.69
11/27/2020 03:56 6220 94 88.39 95.74

And in the lookup file i have data in above format.

What is the best way to show in a graph/chart the evolution of each field by Time

Thanks

Re: chart graph help

ITWhisperer — Fri, 27 Nov 2020 07:59:00 GMT

What are you trying to achieve? Why are you collecting the data? What insights do you hope to get from your charts/graphs? How does your data change over time? Answer some of these questions and it would easier to help you.

Re: chart graph help

surekhasplunk — Fri, 27 Nov 2020 09:02:20 GMT

What are you trying to achieve? to see the trend of the numbers changing each day

Why are you collecting the data? to see the percentage of devices monitored in some of our tools. And work on the missing ones.

What insights do you hope to get from your charts/graphs? How does your data change over time?

every day/ every week once i am planning to append the csv file . from the chart/graph i need to show the change of numbers over time

Re: chart graph help

ITWhisperer — Fri, 27 Nov 2020 11:55:49 GMT

Have you loaded the file (inputlookup)? Use fields to list the fields you are interested in starting with the time field so it becomes the x-axis, then select the line graph visualisation

Re: chart graph help

to4kawa — Fri, 27 Nov 2020 13:08:29 GMT

>What is the best way to show in a graph/chart the evolution of each field by Time
The data doesn't explain anything about the meaning of.

Re: chart graph help

surekhasplunk — Fri, 27 Nov 2020 13:36:58 GMT

Yes i did load the lookup file.

Use fields to list the fields you are interested in starting with the time field so it becomes the x-axis, then select the line graph visualisation

(Here i wanted the query if can can help me with the exact query it will be helpful. )

Re: chart graph help

ITWhisperer — Fri, 27 Nov 2020 13:49:03 GMT

What have you tried so far?