Solved

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

  • 9 November 2022
  • 2 replies
  • 50 views

Hello,

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

icon

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

View original

2 replies

Userlevel 3

 

This can be achieved through pivot tables using GD.UI: https://sdk.gooddata.com/gooddata-ui/docs/pivot_table_component.html  

Hello,

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

Reply