In Scatter plot visual drill down layer is not generation when i am uploading the analysis JSON

Question & Answer
,
1

The below is my generated JSON

{
“awsAccountId” : “${AWS_ACCOUNT_ID}”,
“analysisId” : “ScatterPlot”,
“name” : “ScatterPlot”,
“parameters” : null,
“permissions” : [ {
“principal” : “arn:aws:quicksight:${REGION}:${AWS_ACCOUNT_ID}:user/default/${PRINCIPAL_USERNAME}”,
“actions” : [ “quicksight:RestoreAnalysis”, “quicksight:UpdateAnalysisPermissions”, “quicksight:DeleteAnalysis”, “quicksight:DescribeAnalysisPermissions”, “quicksight:QueryAnalysis”, “quicksight:DescribeAnalysis”, “quicksight:UpdateAnalysis” ]
} ],
“sourceEntity” : null,
“themeArn” : null,
“tags” : null,
“definition” : {
“dataSetIdentifierDeclarations” : [ {
“identifier” : “BISCHEMA_7LT_Star_Snow_VJ”,
“dataSetArn” : “${DATASET_ARN}”
} ],
“sheets” : [ {
“sheetId” : “1f707b64-4075-45ff-a4d1-34df04e991b0”,
“title” : “Dashboard 1”,
“description” : null,
“name” : “Dashboard 1”,
“parameterControls” : null,
“filterControls” : null,
“visuals” : [ {
“tableVisual” : null,
“pivotTableVisual” : null,
“barChartVisual” : null,
“pieChartVisual” : null,
“gaugeChartVisual” : null,
“lineChartVisual” : null,
“heatMapVisual” : null,
“treeMapVisual” : null,
“geospatialMapVisual” : null,
“filledMapVisual” : null,
“funnelChartVisual” : null,
“scatterPlotVisual” : {
“visualId” : “e00e4984-4932-4bce-ae6b-522ee0c596b4”,
“title” : {
“visibility” : “VISIBLE”,
“formatText” : {
“plainText” : “scateerplot_4”,
“richText” : null
}
},
“subtitle” : null,
“chartConfiguration” : {
“fieldWells” : {
“scatterPlotCategoricallyAggregatedFieldWells” : {
“category” : null,
“size” : [ {
“numericalMeasureField” : {
“fieldId” : “a8c58199-c417-461e-a3ec-7d0b07edaa43”,
“column” : {
“dataSetIdentifier” : “BISCHEMA_7LT_Star_Snow_VJ”,
“columnName” : “Revenue”
},
“aggregationFunction” : {
“simpleNumericalAggregation” : “SUM”,
“percentileAggregation” : null
},
“formatConfiguration” : null
},
“categoricalMeasureField” : null,
“dateMeasureField” : null,
“calculatedMeasureField” : null
} ],
“label” : [ {
“numericalDimensionField” : {
“fieldId” : “6d338d4f-984a-4888-8f11-6a9857b19452”,
“column” : {
“dataSetIdentifier” : “BISCHEMA_7LT_Star_Snow_VJ”,
“columnName” : “Prod Key (Samp Products D)”
},
“hierarchyId” : “70e9aad0-4c20-4d44-bf47-d20aea075f84”,
“formatConfiguration” : null
},
“categoricalDimensionField” : null,
“dateDimensionField” : null
} ],
“yaxis” : [ {
“numericalMeasureField” : {
“fieldId” : “0396c6ad-2fc8-4c09-8cef-01603e3ba8dd”,
“column” : {
“dataSetIdentifier” : “BISCHEMA_7LT_Star_Snow_VJ”,
“columnName” : “Discnt Rate”
},
“aggregationFunction” : {
“simpleNumericalAggregation” : “SUM”,
“percentileAggregation” : null
},
“formatConfiguration” : null
},
“categoricalMeasureField” : null,
“dateMeasureField” : null,
“calculatedMeasureField” : null
} ],
“xaxis” : [ {
“numericalMeasureField” : {
“fieldId” : “e7e87c21-cf1d-4eb4-b4be-203b8cfed749”,
“column” : {
“dataSetIdentifier” : “BISCHEMA_7LT_Star_Snow_VJ”,
“columnName” : “Discnt Value”
},
“aggregationFunction” : {
“simpleNumericalAggregation” : “SUM”,
“percentileAggregation” : null
},
“formatConfiguration” : null
},
“categoricalMeasureField” : null,
“dateMeasureField” : null,
“calculatedMeasureField” : null
} ]
},
“scatterPlotUnaggregatedFieldWells” : null
},
“sortConfiguration” : 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,
“visualPalette” : null,
“interactions” : null,
“xaxisLabelOptions” : null,
“xaxisDisplayOptions” : null,
“yaxisLabelOptions” : null,
“yaxisDisplayOptions” : null
},
“actions” : null,
“columnHierarchies” : [ {
“explicitHierarchy” : {
“hierarchyId” : “70e9aad0-4c20-4d44-bf47-d20aea075f84”,
“columns” : [ {
“dataSetIdentifier” : “BISCHEMA_7LT_Star_Snow_VJ”,
“columnName” : “Prod Key (Samp Products D)”
}, {
“dataSetIdentifier” : “BISCHEMA_7LT_Star_Snow_VJ”,
“columnName” : “LOB”
}, {
“dataSetIdentifier” : “BISCHEMA_7LT_Star_Snow_VJ”,
“columnName” : “Brand Key”
} ],
“drillDownFilters” : null
},
“dateTimeHierarchy” : null,
“predefinedHierarchy” : 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” : null,
“sheetControlLayouts” : null,
“contentType” : null
} ],
“calculatedFields” : null,
“parameterDeclarations” : null,
“filterGroups” : null,
“columnConfigurations” : null,
“analysisDefaults” : null,
“options” : null
}
}

2

Hi @Gautam2211 and welcome to the QuickSight community!

Looking at your JSON, one thing sticks out to me immediately:

Additionally, there are no associated drill down filters defined in the ‘ColumnHierarchies’ section.

You would need to define the drill down hierarchy for it to generate.

I would suggest setting up your hierarchy and then defining it in your JSON and that may do the trick.

Let me know if you have any additional questions

3

Hi @Gautam2211,
Following up here as it’s been awhile since we last heard from you; did you have any additional questions regarding your initial post?

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

Thank you!

4

Hi @Gautam2211,
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 and link this discussion for relevant information if needed.

Thank you!