Set x-axis over multiple topic at line graph

[Questioner]

I have data like this,

	1st course	2cd course	3rd course	4th course
A	3	4	2	2
B	2	5	1	3

I would like this data to look like this using a line graph,

Questioner_0-1690186551683.png

I'm trying to use this code, but the when i use multiple "over" data, an error occurs.

chart avg(x) as A over "1st course", "2cd course"

How Could I make this line graph? 

[ITWhisperer · Accepted solution]

Your first column needs a field name (I have chosen User for this demonstration). Essentially, you need to use transpose.

| makeresults 
| fields - _time
| eval _raw="User	1st course	2cd course	3rd course	4th course
A	3	4	2	2
B	2	5	1	3"
| multikv forceheader=1
| table User *_course
``` The line above sets up demonstration data in line with your example ```
| transpose 0 header_field=User column_name=Course

[Questioner]

I solved it!

Thank you for your help 🙂