Forum Discussion

dbalaciano's avatar
dbalaciano
Regular Visitor
9 years ago
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...
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thanks for your help with the other solutions, but I can't make it work with that because I have all 12 months but my list of projects tends to infinity. The values for each month are in different columns. Below is a simplification of my data structure and the graph I need to obtain showing the sum per group each month. Please ignore the blue line. 

When I use the solution proposed above of selecting all months and clicking on unpivot (mi data is being extracted from a live shepoint list), it says "error" on every cell of the columns. 


Is there any other solution? 

 

 

 

 



Regards,