cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

Data Format - Line Graph

Evening all,

I'm trying to import some data around our weekly CSAT perforamance

 

CSAT1.PNG

 

I need to group the 'Excellent' and 'Good' responses then calculate their percetage against total no of responses.

 

I then need to create a line graph which shows progress from week to week (maximum of 5 weeks showing).

 

Any help is very much appreciated.

3 REPLIES 3

Re: Data Format - Line Graph

Actually it's probably a good idea to show you what I have so far and explain some of the troubles I'm having as a newbie.

 

R.png

 

Problem 1

 

The gauge is showing as 0.84 instead of 84%.

 

Problem 2

 

Bottom left chart I want to be the line graph discussed above.

 

Problem 3

 

Under the total number of responses card I want a kpi indicator arrow (red, green) to show the trend from last week.

 

Problem 4

 

Bottom right graph I want to be show as stacked bar chart.

 

I want this to show the service that our customers where feeding back against (broken down by negative, positive). The problem is this service is in a seperate data source so I need to match the reference column in datasource1 to the reference in datasource2 and pull ou the service.

 

Problem 5

 

I need to drop in new data each week without having to manually go through and amend these reports.

 

 

 

I'm learning this stuff slowly but I'm in such a rush for these reports I may have to pay to have them developed.

Super User
Super User

Re: Data Format - Line Graph

@johnbradbury

 

Problem 1

 

The gauge is showing as 0.84 instead of 84%.

 

porcent.gif

 

 




Lima - Peru
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




v-huizhn-msft Super Contributor
Super Contributor

Re: Data Format - Line Graph

Hi @johnbradbury,

The screenshot you post on the original thread is your resource data? I really understand you are urgent for these reports. While I am unable to reproduce your scenario without sample data table. You'd better post your sample data.

In addition, the second screenshot is what you want or you have done what like that? It's confusing.

Thanks,
Angelia