Line Chart Visual Discrepancy between Quicksight UI and Web Service

Hi Team,

When I am trying to creating line chart visual from quicksight UI it allows me to add drill down (ie, hierarchy) for axis, color and small multiples but when I try to create the same use web service API it give me below error, is there something I am missing.

Error - ‘definition.sheets.1.member.visuals.9.member.lineChartVisual.columnHierarchies’ failed to satisfy constraint: Member must have length less than or equal to 2 (Service: AmazonQuickSight; Status Code: 400; Error Code: ValidationException; Request ID: cd7117dc-21e5-4188-9d0c-0780e0873abb; Proxy: null):

UI -

Please note, I have created one sample on quicksight UI, extracted json and tries to created it again using API, it give me error.

Let me know if you need any additional information.

Hello @anshul1243 , welcome to the Quicksight community!

Just to double check, have you made sure that you have all necessary permissions?:

Yes, I have the access, I have created Visual using UI and extracted the JSon and tried creating Analysis using extracted json it gives me above mention error but as soon as I remove the explicit hierarchy for any one of the components, it works.

Hey @anshul1243 !

Could you try the solution provided in this thread:

I know that it is not exactly the same but I think the issue might stem from the same place.