Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Line Graph Help

 

I'm trying to create a single line graph that plots each of these values but I'm struggling to figure out how.

 

Also how would I create a line graphy for say just 'CSAT Score'?

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    I'd suggest you need to bring the data in and then "Unpivot" the data within the "Edit Queries" section.  This should leave you with  description, date, and value columns.

     

    Next you need to put the values into the "Values" area of the graph with the dates fields in the "Axis" area of the graph.  Lastly, you can filter the visual to only display rows that contain "CSAT Score" in the description column.

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Microsoft Employee
    9 years ago

    Hi Anonymous,

     

    Have you tried the solution provided by Anonymous above? Does it work in your scenario? If it works, could you accept it as solution to close this thread?

     

    If you still have any question on this issue, feel free to post here. :smileyhappy:

     

    Regards