Hi all,

I have a column with JSON data. I want to show this column in a chart, but it is very messy, and no JSON parsing function is supported on Zoho Analytics.

data example: {"id": 5, "status": "false", "date": "15/10/22"}

what I want to do in SQL is only get only id or only date etc, but it'd just show the whole string.

Thank you, I'd appreciate any help.