When I create calculated filed in data preview with parseJson, it works as expected like below:
But when add that in table with analysis, it shows null like below
Hi @Yijia_CERT - Welcome to AWS QuickSight community and thanks for posting the question. Did you click Save and publish to create the analysis. Can you please do this. This is bit surprise as the data should be visible in table in analysis.
Regards - Sanjeeb
Yes, I did. I did it multiple times and also refreshed the data.
In Data Pre, it works as expected, but still null in table analysis
Thank you for letting us know. I would recommend filing a case with AWS Support where we can dive into the details so that we can help you further. Here are the steps to open a support case. If your company has someone who manages your AWS account, you might not have direct access to AWS Support and will need to raise an internal ticket to your IT team or whomever manages your AWS account. They should be able to open an AWS Support case on your behalf. Hope this helps!