I would like to understand how to write Pivot Table “DataPathOptions” in the update-analysis definition input to set column width programmatically.
“account”:“640376836389”
"region:“us-east-1”
“AnalysisId”: “70a9ad0a-d9d1-4e43-83f3-b4dd1c00d9c5”
I tried the below options, but the columns width don’t reflect the defined width after running the update-analysis cli command.
“FieldOptions”: {
“SelectedFieldOptions”: [
{
“FieldId”: “d645b433-992e-4b4c-a217-bfcd81a5db53.service_group.2.1680562172770”,
“Visibility”: “VISIBLE”
},
{
“FieldId”: “d645b433-992e-4b4c-a217-bfcd81a5db53.service_name.3.1680562173492”,
“Visibility”: “VISIBLE”
},
{
“FieldId”: “29189dd4-6ed4-424d-bf47-4db8b6fbaa95.2.1680562314801”,
“Visibility”: “VISIBLE”
},
{
“FieldId”: “5c891d90-d450-4361-a912-e96d3c54e0e9.3.1680562315325”,
“Visibility”: “VISIBLE”
}
],
“DataPathOptions”: [
{
“DataPathList”: [
{
“FieldId”: “d645b433-992e-4b4c-a217-bfcd81a5db53.service_group.2.1680562172770”,
“FieldValue”: “service_group”
}
],
“Width”: “250px”
},
{
“DataPathList”: [
{
“FieldId”: “d645b433-992e-4b4c-a217-bfcd81a5db53.service_name.3.1680562173492”,
“FieldValue”: “service_name”
}
],
“Width”: “200px”
},
{
“DataPathList”: [
{
“FieldId”: “29189dd4-6ed4-424d-bf47-4db8b6fbaa95.2.1680562314801”,
“FieldValue”: “0 CY LW Actual”
}
],
“Width”: “190px”
},
{
“DataPathList”: [
{
“FieldId”: “5c891d90-d450-4361-a912-e96d3c54e0e9.3.1680562315325”,
“FieldValue”: “0 CY CW Actual”
}
],
“Width”: “90px”
}
]
}