topic Re: How can I make a simple x over y chart in Dashboards & Visualizations

How can I make a simple x over y chart

splunktrain9 — Thu, 03 Mar 2022 01:16:57 GMT

I have the following data, and I want a graph with the age as the x axis, and height as the y axis. name and value are fields pulled out of a "rex field=_raw" command.

name

value

height

age

height

age

height

age

height

age

100

105

107

108

Re: How can I make a simple x over y chart

tshah-splunk — Thu, 03 Mar 2022 06:07:36 GMT

Hey @splunktrain9,

You can create a chart with functions like values() and group it by age field. These can be achieved since using rex also, the fields will be created and can be used in charts. Your query should look something like below:

<your query> | chart values(height) as height by age

Re: How can I make a simple x over y chart

ITWhisperer — Thu, 03 Mar 2022 07:24:17 GMT

It is not clear what sort of chart you want, and given the vagueness of your data, it is unclear what sort might be suitable.

Are all your ages unique i.e. is there a one-to-one relationship between age and height?

Are all these values from the same event or different events?

Have these values been extract (with rex?) into name and value fields?

Are there other values in the events with which can be used to split the data into different series? This isn't strictly required but it might help determine an appropriate solution.

Please provide more precise detail on what it is you are trying to do.