Issue with free-form layout when uploaded via API

Q&A
, ,
1

I am facing issues while uploading my analysis to Quicksight with free-form layout via API.
All my components are getting aligned to left instead of their correct position.
Image:

image
image1042×935 79.9 KB

And after clicking on the apply there come to their right position.
Image:

image
image1513×924 109 KB

This is my layout json which I used via Api:

“layouts” : [ {
“configuration” : {
“gridLayout” : null,
“freeFormLayout” : {
“elements” : [ {
“elementId” : “d97cda9a-4af5-4633-a585-0786f90f553f”,
“elementType” : “VISUAL”,
“width” : “412px”,
“height” : “784px”,
“visibility” : “VISIBLE”,
“renderingRules” : null,
“borderStyle” : null,
“selectedBorderStyle” : null,
“backgroundStyle” : null,
“loadingAnimation” : null,
“yaxisLocation” : “8px”,
“xaxisLocation” : “8px”
}, {
“elementId” : “f4e48d75-ea18-4c56-a740-7b3c6d46be78”,
“elementType” : “VISUAL”,
“width” : “412px”,
“height” : “784px”,
“visibility” : “VISIBLE”,
“renderingRules” : null,
“borderStyle” : null,
“selectedBorderStyle” : null,
“backgroundStyle” : null,
“loadingAnimation” : null,
“yaxisLocation” : “8px”,
“xaxisLocation” : “420px”
} ],
“canvasSizeOptions” : {
“screenCanvasSizeOptions” : {
“optimizedViewPortWidth” : “1024px”
}
}
},
“sectionBasedLayout” : null
}
} ],
“sheetControlLayouts” : [ {
“configuration” : {
“gridLayout” : {
“elements” : [ {
“elementId” : “ab3ccb77-b5a3-4219-9a03-50f7165e765b”,
“elementType” : “FILTER_CONTROL”,
“columnIndex” : null,
“columnSpan” : 2,
“rowIndex” : null,
“rowSpan” : 1
} ],
“canvasSizeOptions” : null
}
}
} ],
“contentType” : null
},

Should I add some other details for getting the objects on right place.

2

Hi @Aditjain20

Got a quick follow up. After you upload the analysis via the API, the components are left aligned until you click apply, then at which point they move to their correct positions.

Would it be possible to download after saving via the describe-analysis-definition API, then provide the new layout found in this thread. I would like to do a diff on this.

Thanks

@dgirling

3

Hi @dgirling

This is the json which I made:
{
“sheetId” : “6339b360-653b-4f1d-bae8-dff3b9af85e8”,
“title” : “Dashboard 3”,
“description” : null,
“name” : “Dashboard 3”,
“parameterControls” : null,
“filterControls” : null,
“visuals” : [ {
“tableVisual” : {
“visualId” : “9fa11dc3-5b90-4288-8c7c-7aebecb67516”,
“title” : {
“visibility” : “VISIBLE”,
“formatText” : {
“plainText” : “Dashboard 3_nav-action_1761647529943”,
“richText” : null
}
},
“subtitle” : null,
“chartConfiguration” : {
“fieldWells” : {
“tableAggregatedFieldWells” : {
“groupBy” : [ {
“numericalDimensionField” : null,
“categoricalDimensionField” : {
“fieldId” : “b0d3802f-5e8e-405a-973e-24fa5bcf823f”,
“column” : {
“dataSetIdentifier” : “BISCHEMA”,
“columnName” : “Navigate to Dashboard 3 (2)_4b9c6115-9060-4d7b-80d0-2993ab494f06”
},
“hierarchyId” : null,
“formatConfiguration” : null
},
“dateDimensionField” : null
} ],
“values” : null
},
“tableUnaggregatedFieldWells” : null
},
“sortConfiguration” : null,
“tableOptions” : null,
“totalOptions” : null,
“fieldOptions” : null,
“paginatedReportOptions” : null,
“tableInlineVisualizations” : null,
“interactions” : null
},
“conditionalFormatting” : null,
“actions” : [ {
“customActionId” : “2f951b3b-2eb3-4513-abc6-83a26efda4e3”,
“name” : “Action 25912ed5-d505-4e44-bbd6-035f79577f6b”,
“status” : “ENABLED”,
“trigger” : “DATA_POINT_CLICK”,
“actionOperations” : [ {
“filterOperation” : null,
“navigationOperation” : {
“localNavigationConfiguration” : {
“targetSheetId” : “744f815d-f007-40d3-afb2-36d0be57b920”
}
},
“setParametersOperation” : null,
“urloperation” : null
} ]
} ]
},
“pivotTableVisual” : null,
“barChartVisual” : null,
“pieChartVisual” : null,
“gaugeChartVisual” : null,
“lineChartVisual” : null,
“heatMapVisual” : null,
“treeMapVisual” : null,
“geospatialMapVisual” : null,
“filledMapVisual” : null,
“funnelChartVisual” : null,
“scatterPlotVisual” : null,
“comboChartVisual” : null,
“boxPlotVisual” : null,
“waterfallVisual” : null,
“histogramVisual” : null,
“wordCloudVisual” : null,
“insightVisual” : null,
“sankeyDiagramVisual” : null,
“customContentVisual” : null,
“emptyVisual” : null,
“radarChartVisual” : null,
“kpivisual” : null
}, {
“tableVisual” : null,
“pivotTableVisual” : null,
“barChartVisual” : {
“visualId” : “899ead3a-ec8b-44b6-85da-28acbe303ba0”,
“title” : {
“visibility” : “VISIBLE”,
“formatText” : {
“plainText” : “Sheet_6”,
“richText” : null
}
},
“subtitle” : null,
“chartConfiguration” : {
“fieldWells” : {
“barChartAggregatedFieldWells” : {
“category” : [ {
“numericalDimensionField” : null,
“categoricalDimensionField” : {
“fieldId” : “5c892555-5f4b-43bc-bce4-db86a4bfc6f8”,
“column” : {
“dataSetIdentifier” : “BISCHEMA”,
“columnName” : “Currency”
},
“hierarchyId” : null,
“formatConfiguration” : null
},
“dateDimensionField” : null
} ],
“values” : [ {
“numericalMeasureField” : {
“fieldId” : “c62abd5e-4d2a-4fac-acb6-40497474184b”,
“column” : {
“dataSetIdentifier” : “BISCHEMA”,
“columnName” : “Revenue”
},
“aggregationFunction” : {
“simpleNumericalAggregation” : “SUM”,
“percentileAggregation” : null
},
“formatConfiguration” : null
},
“categoricalMeasureField” : null,
“dateMeasureField” : null,
“calculatedMeasureField” : null
} ],
“colors” : null,
“smallMultiples” : null
}
},
“sortConfiguration” : null,
“orientation” : “VERTICAL”,
“barsArrangement” : “CLUSTERED”,
“visualPalette” : null,
“smallMultiplesOptions” : null,
“categoryAxis” : null,
“categoryLabelOptions” : null,
“valueAxis” : null,
“valueLabelOptions” : null,
“colorLabelOptions” : null,
“legend” : {
“visibility” : “VISIBLE”,
“title” : null,
“position” : null,
“width” : null,
“height” : null
},
“dataLabels” : {
“visibility” : “VISIBLE”,
“categoryLabelVisibility” : null,
“measureLabelVisibility” : null,
“dataLabelTypes” : null,
“position” : null,
“labelContent” : null,
“labelFontConfiguration” : null,
“labelColor” : null,
“overlap” : “DISABLE_OVERLAP”,
“totalsVisibility” : null
},
“tooltip” : null,
“referenceLines” : null,
“contributionAnalysisDefaults” : null,
“interactions” : null
},
“actions” : null,
“columnHierarchies” : null
},
“pieChartVisual” : null,
“gaugeChartVisual” : null,
“lineChartVisual” : null,
“heatMapVisual” : null,
“treeMapVisual” : null,
“geospatialMapVisual” : null,
“filledMapVisual” : null,
“funnelChartVisual” : null,
“scatterPlotVisual” : null,
“comboChartVisual” : null,
“boxPlotVisual” : null,
“waterfallVisual” : null,
“histogramVisual” : null,
“wordCloudVisual” : null,
“insightVisual” : null,
“sankeyDiagramVisual” : null,
“customContentVisual” : null,
“emptyVisual” : null,
“radarChartVisual” : null,
“kpivisual” : null
} ],
“textBoxes” : null,
“layouts” : [ {
“configuration” : {
“gridLayout” : null,
“freeFormLayout” : {
“elements” : [ {
“elementId” : “899ead3a-ec8b-44b6-85da-28acbe303ba0”,
“elementType” : “VISUAL”,
“width” : “692px”,
“height” : “448px”,
“visibility” : “VISIBLE”,
“renderingRules” : null,
“borderStyle” : null,
“selectedBorderStyle” : null,
“backgroundStyle” : null,
“loadingAnimation” : null,
“yaxisLocation” : “118px”,
“xaxisLocation” : “129px”
} ],
“canvasSizeOptions” : {
“screenCanvasSizeOptions” : {
“optimizedViewPortWidth” : “1024px”
}
}
},
“sectionBasedLayout” : null
}
} ],
“sheetControlLayouts” : null,
“contentType” : null
},

This is the json which I got from Quicksight describe API:
{
“sheetId” : “6339b360-653b-4f1d-bae8-dff3b9af85e8”,
“title” : “Dashboard 3”,
“description” : null,
“name” : “Dashboard 3”,
“parameterControls” : null,
“filterControls” : null,
“visuals” : [ “java.util.ArrayList”, [ {
“tableVisual” : {
“visualId” : “9fa11dc3-5b90-4288-8c7c-7aebecb67516”,
“title” : {
“visibility” : “VISIBLE”,
“formatText” : {
“plainText” : “Dashboard 3_nav-action_1761647529943”,
“richText” : null
}
},
“subtitle” : {
“visibility” : “VISIBLE”,
“formatText” : null
},
“chartConfiguration” : {
“fieldWells” : {
“tableAggregatedFieldWells” : {
“groupBy” : [ “java.util.ArrayList”, [ {
“numericalDimensionField” : null,
“categoricalDimensionField” : {
“fieldId” : “b0d3802f-5e8e-405a-973e-24fa5bcf823f”,
“column” : {
“dataSetIdentifier” : “BISCHEMA”,
“columnName” : “Navigate to Dashboard 3 (2)_4b9c6115-9060-4d7b-80d0-2993ab494f06”
},
“hierarchyId” : null,
“formatConfiguration” : null
},
“dateDimensionField” : null
} ] ],
“values” : [ “java.util.ArrayList”, ]
},
“tableUnaggregatedFieldWells” : null
},
“sortConfiguration” : {
“rowSort” : null,
“paginationConfiguration” : null
},
“tableOptions” : null,
“totalOptions” : null,
“fieldOptions” : null,
“paginatedReportOptions” : null,
“tableInlineVisualizations” : null,
“interactions” : null
},
“conditionalFormatting” : null,
“actions” : [ “java.util.ArrayList”, [ {
“customActionId” : “2f951b3b-2eb3-4513-abc6-83a26efda4e3”,
“name” : “Action 25912ed5-d505-4e44-bbd6-035f79577f6b”,
“status” : “ENABLED”,
“trigger” : “DATA_POINT_CLICK”,
“actionOperations” : [ “java.util.ArrayList”, [ {
“filterOperation” : null,
“navigationOperation” : {
“localNavigationConfiguration” : {
“targetSheetId” : “744f815d-f007-40d3-afb2-36d0be57b920”
}
},
“setParametersOperation” : null,
“urloperation” : null
} ] ]
} ] ]
},
“pivotTableVisual” : null,
“barChartVisual” : null,
“pieChartVisual” : null,
“gaugeChartVisual” : null,
“lineChartVisual” : null,
“heatMapVisual” : null,
“treeMapVisual” : null,
“geospatialMapVisual” : null,
“filledMapVisual” : null,
“funnelChartVisual” : null,
“scatterPlotVisual” : null,
“comboChartVisual” : null,
“boxPlotVisual” : null,
“waterfallVisual” : null,
“histogramVisual” : null,
“wordCloudVisual” : null,
“insightVisual” : null,
“sankeyDiagramVisual” : null,
“customContentVisual” : null,
“emptyVisual” : null,
“radarChartVisual” : null,
“kpivisual” : null
}, {
“tableVisual” : null,
“pivotTableVisual” : null,
“barChartVisual” : {
“visualId” : “899ead3a-ec8b-44b6-85da-28acbe303ba0”,
“title” : {
“visibility” : “VISIBLE”,
“formatText” : {
“plainText” : “Sheet_6”,
“richText” : null
}
},
“subtitle” : {
“visibility” : “VISIBLE”,
“formatText” : null
},
“chartConfiguration” : {
“fieldWells” : {
“barChartAggregatedFieldWells” : {
“category” : [ “java.util.ArrayList”, [ {
“numericalDimensionField” : null,
“categoricalDimensionField” : {
“fieldId” : “5c892555-5f4b-43bc-bce4-db86a4bfc6f8”,
“column” : {
“dataSetIdentifier” : “BISCHEMA”,
“columnName” : “Currency”
},
“hierarchyId” : null,
“formatConfiguration” : null
},
“dateDimensionField” : null
} ] ],
“values” : [ “java.util.ArrayList”, [ {
“numericalMeasureField” : {
“fieldId” : “c62abd5e-4d2a-4fac-acb6-40497474184b”,
“column” : {
“dataSetIdentifier” : “BISCHEMA”,
“columnName” : “Revenue”
},
“aggregationFunction” : {
“simpleNumericalAggregation” : “SUM”,
“percentileAggregation” : null
},
“formatConfiguration” : null
},
“categoricalMeasureField” : null,
“dateMeasureField” : null,
“calculatedMeasureField” : null
} ] ],
“colors” : [ “java.util.ArrayList”, ],
“smallMultiples” : null
}
},
“sortConfiguration” : {
“categorySort” : null,
“categoryItemsLimit” : null,
“colorSort” : null,
“colorItemsLimit” : null,
“smallMultiplesSort” : null,
“smallMultiplesLimitConfiguration” : null
},
“orientation” : “VERTICAL”,
“barsArrangement” : “CLUSTERED”,
“visualPalette” : null,
“smallMultiplesOptions” : null,
“categoryAxis” : null,
“categoryLabelOptions” : null,
“valueAxis” : null,
“valueLabelOptions” : null,
“colorLabelOptions” : null,
“legend” : {
“visibility” : “VISIBLE”,
“title” : null,
“position” : null,
“width” : null,
“height” : null
},
“dataLabels” : {
“visibility” : “VISIBLE”,
“categoryLabelVisibility” : null,
“measureLabelVisibility” : null,
“dataLabelTypes” : null,
“position” : null,
“labelContent” : null,
“labelFontConfiguration” : null,
“labelColor” : null,
“overlap” : “DISABLE_OVERLAP”,
“totalsVisibility” : null
},
“tooltip” : null,
“referenceLines” : null,
“contributionAnalysisDefaults” : null,
“interactions” : null
},
“actions” : [ “java.util.ArrayList”, ],
“columnHierarchies” : [ “java.util.ArrayList”, ]
},
“pieChartVisual” : null,
“gaugeChartVisual” : null,
“lineChartVisual” : null,
“heatMapVisual” : null,
“treeMapVisual” : null,
“geospatialMapVisual” : null,
“filledMapVisual” : null,
“funnelChartVisual” : null,
“scatterPlotVisual” : null,
“comboChartVisual” : null,
“boxPlotVisual” : null,
“waterfallVisual” : null,
“histogramVisual” : null,
“wordCloudVisual” : null,
“insightVisual” : null,
“sankeyDiagramVisual” : null,
“customContentVisual” : null,
“emptyVisual” : null,
“radarChartVisual” : null,
“kpivisual” : null
} ] ],
“textBoxes” : null,
“layouts” : [ “java.util.ArrayList”, [ {
“configuration” : {
“gridLayout” : null,
“freeFormLayout” : {
“elements” : [ “java.util.ArrayList”, [ {
“elementId” : “899ead3a-ec8b-44b6-85da-28acbe303ba0”,
“elementType” : “VISUAL”,
“width” : “692px”,
“height” : “448px”,
“visibility” : “VISIBLE”,
“renderingRules” : null,
“borderStyle” : null,
“selectedBorderStyle” : null,
“backgroundStyle” : null,
“loadingAnimation” : null,
“yaxisLocation” : “118px”,
“xaxisLocation” : “129px”
}, {
“elementId” : “9fa11dc3-5b90-4288-8c7c-7aebecb67516”,
“elementType” : “VISUAL”,
“width” : “800px”,
“height” : “496px”,
“visibility” : “VISIBLE”,
“renderingRules” : null,
“borderStyle” : null,
“selectedBorderStyle” : null,
“backgroundStyle” : null,
“loadingAnimation” : null,
“yaxisLocation” : “624px”,
“xaxisLocation” : “96px”
} ] ],
“canvasSizeOptions” : {
“screenCanvasSizeOptions” : {
“optimizedViewPortWidth” : “1024px”
}
}
},
“sectionBasedLayout” : null
}
} ] ],
“sheetControlLayouts” : null,
“contentType” : “INTERACTIVE”
},

4

Hi @Aditjain20,

Following up here as it’s been awhile since last communication took place on this thread; are you still working on this topic or were you able to find a work around in the interim?

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you

5

Hi @Aditjain20,

Since we have not heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community.

Thank you