|
Custom Visuals can develop applications to
help you examine data you've collected from a
variety of sources. The following screen captures
show the main portions of an application that
correlates sales information with ongoing promotions.
The original data was provided as text files generated
from a logging application, and as a FileMaker
Pro database application. Utilities were created
to convert the text and FileMaker files into MySQL
database tables. Perl programs were created to
extract the data from the database and plot the
graphs and generate the HTML data below.
|
|
This is the main control area of the application.
The operator selects from a list of ID's and specifies
a Start and End date. All of the information is read
from the data files and used to build the menues.
This helps prevent the operator from selecting dates
outside of the useable timeframe. When the parameters
are selected, the operator presses the Submit button.
|
|
(Select image for full size view) The result is displayed
as a graphic in a section of the web page. The graphics
are fully programmable for such things as tick marks,
colors, data points and connecting lines. The information
for the position under the cursor is presented in
a popup box. The data can also be presented in other
formats, such as pie, bar, area and several other
standard business types.
|
|
The result is also displayed in an HTML table in a
section of the web page. The table provides both an
overview of the total sales for the week, as well
as a detailed view for the week showing the date,
time and amount of each transaction. The Promotional,
Awareness and Other tables were not filled in on a
regular basis at the time this snapshot was taken.
|
|
