Can someone help me chart JSON values?

sarnathkj · ‎08-29-2018

I have a JSON just like this. I want to chart data of the values inside values key. The keys of the data in the values will be dynamic.

{"Domain":"DotComMobile","Metrics":"regionCode","values":{"NY":563,"FL":270,"NJ":265,"PA":256,"MA":223,"CA":214,"VA":164,"MD":163,"TX":155,"OH":151}}

How would that be achieved?

richgalloway · ‎08-29-2018

Perhaps this will get you started.

<base search> | extract kvdelim=":" pairdelim=",}" | timechart latest(values.*) as *

---
If this reply helps you, Karma would be appreciated.