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?
Perhaps this will get you started.
<base search> | extract kvdelim=":" pairdelim=",}" | timechart latest(values.*) as *