Exercise1

<p><strong>Chapter 6/Exercise 1</strong></p><p>In this exercise, we will build an interactive data app. We use the<em> Projects.txt </em>dataset<em>, </em>which we already know from the workflow "Advanced Dashboard" of this chapter.</p><p>After accessing the dataset, we first prepare our data for the report by calculating for each project and year:</p><ul><li><p>the <strong>money in budget</strong>,</p></li><li><p>the <strong>money actually spent</strong>, and</p></li><li><p>the <strong>money remaining</strong>.</p></li></ul><p>In the <em>Project Report</em> component, we create radio buttons that allow for changing the color palette of the <em>Bar Chart</em>.</p>