Use Case
The client would like to see a list of their mystery shops that had a cleanliness rating of “Poor” in one or more store department. They would also like to see the total cleanliness points that the shops received across all departments.
Report
Code
{|SHOWIF|OUTPUT_MODE=|EVALCONST(KNICKERS_OUTPUT_STANDARD)|}{DATATYPES.CONTROLS_START}
{DATATYPES.DEFAULT_DATE_FILTERS}
{DATATYPES.SHOW_DATATYPE.RESULT_CONTROLS.PAGING.INPUT}
{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}
<h2>Cleanliness Problems</h2>
{|RESULT|FILTERSET=CLIENT_49_SURVEY_1229_QUESTION_561_ID|eq|4;CLIENT_49_SURVEY_1229_QUESTION_541_ID|eq|4|OR;CLIENT_49_SURVEY_1229_QUESTION_551_ID|eq|4|OR}
<div>
{|LOOP|RESULT.DATAPOINTS(SORTSET=TRENDING_TIMESTAMP;CLIENT_49_LEVEL_1.NAME)}
{|SHOWIF|LOOP.ISFIRST}
<table class='data' id='data'>
<thead>
<tr>
<th>{|SORT_TOGGLE|ID}Shop ID{/|SORT_TOGGLE|}</th>
<th>{|SORT_TOGGLE|TRENDING_TIMESTAMP}Date{/|SORT_TOGGLE|}</th>
<th>{|SORT_TOGGLE|CLIENT_49_LEVEL_1.NAME}Location{/|SORT_TOGGLE|}</th>
<th>{|SORT_TOGGLE|PERCENT_SCORE}Overall Score{/|SORT_TOGGLE|}</th>
<th>Cleanliness Score</th>
<th>{|SORT_TOGGLE|CLIENT_49_SURVEY_1229_QUESTION_561.ORDER_NUM}Health and Beauty{/|SORT_TOGGLE|}</th>
<th>{|SORT_TOGGLE|CLIENT_49_SURVEY_1229_QUESTION_541.ORDER_NUM}Sporting Goods{/|SORT_TOGGLE|}</th>
<th>{|SORT_TOGGLE|CLIENT_49_SURVEY_1229_QUESTION_551.ORDER_NUM}Grocery{/|SORT_TOGGLE|}</th>
</tr>
</thead>
<tbody>
{/|SHOWIF|}
<tr>
<th>{DATAPOINTS.DATAPOINT_ID}</th>
<td>{DATAPOINTS.TRENDING_TIMESTAMP.FORMATTED(n/d/Y)}</td>
<td>{DATAPOINTS.CLIENT_49_LEVEL_1.NAME}</td>
<td class="percent-score">{DATAPOINTS.PERCENT_SCORE}</td>
<td class="cleanliness-score">{CALC(DATAPOINTS.CLIENT_49_SURVEY_1229_QUESTION_561_SCORE + DATAPOINTS.CLIENT_49_SURVEY_1229_QUESTION_541_SCORE + DATAPOINTS.CLIENT_49_SURVEY_1229_QUESTION_551_SCORE)}</td>
<td class="cleanliness-value-{DATAPOINTS.CLIENT_49_SURVEY_1229_QUESTION_561.ID}">{DATAPOINTS.CLIENT_49_SURVEY_1229_QUESTION_561.NAME}</td>
<td class="cleanliness-value-{DATAPOINTS.CLIENT_49_SURVEY_1229_QUESTION_541.ID}">{DATAPOINTS.CLIENT_49_SURVEY_1229_QUESTION_541.NAME}</td>
<td class="cleanliness-value-{DATAPOINTS.CLIENT_49_SURVEY_1229_QUESTION_551.ID}">{DATAPOINTS.CLIENT_49_SURVEY_1229_QUESTION_551.NAME}</td>
</tr>
{/|LOOP|}
</tbody>
</table>
</div>
{/|RESULT|}
{/|SHOWIF|}
</div>
CSS
/* css for CleanlinessLog1347311260937 */
@import "themeroller/jquery.ui.all.css";
@import "chrome.theme.css";
@import "chrome.layout.css";
#data
{
width: auto;
margin: auto;
}
.cleanliness-value-1
{
background-color: #00aa00;
color: white;
}
.cleanliness-value-2
{
background-color: #aaff22;
}
.cleanliness-value-3
{
background-color: #ffff22;
}
.cleanliness-value-4
{
background-color: #ff1111;
color: white;
}
.results h2
{
margin-top: 1em;
}
.percent-score,
.cleanliness-score
{
text-align: center;
}