Use Case
The client would like to see how their average overall score varies from month to month. They would like to see if there are any identifiable patterns in this variation.
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}
{|CROSSTAB|}
{|GRAPH|}
graph/t/l
/w/900
/h/300
/n/Year%20Over%20Year%20Trending
/d0/{|LOOP|CROSSTAB.YEAR(SORT=NAME,CROSSTAB_FILTER=NO_BLANKS)}
{|LOOP|YEAR.MONTH_OF_YEAR(SORT=ORDER_NUM,CROSSTAB_FILTER=WITH_BLANKS)}
{AVG(MONTH_OF_YEAR.PERCENT_SCORE)}{LOOP.HASNEXT?,}
{/|LOOP|}
{|SHOWIF|LOOP.HASNEXT}/d{LOOP.COUNT}/{/|SHOWIF|}
{|VANISHIF|LOOP.HASNEXT}
/l/{|LOOP|YEAR.MONTH_OF_YEAR}{MONTH_OF_YEAR.NAME.FUSIONSAFE}{LOOP.HASNEXT?,}{/|LOOP|}
{/|VANISHIF|}
{/|LOOP|}
/k0/{|LOOP|CROSSTAB.YEAR}
{YEAR.NAME.FUSIONSAFE}
{|LOOP|YEAR.MONTH_OF_YEAR}{/|LOOP|}
{|SHOWIF|LOOP.HASNEXT}/k{LOOP.COUNT}/{/|SHOWIF|}
{/|LOOP|}
/c/ff0000,0000ff,00ff00,000000
/r/50,100
?apikey={CONFIG.PDF_API_KEY}
{/|GRAPH|}
{/|CROSSTAB|}
{/|SHOWIF|}
</div>