Group a Chart by Date Criteria
HTML Chart Control
Group a Chart by Date Criteria
Technologies > User Interface Add-Ins> HTML Chart Views > Grouped Column Chart with Values Grouped by Time Criteria
The following example restricts the grouping field values by a year range. The year range may be supplied using the
addParameter()
function:
<!-- Parameters specify the range of years to get displayed.
The client can override parameter values using addParameter() function. -->
<parameter name="yearStart" dataType="number" value="2000"/>
<parameter name="yearEnd" dataType="number" value="2008"/>
<!-- Restrict the grouping field values by the year range -->
<restriction type="sql"
sql="${sql.yearOf('cal_date')} >= ${parameters['yearStart']}
AND ${sql.yearOf('cal_date')} <= ${parameters['yearEnd']}" />