To create an insight where one column is horizontal and another column is vertical

  • 9 November 2022
  • 2 replies


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


Thank you


Best answer by Joseph Heun 9 November 2022, 21:29

View original

2 replies


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!!


Thank you

Userlevel 3


This can be achieved through pivot tables using GD.UI: