Use Case
The client would like to see a small dashboard displaying their average scores for the current month, the previous month, and YTD.
Report
Code
<div class='results'>
{|VANISHIF|COUNT(DATATYPES.SHOW_DATATYPE)}
<div class='ui-state-highlight no-data'><p>No data was found to display</p></div>
{/|VANISHIF|}
{|SHOWIF|COUNT(DATATYPES.SHOW_DATATYPE)}
<div class='widget'>
<h3>This Month</h3>
{|RESULT|FILTER=MONTH_YEAR_ID|eq||EVALTAG(THIS_MONTH_YEAR_ID)|}
{|GRAPH|}
graph/t/bh
/w/300
/h/150
/n/Graph%20Title
/d/{|LOOP|RESULT.CLIENTS(SORT=ORDER_NUM)}
{|LOOP|CLIENTS.PROPERTIES(FILTER=type|eq|percent_score,SORT=ORDER_NUM)}
{AVG(CLIENTS.PROPERTIES.VALUE).ROUND}{LOOP.HASNEXT?,}
{/|LOOP|}
{/|LOOP|}
/c/FF0000
?apikey={CONFIG.PDF_API_KEY}
&l={|LOOP|DATATYPES.SHOW_DATATYPE.PROPERTIES(FILTER=type|eq|percent_score,SORT=ORDER_NUM)}
{|SHOWIF|LOOP.ISFIRST}{PROPERTIES.NAME.FUSIONSAFE}{/|SHOWIF|}
{|VANISHIF|LOOP.ISFIRST}{PROPERTIES.NAME.SPLIT(:,1).FUSIONSAFE}{/|VANISHIF|}{LOOP.HASNEXT?,}
{/|LOOP|}
{/|GRAPH|}
{/|RESULT|}
</div>
<div class='widget'>
<h3>Last Month</h3>
{|RESULT|FILTER=MONTH_YEAR_ID|eq||EVALTAG(LAST_MONTH_YEAR_ID)|}
{|GRAPH|}
graph/t/bh
/w/300
/h/150
/n/Graph%20Title
/d/{|LOOP|RESULT.CLIENTS(SORT=ORDER_NUM)}
{|LOOP|CLIENTS.PROPERTIES(FILTER=type|eq|percent_score,SORT=ORDER_NUM)}
{AVG(CLIENTS.PROPERTIES.VALUE).ROUND}{LOOP.HASNEXT?,}
{/|LOOP|}
{/|LOOP|}
/c/FF0000
?apikey={CONFIG.PDF_API_KEY}
&l={|LOOP|DATATYPES.SHOW_DATATYPE.PROPERTIES(FILTER=type|eq|percent_score,SORT=ORDER_NUM)}
{|SHOWIF|LOOP.ISFIRST}{PROPERTIES.NAME.FUSIONSAFE}{/|SHOWIF|}
{|VANISHIF|LOOP.ISFIRST}{PROPERTIES.NAME.SPLIT(:,1).FUSIONSAFE}{/|VANISHIF|}{LOOP.HASNEXT?,}
{/|LOOP|}
{/|GRAPH|}
{/|RESULT|}
</div>
<div class='widget'>
<h3>YTD</h3>
{|RESULT|FILTER=YEAR_ID|eq||EVALTAG(THIS_YEAR_ID)|}
{|GRAPH|}
graph/t/bh
/w/300
/h/150
/n/Graph%20Title
/d/{|LOOP|RESULT.CLIENTS(SORT=ORDER_NUM)}
{|LOOP|CLIENTS.PROPERTIES(FILTER=type|eq|percent_score,SORT=ORDER_NUM)}
{AVG(CLIENTS.PROPERTIES.VALUE).ROUND}{LOOP.HASNEXT?,}
{/|LOOP|}
{/|LOOP|}
/c/FF0000
?apikey={CONFIG.PDF_API_KEY}
&l={|LOOP|DATATYPES.SHOW_DATATYPE.PROPERTIES(FILTER=type|eq|percent_score,SORT=ORDER_NUM)}
{|SHOWIF|LOOP.ISFIRST}{PROPERTIES.NAME.FUSIONSAFE}{/|SHOWIF|}
{|VANISHIF|LOOP.ISFIRST}{PROPERTIES.NAME.SPLIT(:,1).FUSIONSAFE}{/|VANISHIF|}{LOOP.HASNEXT?,}
{/|LOOP|}
{/|GRAPH|}
{/|RESULT|}
</div>
{/|SHOWIF|}
</div>
CSS
@import "themeroller/jquery.ui.all.css";
@import "chrome.theme.css";
@import "chrome.layout.css";
.widget
{
width: 35%;
float: left;
margin: 10px;
}