Group a Chart by Time Criteria
HTML Chart Control
Group a Chart by Time 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']}" />
Use parameterized restrictions
Restrict grouped data by date criteria
Example view: http://localhost:8080/archibus/schema/ab-products/solutions/parts/htmlchart/ab-ex-htmlchart-mult-values-time-criteria.axvw