Hi everyone,
I’m using Redshift with a table that feeds into a Raw Data Table , bar charts, a trend chart, and a few KPIs in ChartFactor.
One of the columns in this table is of type JSON , and I’ve noticed that ChartFactor doesn’t handle it very well in certain cases — for example, in the Raw Data Table statistics .
The JSON in this column is always very simple: it contains only one property called region .
Has anyone run into this issue? Is there a way to extract or convert that property so it works smoothly in ChartFactor visualizations?
Thanks!