Use Case
The client would like to know how their regions compare in the categories of location convenience, hour convenience, and product selection. They would like to see both the regions’ scores in these areas and their ranks.
Report
Code
{|SHOWIF|OUTPUT_MODE=|EVALCONST(KNICKERS_OUTPUT_STANDARD)|}{DATATYPES.CONTROLS_START}
{DATATYPES.DEFAULT_DATE_FILTERS}
{DATATYPES.CONTROLS_END}{/|SHOWIF|}
<div class='results'>
{|VANISHIF|DATATYPES.SHOW_DATATYPE.TOTAL_COUNT}
<div class='ui-state-highlight no-data'><p>No data was found to display</p></div>
{/|VANISHIF|}
{|SHOWIF|DATATYPES.SHOW_DATATYPE.TOTAL_COUNT}
{|RESULT|}
{|LOOP|RESULT.CLIENT_49_LEVEL_3(SORT=NAME)}
{|SHOWIF|LOOP.ISFIRST}
<div>
<table class='data' id='data-table'>
<thead>
<tr>
<th id="region-header" rowspan="2">{|SORT_TOGGLE|CLIENT_49_LEVEL_3.NAME}{DATATYPES.SHOW_DATATYPE.CLIENT_49_LEVEL_3.NAME}{/|SORT_TOGGLE|}</th>
<th colspan="2">Store Convenience</th>
<th colspan="2">Hour Convenience</th>
<th colspan="2">Selection</th>
</tr>
<tr>
<th>{|SORT_TOGGLE|AVG(CLIENT_49_LEVEL_3.CLIENT_49_SURVEY_1230_QUESTION_21_SCORE)}Average{/|SORT_TOGGLE|}</th>
<th>{|SORT_TOGGLE|RANK(AVG(CLIENT_49_LEVEL_3.CLIENT_49_SURVEY_1230_QUESTION_21_SCORE),DESC,OVERALL)}Rank{/|SORT_TOGGLE|}</th>
<th>{|SORT_TOGGLE|AVG(CLIENT_49_LEVEL_3.CLIENT_49_SURVEY_1230_QUESTION_31_SCORE)}Average{/|SORT_TOGGLE|}</th>
<th>{|SORT_TOGGLE|RANK(AVG(CLIENT_49_LEVEL_3.CLIENT_49_SURVEY_1230_QUESTION_31_SCORE),DESC,OVERALL)}Rank{/|SORT_TOGGLE|}</th>
<th>{|SORT_TOGGLE|AVG(CLIENT_49_LEVEL_3.CLIENT_49_SURVEY_1230_QUESTION_51_SCORE)}Average{/|SORT_TOGGLE|}</th>
<th>{|SORT_TOGGLE|RANK(AVG(CLIENT_49_LEVEL_3.CLIENT_49_SURVEY_1230_QUESTION_51_SCORE),DESC,OVERALL)}Rank{/|SORT_TOGGLE|}</th>
</tr>
</thead>
<tbody>
{/|SHOWIF|}
<tr>
<th>{CLIENT_49_LEVEL_3.NAME}</th>
<td>{AVG(CLIENT_49_LEVEL_3.CLIENT_49_SURVEY_1230_QUESTION_21_SCORE).NUMBERFORMAT(1)}</td>
<td>{RANK(AVG(CLIENT_49_LEVEL_3.CLIENT_49_SURVEY_1230_QUESTION_21_SCORE),DESC,OVERALL)}</td>
<td>{AVG(CLIENT_49_LEVEL_3.CLIENT_49_SURVEY_1230_QUESTION_31_SCORE).NUMBERFORMAT(1)}</td>
<td>{RANK(AVG(CLIENT_49_LEVEL_3.CLIENT_49_SURVEY_1230_QUESTION_31_SCORE),DESC,OVERALL)}</td>
<td>{AVG(CLIENT_49_LEVEL_3.CLIENT_49_SURVEY_1230_QUESTION_51_SCORE).NUMBERFORMAT(1)}</td>
<td>{RANK(AVG(CLIENT_49_LEVEL_3.CLIENT_49_SURVEY_1230_QUESTION_51_SCORE),DESC,OVERALL)}</td>
</tr>
{/|LOOP|}
</tbody>
</table>
</div>
{/|RESULT|}
{/|SHOWIF|}
</div>
CSS
@import "themeroller/jquery.ui.all.css";
@import "chrome.theme.css";
@import "chrome.layout.css";
#data-table
{
width: auto;
margin: auto;
}
#data-table thead th
{
text-align: center;
}
#data-table tbody td
{
text-align: center;
}
#region-header
{
vertical-align: bottom;
}