How Can I do a simple line graph, here is an example:
I got four Fields ( Fruits, June, July, August), like this
and I want on XAxis( June, July, August) and each fruit must be a serie, like this:
So there is no time fields on this one, so probably I need to use |chart
Assuming your data or base search gives a table like in the question, they try this
your base search | table Fruits, June, July, August | untable Fruits Months Value | chart first(Value) over Month by Fruits
Use the line chart as visualization.
That is it!!! well almost, the only thing is: How can I change the order of the months? because, right now is like August -> July -> June!! need to be June -> July -> August.
I got it: | sort str(Months) desc
Thank you very much, could you please explain every step?
One more thing, you forgot to put 's' on """""| chart first(Value) over Month"""", can you correct?, is better if someone falls here.
search should have
| timechart count by fruit
to show line chart
to split series
to show independent Y-Axis ranges