Merging of values in a single cell when creating analysis on quicksight.

[spathak1719]

Describe the bug

For a tabular report in QuickSight Analysis,

1. Can we merge values in a column into a single cell based on value? Is it possible to do the same using boto3?
2. Can we add multiple levels of column headers (2 or more) for a table?
3. Is it possible to export the analysis as an embedded URL through boto3 and change the charts/tables on the fly?
4. Once the report is published to the dashboard, we can expose it through an embedded URL but it does not give us the flexibility to change the type of visualization on the fly. Can the visualization be changed on the dashboard?

Attached image of the report we are trying to create in AWS Quicksight and the input json for creating dataset.

transformed_input_json.json

Regression Issue

• Select this option if this issue appears to be a regression.

Expected Behavior

We expect that all the reported use cases should be supported by boto3 and AWS QuickSight User Interface.

Current Behavior

All the reported use cases are not supported.

Reproduction Steps

1. Create dataset using the json shared.
2. Create an analysis with a table view as shared in the attached image.
3. Publish the analysis as a dashboard.
4. Generate embed URL for this dashboard.

Possible Solution

No response

Additional Information/Context

No response

SDK version used

boto3==1.34.131 botocore==1.34.131

Environment details (OS name and version, etc.)

Mac OS