Re: Can someone help me chart JSON values? - Splunk Community

Splunk Search

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 *

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

Get Updates on the Splunk Community!

Unlock Database Monitoring with Splunk Observability Cloud

In today’s fast-paced digital landscape, even minor database slowdowns can disrupt user experiences and stall ...

Print, Leak, Repeat: UEBA Insider Threats You Can't Ignore

Are you ready to uncover the threats hiding in plain sight? Join us for "Print, Leak, Repeat: UEBA Insider ...

Splunk MCP & Agentic AI: Machine Data Without Limits

Discover how the Splunk Model Context Protocol (MCP) Server can revolutionize the way your organization ...