Can you please let me know how to create an insight where first column is vertical and the second column is horizontal in the good data insight.Please do find the attached image for the reference where the Year column is vertical and the Monthdiff column is horizontal
Best answer by Joseph HeunView original
i am trying to create the pivot table as suggested by
@Joseph Heun, but i am unable to sort the “Monthdiff” column using the sortby.can you please help me out in this.please do find the Home.js code in the attached notepad and the screenshot of the output generated with it!!
Ps:i was working as a SQL developer before and i have no idea about react nor Visual studio code.So, i request you to brief me a solution to sort the column and display it in gooddata!!
This can be achieved through pivot tables using GD.UI: https://sdk.gooddata.com/gooddata-ui/docs/pivot_table_component.html