I would like to produce a graph that shows the percentage of total observations (code_7), over the years (ano), and regulatory (regime), as percentages of the total observations.
Here is an example of my dataset:
| code_7 | regime | ano |
| 1100023 | 1 | 2007 |
| 1100023 | 0 | 2008 |
| 1100023 | 0 | 2009 |
| 1100023 | 0 | 2010 |
| 1100023 | 0 | 2011 |
| 1100023 | 0 | 2012 |
| 1100023 | 0 | 2013 |
| 1100023 | 0 | 2014 |
| 1100023 | 0 | 2015 |
| 1100023 | 2 | 2016 |
| 1100031 | 0 | 2007 |
| 1100031 | 0 | 2008 |
| 1100031 | 0 | 2009 |
| 1100031 | 0 | 2010 |
| 1100031 | 0 | 2011 |
| 1100031 | 0 | 2012 |
| 1100031 | 0 | 2013 |
| 1100031 | 0 | 2014 |
| 1100031 | 0 | 2015 |
| 1100031 | 2 | 2016 |
| 1100031 | 2 | 2017 |
| 1100031 | 2 | 2018 |
| 1100031 | 2 | 2019 |
| 1100056 | 0 | 2007 |
| 1100056 | 0 | 2008 |
| 1100056 | 0 | 2009 |
| 1100056 | 0 | 2010 |
| 1100056 | 0 | 2011 |
| 1100056 | 0 | 2012 |
| 1100056 | 0 | 2013 |
| 1100056 | 0 | 2014 |
| 1100056 | 0 | 2015 |
| 1100056 | 2 | 2016 |
| 1100056 | 2 | 2017 |
| 1100056 | 2 | 2018 |
| 1100056 | 2 | 2019 |
| 1100064 | 0 | 2007 |
| 1100064 | 0 | 2008 |
| 1100064 | 0 | 2009 |
| 1100064 | 0 | 2010 |
| 1100064 | 0 | 2011 |
| 1100064 | 0 | 2012 |
| 1100064 | 0 | 2013 |
| 1100064 | 0 | 2014 |
| 1100064 | 0 | 2015 |
| 1100064 | 2 | 2016 |
| 1100064 | 2 | 2017 |
| 1100064 | 2 | 2018 |
| 1100064 | 2 | 2019 |
| 1100072 | 0 | 2007 |
| 1100072 | 0 | 2008 |
| 1100072 | 0 | 2009 |
| 1100072 | 0 | 2010 |
| 1100072 | 0 | 2011 |
| 1100072 | 0 | 2012 |
| 1100072 | 0 | 2013 |
| 1100072 | 0 | 2014 |
| 1100072 | 0 | 2015 |
| 1100072 | 2 | 2016 |
| 1100072 | 2 | 2017 |
| 1100072 | 2 | 2018 |
| 1100072 | 2 | 2019 |
| 1100080 | 0 | 2007 |
| 1100080 | 0 | 2008 |
| 1100080 | 0 | 2009 |
Array
0 Response to Stacked bar graph: percentage of total observations, by groups
Post a Comment