topic Re: How to create a Multi-Series Line Chart? in Dashboards & Visualizations

How to create a Multi-Series Line Chart?

atomickonline — Fri, 16 Feb 2018 02:31:40 GMT

I can't figure out how to create a Multi-Series line chart.

For example, the sample data below shows test scores (Result) for the 4 participants over 3 tests.
I'd like to have a line graph for each participant.
X-Axis = GroupNumber (1,2,3,4)
Y-Axis = Result (1-100)
And plotted would be 4 lines, one for each participant with their scores.

My data in Splunk is in the format as represented below under "Sample Data". each is a separate entry that has Name, Result, and GroupNumber

Example Desired Outcome (Data Not Representative to Sample Data):

Sample Data:

Thanks

Re: How to create a Multi-Series Line Chart?

micahkemp — Fri, 16 Feb 2018 03:14:51 GMT

I think you may be looking for:

| chart first(Result) OVER GroupNumber BY Name

Re: How to create a Multi-Series Line Chart?

atomickonline — Fri, 16 Feb 2018 03:23:15 GMT

Perfect!. Thank you very much. Now that I see the solution, it makes sense.

Re: How to create a Multi-Series Line Chart?

emottola — Sat, 16 Nov 2019 20:45:38 GMT

I looked way too hard to find this. Thank you for your answer!