Line Chart Visual Discrepancy between Quicksight UI and Web Service

Question & Answer
1

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 -

quicksight_ui_line_graph
quicksight_ui_line_graph1843×643 84.1 KB

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.

2

Hello @anshul1243 , welcome to the Quicksight community!

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

3

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.
@duncan

4

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.