Mapping

Mapping

The second group give examples of how data can be mapped.

Mapping defines how the data is to be filtered and transformed to the nodes in a Daisy Chart. Up to ten mapping fields can be used at any one time, with each being mapped according to a mapping type and a format.

Mapping Fields are the fields to be mapped, chosen from the database. In our example database, these could be Date, Jockey, Going etc.

Mapping Types decide the form of the data and are date, time, numeric and text. Data other than text is checked that it is of the appropriate type.

Mapping Formats are applied to each field to change the data to the correct form for mapping. Typical formats are Month-Year, Integer and Last Word. But there are many, many others.

Note that all the Daisy Charts in this group are defined by the drawing template files, daisyt1?.dyt.

B1 - Best 30 Owners (daisyt11.dyt)
B2 - Trainers and Months (daisy12.dyt)
B3 - Owners and Prize Money (daisy13.dyt)
B4 - Day of Week and Hour (daisyt14.dyt)

Adding and Deleting Mapping Fields

Note that these notes have been derived from the notes supplied with the Daisy Tutorial and also include various exercises that you can try.

It is recommended that you print the file and use it for guidance, as you go through the example templates, that are used by the Daisy Tutorial.

See the other groups of templates for the Daisy Tutorial, Jockeys, Owners and Trainers, Aggregation and Duplicates and Summaries.

B1 - Best 30 Owners (daisyt11.dyt)

This simple Daisy Chart, just maps the Owners in a circle.

Only one mapping field has been set. Owners are mapped with both a mapping type and format of Text. The order of the nodes has been set, so that they are drawn in decreasing order of Total Won. (If you want to change this order, use Opts in Mapping Fields in the Draw Chart dialog box.)

Even Daisy Charts as simple as this, make the understanding of data much easier.

Tip - It is often a good idea to do simple trial mappings of this nature with just a single mapping field to get a feel for the number of values contained in a particular field.

B2 - Trainers and Months (daisy12.dyt)

This simple Daisy Chart, just maps the Trainers and Months.

Daisy Charts of this type, can be used to see if there are any connection between different fields in a database. For instance, do some Trainers do better in the spring?

B3 - Owners and Prize Money (daisy13.dyt)

This simple Daisy Chart, just maps the Owners and Prize Money.

Note how the Prize Money is mapped with a numeric field, using a partition format. This is a very powerful mapping.

Daisy Charts of this type, can be used to see if there are any connection between different fields in a database.

Ex. 16 - Changing the Mapping

The mapping is changed using the Mapping Fields command in the Draw Chart dialog box.

Use the ? command button to find out more about choosing mapping fields.

Add new mapping fields using the Add button in the Mapping Fields frame. This is the recommended way and adds a new mapping field in a simple step-by-step manner.

B4 - Day of Week and Hour (daisyt14.dyt)

This simple Daisy Chart, just maps the database by Day of the Week and Hours.

This is not the best mapping for this database. It has been included here, as for many databases, this method of mapping will show, if any patterns in the data are date/time related.

Adding and Deleting Mapping Fields

Return to the A4 Daisy Chart to do the next two exercises.

Ex. 17 - Adding a Mapping Field

Additional mapping fields are added using Add button in the Mapping Fields frame in the Draw Chart dialog box.

Alternatively, you can add an extra mapping field, in the Mapping Fields dialog called by Setup. Here, we will add an extra mapping field, which analyses the database against months.

Once in the Mapping Fields dialog if you have loaded the A4 Daisy Chart, you will see the mapping fields, Jockey, Trainer and Owner. Click the pull down list numbered 4, under Fields to show the fields in the database that can be mapped. Select the field, Date. This is the name of the field in the original database.

Click on the pull down list under Type to select the mapping type to be used. Select Date, as we are mapping the data as a date.

Click under Format and select a mapping format of Month-Year.

Lastly, click on Opts, to set up the sort order of the mapping fields and any other parameters needed. Select Year-Month and click Ascending, as we want to map the dates in date order. (Note the two orders, Year-Month and Month-Year, the first puts the dates in year order, whilst the second puts all Jan, Feb, Mar etc. together.)

After returning to the main Draw Chart dialog box, by using OK, use Draw to redraw the Daisy Chart with this extra mapping field.

Ex. 18 - Deleting a Mapping Field

Mapping fields are deleted using the Mapping Fields command in the Draw Chart dialog box.

Choose the mapping field to be deleted and then select the blank field at the top of the pull down list to actually delete the field.

Note that Daisy does not mind spaces in the list.

Try deleting the mapping field, Owner, and redraw the Daisy Chart.