@somesoni2, this is wonderful thank you so much for your help. One small problem, this line doesn't seem to work 'avg(heading)'>=348.75 AND 'avg(heading)'<11.25,"N" - currently anything above 348.75 up to 11.25 is seen as undefined.
I was able to get it to recognize up to 360 but not from 0 until 11.25 as North. Here is how I changed for this.
index="tesla" | timechart span=2m avg(heading) usenull=f | eval Direction=case('avg(heading)'>=348.75 AND 'avg(heading)'<11.25,"N",
'avg(heading)'>=11.25 AND 'avg(heading)'<33.75,"NNE",
'avg(heading)'>=33.75 AND 'avg(heading)'<56.25,"NE",
'avg(heading)'>=56.25 AND 'avg(heading)'<78.75,"ENE",
'avg(heading)'>=78.75 AND 'avg(heading)'<101.25,"E",
'avg(heading)'>=101.25 AND 'avg(heading)'<123.75,"ESE",
'avg(heading)'>=123.75 AND 'avg(heading)'<146.25,"SE",
'avg(heading)'>=146.25 AND 'avg(heading)'<168.75,"SSE",
'avg(heading)'>=168.75 AND 'avg(heading)'<191.25,"S",
'avg(heading)'>=191.25 AND 'avg(heading)'<213.75,"SSW",
'avg(heading)'>=213.75 AND 'avg(heading)'<236.25,"SW",
'avg(heading)'>=236.25 AND 'avg(heading)'<258.75,"WSW",
'avg(heading)'>=258.75 AND 'avg(heading)'<281.25,"W",
'avg(heading)'>=281.25 AND 'avg(heading)'<303.75,"WNW",
'avg(heading)'>=303.75 AND 'avg(heading)'<326.25,"NW",
'avg(heading)'>=326.25 AND 'avg(heading)'<348.75,"NNW",
'avg(heading)'>=348.76 AND 'avg(heading)'<360.00,"N")
| fields Direction
Update - I think I fixed it:
index="tesla" | timechart span=2m avg(heading) usenull=f
| eval Direction=case('avg(heading)'>=0.00 AND 'avg(heading)'<11.25,"N",
'avg(heading)'>=11.25 AND 'avg(heading)'<33.75,"NNE",
'avg(heading)'>=33.75 AND 'avg(heading)'<56.25,"NE",
'avg(heading)'>=56.25 AND 'avg(heading)'<78.75,"ENE",
'avg(heading)'>=78.75 AND 'avg(heading)'<101.25,"E",
'avg(heading)'>=101.25 AND 'avg(heading)'<123.75,"ESE",
'avg(heading)'>=123.75 AND 'avg(heading)'<146.25,"SE",
'avg(heading)'>=146.25 AND 'avg(heading)'<168.75,"SSE",
'avg(heading)'>=168.75 AND 'avg(heading)'<191.25,"S",
'avg(heading)'>=191.25 AND 'avg(heading)'<213.75,"SSW",
'avg(heading)'>=213.75 AND 'avg(heading)'<236.25,"SW",
'avg(heading)'>=236.25 AND 'avg(heading)'<258.75,"WSW",
'avg(heading)'>=258.75 AND 'avg(heading)'<281.25,"W",
'avg(heading)'>=281.25 AND 'avg(heading)'<303.75,"WNW",
'avg(heading)'>=303.75 AND 'avg(heading)'<326.25,"NW",
'avg(heading)'>=326.25 AND 'avg(heading)'<348.75,"NNW",
'avg(heading)'>=348.76 AND 'avg(heading)'<360.01,"N") | fields Direction
... View more