a!localVariables( local!monthYearList: a!forEach( items: ri!dateCategoryList, expression: { month: month(fv!item.value), year: year(fv!item.value), day: day(fv!item.value), name: fv!item.name } ), { a!lineChartField( label: "Conformance", categories: ri!dateCategoryList.name, series: a!chartSeries( label: "Conformance", data: a!forEach( items: local!monthYearList, expression: a!localVariables( local!month: fv!item.month, local!year: fv!item.year, local!day: fv!item.day, local!week: fv!item.name, local!taskProdutionList: index( ri!taskProdutionList, where( a!forEach( items: ri!taskProdutionList, expression: if( ri!selectedDateRange = cons!INO_DATE_RANGE_16_WEEK, and(todate(fv!item.weekDate) = todate(local!week)), and( month(fv!item.weekDate) = local!month, year(fv!item.weekDate) = local!year, if( or( ri!selectedDateRange=cons!INO_DATE_RANGE_MTD, ri!selectedDateRange=cons!INO_DATE_RANGE_WTD ), day(fv!item.weekDate) = local!day, true ) ) ) ) ), {} ), if( rule!INO_isBlank( local!taskProdutionList.adherencePercentage ), null, round(average(local!taskProdutionList.adherencePercentage), 0) ) ) ), links: a!forEach( items: local!monthYearList, expression: a!dynamicLink( saveInto: { a!save( ri!selectedMonth, fv!item.month ), a!save( ri!selectedYear, fv!item.year ), a!save( ri!selectedWeek, /*todate(fv!item.name)*/ fv!item.weekDate ), a!save( ri!selectedDay, fv!item.day ) } ) ) ), xAxisTitle: if( or(ri!selectedDateRange=cons!INO_DATE_RANGE_MTD, ri!selectedDateRange=cons!INO_DATE_RANGE_WTD), "Day", if( ri!selectedDateRange = cons!INO_DATE_RANGE_16_WEEK, "Week", "Month" ) ), yAxisTitle: "Conformance", yAxisMin: 0, showLegend: false ) } )
Discussion posts and replies are publicly visible