Can I extra JSON data from a field?

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",

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