Can I extra JSON data from a field?

1

Hi guys, I’m getting a JSON object in one of our fields. I’d like to extract the data from there. The said JSON as an example is:

{
	"device_os":"ICE_CREAM_SANDWICH_MR1 4.0.4",
	"device_model":"Samsung Galaxy S DUOS",
	"pending_count":"0",
	"sent_count":"281",
	"unfinished_count":"53",
	"local":"en",
}

I would like to extract pending, sent and unfinished, so I can arrange them in a pie chart. Is this possible with metabase?

1 Like