Hotspots in AQX allows for a visual colour overlay to be added to a report to quickly show the high and low data points (or hotspots0 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.

A hotspot can be applied to any data type.

How to Apply Hotspots

Hotspots are added into a report by:

1. Right click in the report grid and select Edit Hotspots from the menu list
2. A Hotspots dialog box will open as shown below. In the top half of the window are the hotspot options available. The bottom half of the window displays any hotspot options you have selected
   
   
   
   Click to Enlarge
3. First select between creating a hotspot based on percentage value (e.g. highlight top 10% of spots) or an actual value (e.g. show spots above $1,000,000) by clicking on the radio button beside your Percentage or Value
4. From the first drop down box select the data type this hotspot is to apply to.
5. In the From and To box  - either enter the From and To value manually  - OR - drop down the window to select Minimum &/or Maximum.
6. In Apply to  -select how you want the hotspot to be displayed. The choices are to colour the Background of the cell, the Text of the cell or the Border of the cell. 
7. A default colour range of white through to red will be displayed in these Apply to boxes and in the Preview bar below. If you wish to change the colour scheme - drop down each Apply To box and select 'Colour Select...'. This will allow you to select your own colour scheme which will then be displayed in the Preview box. To select a colour click on it and hit OK.
8. Next you need to decide if you want your hotspots range to apply universally across the whole grid (Hotspots - Universe) - OR - apply a hotspot range in each row (Hotspots - apply across each row)  - OR - apply a hotspot range in each column (Hotspots - Apply across each Column) by clicking on the appropriate radio button.
9. Click the Add button. This will display the hotspot selection criteria in the bottom half of the window.
10. Repeat steps 3 - 9 for any other hotspot options as required - for instance you may want one across rows in red and across columns in green.
11. Then Click OK.

 

Other Hotspot Options available:

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

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

For example - if I had chosen to show background colour for the minimum to maximum percentage to apply across columns it may look something like this:

Show Single Highest Value - This will highlight only one cell - the one with the single highest value.

Show Single Lowest Value - This will highlight only one cell - the one with the single lowest value.

 

Editing and Deleting Hotspots

You an edit an existing hotspot or delete it from the report.

Edit a Hotspot

1. Right click on the grid and select Edit Hotspots from the menu
2. Double click on the hotspot you wish to edit from the list of hotspots displayed in the bottom half of the window. This will enter that hotspots details in the windows above
3. Make changes as required
4. Click on the Apply button.
5. Click OK to exit the window

 

Delete a Hotspot

1. Right click on the grid and select Edit Hotspots from the menu
2. Click on the hotspot you wish to edit from the list of hotspots displayed in the bottom half of the window so that it is highlighted.
3. Click on the Delete button in the bottom left hand corner.
4. Click OK to exit the window

 

 

 

See Also