Data Painting

 

To paint data from an Entrance chart you need a color override, as in this script:

 

  PLOT CORRELATION

      TRIANGLE, TRIANGLE, TRIANGLE, COLOR OVERRIDE

    WITH

      FRAME 20 20 400 400

  SELECT population, area, gdp, color from country;

 

Often you will add a column to serve as the color override, using either SQL ALTER or "New Column..." from the table popup menu.  

 

Then you run the query to generate a chart.  With the mouse you drag out a rectangle over points in the chart that interest you:

and paint them "red" or another color.  You are actually changing the color value of rows corresponding to points in the table.  When the chart is automatically redrawn, you see the changes:

 

Data Painting and the "Match Box"

Whichever data painting technique you used, rows in the original table are now marked with a color.  You can use the Entrance match box to filter the table for rows with that mark, as shown below:

 

 

You can quickly calculate means and medians for the marked data points using Tools | Calculate statistitics....  which limits the calculation to matching rows (as of version 0.81.3).

 
Table views update automatically when you return to a table that has changed since your last view.  Try this:  go back to the chart and paint some more points red, then return to the table.
You will see the new rows displayed automatically. 

You can easily act on the marked rows from your own SQL scripts.  For example, you can select them:

 

    SELECT name, area FROM country

        WHERE color = 'red';

 

update them:

 

   UPDATE TABLE country

        SET name = concat(name, ' **')

        WHERE color = 'red';

 

or ignore them, eg. as a way of temporarily eliminating outliers:

 

   SELECT avg(area) FROM country

        WHERE color != 'red';

 

To learn more about Entrance charts

 

 

 

Copyright (c) 2007 dbEntrance Software, All Rights Reserved