Forum Discussion
Solved
Graph based on values in different columns
I have a data table with columns of data for each different month. And I need to get a graph showing the evolution of the Values in time, showng the average value of the corresponding co...
Hi dbalaciano,
In your scenario, you can use the Unpivot Columns options under Query Editor > Transform tab to get a Month column and a Value column. :smileyhappy:
In the Query Editor
1) select the all the month(JAN, FEB, etc) Columns.
2) Transform tab - Unpivot Columns
3) Rename the Attribute and Values columns - Month and Percentage.
Regards
Hi dbalaciano,
In your scenario, you can use the Unpivot Columns options under Query Editor > Transform tab to get a Month column and a Value column. :smileyhappy:
In the Query Editor
1) select the all the month(JAN, FEB, etc) Columns.
2) Transform tab - Unpivot Columns
3) Rename the Attribute and Values columns - Month and Percentage.
Regards
That worked perfectly!
Thank you for your help.