Use Case
The client would like an easy way to see whether their product selection is lacking on certain days of the week. They will evaluate this based on customer ratings on their Customer Satisfaction survey.
Report
Code
{|SHOWIF|OUTPUT_MODE=|EVALCONST(KNICKERS_OUTPUT_STANDARD)|}{DATATYPES.CONTROLS_START}
{DATATYPES.DEFAULT_DATE_FILTERS}
{DATATYPES.CONTROLS_END}{/|SHOWIF|}
{|VANISHIF|DATATYPES.SHOW_DATATYPE.TOTAL_COUNT}
No data was found to display
{/|VANISHIF|}
{|SHOWIF|DATATYPES.SHOW_DATATYPE.TOTAL_COUNT}
{|RESULT|} {|GRAPH|} graph/t/b /w/600 /h/300 /n/Product%20Selection%20Rating%20vs%20Day%20of%20Week /d/{|LOOP|RESULT.DAY_OF_WEEK(SORT=ORDER_NUM)} {AVG(DAY_OF_WEEK.CLIENT_49_SURVEY_1230_QUESTION_51_SCORE)}{LOOP.HASNEXT?,} {/|LOOP|} /l/{|LOOP|RESULT.DAY_OF_WEEK(SORT=ORDER_NUM)} {DAY_OF_WEEK.NAME.URLENCODE}{LOOP.HASNEXT?,} {/|LOOP|} /c/ffbb44 ?apikey={CONFIG.PDF_API_KEY} {/|GRAPH|} {/|RESULT|}
{/|SHOWIF|}