Hi @Karthika_G
Apologies for the delayed response.
Could you please try the following approach. A practical way to infer whether a field is used as a dimension or a measure is by checking its data type.
-
Fields with type DECIMAL or INTEGER are typically used as measures
-
Fields with type STRING or DATETIME are typically used as dimensions
-
Cross-check the fields against their data types from describe_data_set.
-
Use describe_analysis to extract the FieldWells configuration for each visual.
-
Update the analysis using update_analysis, moving fields between GroupBy and Values as needed — for example, shifting text fields out of the Values section where they’re auto-aggregated as “Count”.
This method can help automate cleanup and ensure compatibility with Column Level Security rules.
Please refer the below QuickSight documentation and community post this might be helpful for you.