Hello,
I am a bit confused how to achieve the following requirement. any assistance is appreciated.
giving the datset below I would like to see prefferably on a scatterplot chart if sales increase when we run programs.
I want to see the number of programs run in a particular year . the total sales made that year.
be able to see if the sales increased or decreased .
all in the same chart
| School |
Year |
Quarter |
Program |
sales |
| testschool |
2010 |
Q1 |
acro |
9000 |
| testschool |
2010 |
Q2 |
|
8200 |
| testschool |
2010 |
Q3 |
|
10600 |
| testschool |
2010 |
Q4 |
|
10600 |
| testschool |
2011 |
Q1 |
|
15000 |
| testschool |
2011 |
Q2 |
|
16000 |
| testschool |
2011 |
Q3 |
mar |
16100 |
| testschool |
2011 |
Q4 |
run |
18900 |
| testschool |
2012 |
Q1 |
mar |
23300 |
| testschool |
2012 |
Q2 |
mar |
38800 |
| testschool |
2012 |
Q3 |
run |
30000 |
| testschool |
2012 |
Q4 |
mar |
41000 |
| testschool |
2013 |
Q1 |
dry |
48000 |
| testschool |
2013 |
Q2 |
run |
48000 |
| testschool |
2013 |
Q3 |
acro |
47000 |
| testschool |
2013 |
Q4 |
|
90000 |
| testschool |
2014 |
Q1 |
acro |
110000 |
| testschool |
2014 |
Q2 |
|
115000 |
| testschool |
2014 |
Q3 |
run |
98000 |
| testschool |
2014 |
Q4 |
run |
120000 |
| testschool |
2015 |
Q1 |
|
130900 |
| testschool |
2015 |
Q2 |
|
145000 |
| testschool |
2015 |
Q3 |
dry |
145000 |
| testschool |
2015 |
Q4 |
|
161000 |
