Hi Team,
I am trying to create a quicksight analysis using aws cli with below command -
aws quicksight create-analysis --cli-input-json “file://$DefinitionPath” --tags ($TagsString -split ‘$$’) –debug
There are certain errors while creating the analysis using json input at the calculated fields level. have tried so many ways to fix but none seems to be working from last more than a day. below are the sample errors and code_snippets, please suggest
│ “Status”: “CREATION_FAILED”,
│ “Errors”: [
│ {
│ “Type”: “INVALID_CALCULATED_COLUMN_EXPRESSION”,
│ “Message”: “Calculated field Events_EventsDisplayParameter failed with error code SYNTAX_ERROR during translation”,
│ “ViolatedEntities”: “”
│ },
{
│ “Type”: “INVALID_CALCULATED_COLUMN_EXPRESSION”,
│ “Message”: “Calculated field SectorNewParameter failed with error code CONTEXTUAL_UNKNOWN_SYMBOL during validation”,
│ “ViolatedEntities”: “”
│ }
calculated fields -
{
“DataSetIdentifier”: “identifier_A”,
“Name”: “Events_EventsDisplayParameter”,
“Expression”: “ifelse(${EventsDisplayParameter}="Team Name", {team_nm}, "NA")”
},
{
“DataSetIdentifier”: “identifier_B”,
“Name”: “SectorNewParameter”,
“Expression”: “ifelse(${SectorNew}="Sector", {Industry Sector}, "NA")”
},
could somebody please help with this?