Hotspots and Highlights is one of the many features of eTAM XTC. 

 

Hotspots

Hotspots in eTAM XTC allows for a visual colour overlay to be added to a Report to quickly show the high and low data points (or hotspots) in the grid.  Hotspots can be applied using a percentage value or an actual value.  They can be set up according to a number of criteria and displayed in different ways.

How to Apply Hotspots

Hotspots is located at in the layout assets under 'Decorations'.  You can double click from the layout assets which will apply hotspots to the report grid. 

To edit the hotspots:

1. Right Click on either the report grid or on the "Hotspots" in the Layout Assets and select Edit Hotspots
2. The Hotspots dialog box will appear.  In the top half of the window are the available hotspots options.  The bottom half of the window is any hotspots options you have already created.
3. First select between creating a hotspots based on  Percentage or Value
4. Using the drop down menu, select what data type you want to apply this Hotspots to (Projections, reach etc).
5. In the From and To box, either enter the the values required or use the drop down menu to select minimum and/or maximum
6. In Apply to  -select how you want the hotspots to be displayed. The choices are to colour the Background of the cell, the Text of the cell or the Border of the cell.  A default colour range of white to red will be displayed in these Apply to boxes  and in the Preview bar below.  To change the colour scheme - drop down each Apply to box and select "Colour Select".  Select from the available Basic colours or create your own using the "Define Custom Colours". To select a colour hit OK.
7. Next you need to decide if you want your hotspots range to apply universally across the whole grid (Hotspots - Universe) - OR - apply a hotspots range in each row (Hotspots - apply across each row)  - OR - apply a hotspots range in each column (Hotspots - Apply across each Column) by clicking on the appropriate radio button.
8. Click the Add button.  This will display display the hotspots section criteria in the bottom half of the window.
9. Repeat steps 3-8 for additional other hotspots options as required.
10. Click OK

 

 

Other Hotspots Options available:

There are 3 options also available in the Hotspots dialog box available.

Show Data Bars - graphical proportions the background colour based on the value rather than highlight the whole cell.

Show Single Highest Value - This will highlight the single highest value

Show Single Lowest Value - This will highlight the single highest value

 

Editing and Deleting Hotspots

To edit or delete an existing hotspots:

1. Right Click on the grid and select Edit hotspots from the menu

2. Double click on the hotspots you wish to edit from the list of hotspots displayed in the bottom half of the window

3. Make changes as required or DELETE

4. Click on the Apply button

5. Click OK to exit the window

 

Highlights

eTAM XTC allows users to select any item/s in almost any selection tab to be highlighted in the report layout for easier tracking.  This item (and its related sub-items) will be highlighted in a colour specified by the user.  Multiple items and colours can be can be highlighted in the one report if required.  The only tabs that does not allow for highlights are Day Parts

 

How to select an item to be highlighted

At the Media, Period, Program, Data Type and Options you can select items to be highlighted.  At the bottom of the selected pane within these tabs you will see a grey box with "Highlights - Add Here".

To add the items:

1. If your item is in the selected pane - DRAG the item into the "Highlights - Add Here" box
2. If your on the selection windows, right click on the item and select "Add to highlights"

To change the colours:

1. Right click on the an item in the Highlights - Add here box - and select Adjust colour
2. Select from the available basic colours or use the the 'Define Custom Colours' Tool.
3. Click OK to exit

Once you have made your highlights options, run your report to see the highlights to take effect.