Group Mouseover Box
The group mouseover box is located in the following div tag of the HTML – anything entered in this div tag will be displayed in the group mouseover box:
#groupMouseOverContainer .groupMouseOver
Standard HTML markup can be used to customize the look and layout of the group mouseover box.
The group mouseover box can contain dynamically-generated summary statistics of the active group. The following summary statistics can be used in the group mouseover box:
Display the active group’s title
Description: Displays the title of the active group. The title is the same text as the group header.
Value: {title}
| {title} | Must be included exactly as written, including curly braces. |
|---|
Example: <td>{title}<br>Summary Statistics</td>
Display the number of cells inside the active group
Description: Displays the count of the total number of cells inside the active group.
Value: {{count}}
| {{count}} | Must be included exactly as written, including both sets of curly braces. |
|---|
Example: <td>Total records in this group: {{count}}</td>
Attribute’s average
Description: Calculates the mean of all cells inside the active group.
Value: {{value_name}.avg}
| {value_name} | Any attribute from “CSV_DataTypes.cells” that has NUMBER properties. Outer curly braces must be included. |
|---|
Example: <td>Average Quota: ${Quota_Q4.avg}</td>
Attribute’s max
Description: Returns the maximum value among the cells contained by this group.
Value: {{value_name}.max}
| {value_name} | Any attribute from “CSV_DataTypes.cells” that has NUMBER properties. Outer curly braces must be included. |
|---|
Example: <td>Max Quota: ${Quota_Q4.max}</td>
Attribute’s median
Description: Returns the value in the middle of the cells contained by this group. E.g., of N cells, ordered from minimum to maximum, returns the value of the cell number N/2.
Value: {{value_name}.median}
| {value_name} | Any attribute from “CSV_DataTypes.cells” that has NUMBER properties. Outer curly braces must be included. |
|---|
Example: <td>Median Quota: ${Quota_Q4.median}</td>
Attribute’s min
Description: Returns the minimum value among the cells contained by this group.
Value: {{value_name}.min}
| {value_name} | Any attribute from “CSV_DataTypes.cells” that has NUMBER properties. Outer curly braces must be included. |
|---|
Example: <td>Min Quota: ${Quota_Q4.min}</td>
Attribute’s mode
Description: Returns the most frequently occurring value among the cells contained by this group. If all values are unique, the first value is returned.
Value: {{value_name}.mode}
| {value_name} | Any attribute from “CSV_DataTypes.cells” that has NUMBER properties. Outer curly braces must be included. |
|---|
Example: <td>Quota Mode: ${Quota_Q4.mode}</td>
Attribute’s standard deviation
Description: Returns the standard deviation of the values of the cells contained by this group.
Value: {{value_name}.stdev}
| {value_name} | Any attribute from “CSV_DataTypes.cells” that has NUMBER properties. Outer curly braces must be included. |
|---|
Example: <td>Total Sales Standard Deviation: ${Total_Sales_Q4.stdev}</td>
Attribute’s sum
Description: Calculates the sum of all cells inside the active group.
Value: {{value_name}.sum}
| {value_name} | Any attribute from “CSV_DataTypes.cells” that has NUMBER properties. Outer curly braces must be included. |
|---|
Example: <td>Total Sales: ${Total_Sales_Q4.sum}</td>
Attribute’s variance
Description: Returns the variance of the values of the cells contained by this group.
Value: {{value_name}.variance}
| {value_name} | Any attribute from “CSV_DataTypes.cells” that has NUMBER properties. Outer curly braces must be included. |
|---|
Example: <td>Variance of Total Sales: ${Total_Sales_Q4.variance}</td>
Sample group mouseover box:
<table cellpadding="0" width="100%">
<tr><td colspan="2">{title}<br>Summary Statistics</td></tr>
<tr><td colspan="2" class="statLabel"> </td></tr>
<tr><td>Total Sales:</td><td>${Total_Sales_Q4.sum}</td></tr>
<tr><td>Total Quota:</td><td>${Quota_Q4.sum}</td></tr>
<tr><td>Avg Quota Met:</td><td>{Quota_Percent.avg}%</td></tr>
</table>