General Liability Code 95625 (Handyperson) (2024)

' + details + '

');throw new Error(message);}var totalAccountsChart = dc.numberDisplay('#totalAccounts');var totalPremiumChart = dc.numberDisplay('#totalPremium');var carriernameChart = dc.rowChart("#carriername");var premiumDistChart = dc.bubbleChart("#premiumDist");var modDistChart = dc.barChart("#modDist");var woncarrierChart = dc.rowChart("#woncarrier");var externalchangeChart = dc.rowChart("#externalchange");var losscostChart = dc.compositeChart("#losscost");var premiumHistoryChart = dc.compositeChart("#premiumHistory");var newRetainedChart = dc.pieChart("#newRetained");var premiumLcmChart = dc.heatMap("#premiumLcm");var modLcmChart = dc.heatMap("#modLcm");var totalAccountsDim,totalAccountsGroup;var totalPremiumDim,totalPremiumGroup;var carriernameDim,carriernameGroup;var premiumDistDim,premiumDistGroup;var premiumHistoryDim,premiumHistoryGroup;var modDistDim,modDistGroup;var woncarrierDim,woncarrierGroup;var externalchangeDim,externalchangeGroup;var losscostDim,losscostGroup;var newRetainedDim,newRetainedGroup;var premiumLcmDim,premiumLcmGroup;var modLcmDim,modLcmGroup;var blueScale = d3.scaleLinear().range(['#81a2bd','#324759']);//var agentScale = d3.scaleOrdinal().range(d3.schemePaired);var industryScale = d3.scaleOrdinal().range(d3.schemeDark2);//startRange = [new Date(new Date().setFullYear(new Date().getFullYear() - 1)), new Date()];var nf = xfilter('/classreport-data.php?gl=95625&state=').engine(xfilter.fgb_queries());nf.start().then(function(result) {function commitHandler(isRender, k) {nf.commit().then(function() {k();});}totalAccountsDim = nf.dimension('totalAccounts');totalAccountsGroup = totalAccountsDim.group().categorical();totalPremiumDim = nf.dimension('totalPremium');totalPremiumGroup = totalPremiumDim.group().categorical();carriernameDim = nf.dimension('carriergroup');carriernameGroup = carriernameDim.group().categorical();premiumDistDim = nf.dimension('premiumDist');premiumDistGroup = premiumDistDim.group().categorical();modDistDim = nf.dimension('modDist');modDistGroup = modDistDim.group().categorical();modHistoryDim = nf.dimension('modHistory');modHistoryGroup = modHistoryDim.group().categorical();premiumHistoryDim = nf.dimension('premiumHistory');premiumHistoryGroup = premiumHistoryDim.group().categorical();woncarrierDim = nf.dimension('woncarrier');woncarrierGroup = woncarrierDim.group().categorical();externalchangeDim = nf.dimension('externalchange');externalchangeGroup = externalchangeDim.group().categorical();losscostDim = nf.dimension('lc');losscostGroup = losscostDim.group().time();newRetainedDim = nf.dimension('newRetained');newRetainedGroup = newRetainedDim.group().time();premiumLcmDim = nf.dimension('premiumLcm');premiumLcmGroup = premiumLcmDim.group().time();modLcmDim = nf.dimension('modLcm');modLcmGroup = modLcmDim.group().time();arDim = nf.dimension('ar');arGroup = arDim.group().time();vrDim = nf.dimension('vr');vrGroup = vrDim.group().time();totalAccountsChart.width($('#carriername').width()).height(250).formatNumber(d3.format(",.0f")).on('preRender', function() {handleEmpty(this);}).group(totalAccountsGroup);totalPremiumChart.width($('#carriername').width()).height(250).formatNumber(d3.format("$,.0f")).on('preRender', function() {handleEmpty(this);}).group(totalPremiumGroup);newRetainedChart.width($('#carriername').width()).height(250).innerRadius(50).dimension(newRetainedDim).group(newRetainedGroup) .minAngleForLabel(.17).colors(blueScale)//.colors(newRetainedScale).on('preRender', function() {newRetainedChart.calculateColorDomain();handleEmpty(this);}).on('preRedraw', function() {handleEmptyRedraw(this);newRetainedChart.calculateColorDomain();}).on('filtered', function() {handleFilter(this);}).colorAccessor(function(d) {return d.value;}).commitHandler(commitHandler).filterHandler(xfilter.filter_handler)premiumDistChart.width($('#carriername').width()).height(250).margins({left: 50, top: 5, right: 5, bottom: 30}).elasticX(true).elasticY(true).elasticRadius(true)//.colorAccessor(d => d.value.absGain).title(d => {return "Accounts: "+d.value+"\nPremium Size: "+parseInt(d.min)+' - '+parseInt(d.max)+"\nTotal Prem: "+d.sumPremium.value;}).label(d => d.value).xAxisLabel('Account Premium').yAxisLabel('Total Premium').keyAccessor(d => parseInt(d.key)).valueAccessor(d => d.sumPremium.value).radiusValueAccessor(d => d.value).maxBubbleRelativeSize(0.1).x(d3.scaleLog()).y(d3.scaleLog()).r(d3.scaleSqrt()).xAxisPadding('20%').yAxisPadding('20%') .dimension(premiumDistDim).group(premiumDistGroup).on('preRender', function() {premiumDistChart.calculateColorDomain();handleEmpty(this);}).on('preRedraw', function() {handleEmptyRedraw(this);premiumDistChart.calculateColorDomain();}).on('filtered', function() {handleFilter(this);});premiumDistChart.xAxis().ticks(10, ".0s").tickSize(5, 0);premiumDistChart.yAxis().ticks(10, ".0s").tickSize(5, 0);;modDistChart.width($('#carriername').width()).height(250).margins({left: 50, top: 5, right: 5, bottom: 30}).elasticY(true).elasticX(true).xAxisLabel('Experience Mod').yAxisLabel('Accounts').colors(blueScale).x(d3.scaleLinear()).xUnits(dc.units.fp.precision(.1)).y(d3.scaleLinear()).brushOn(false).dimension(modDistDim).group(modDistGroup).on('preRender', function() {handleEmpty(this);}).on('preRedraw', function() {handleEmptyRedraw(this);}).on('filtered', function() {handleFilter(this);});carriernameChart.width($('#carriername').width()).height(250).elasticX(true).margins({left: 10, top: 5, right: 5, bottom: 1}).dimension(carriernameDim).group(carriernameGroup).cap(10)//.colors(carrierScale).colors(blueScale).colorAccessor(function(d) { return d.value;}).othersGrouper(false).title(function(d){return d.key+": "+d.value+" ("+Math.round((d.value/d.totalCount)*100)+"%)"}).on('preRender', function() {carriernameChart.calculateColorDomain();handleEmpty(this);}).on('preRedraw', function() {handleEmptyRedraw(this);carriernameChart.calculateColorDomain();}).on('filtered', function() {handleFilter(this);}).on('filtered', function() {handleFilter(this);}).controlsUseVisibility(true).commitHandler(commitHandler).filterHandler(xfilter.filter_handler);woncarrierChart.width($('#woncarrier').width()).height(250).elasticX(true).margins({left: 10, top: 5, right: 5, bottom: 1}).dimension(woncarrierDim).group(woncarrierGroup).colors(blueScale).colorAccessor(function(d) { return d.value;}).title(function(d){return d.key+": "+d.value+" ("+Math.round((d.value/d.totalCount)*100)+"%)"}).on('preRender', function() {woncarrierChart.calculateColorDomain();handleEmpty(this);}).on('preRedraw', function() {handleEmptyRedraw(this);woncarrierChart.calculateColorDomain();}).on('filtered', function() {handleFilter(this);}).cap(10).othersGrouper(false).controlsUseVisibility(true).commitHandler(commitHandler).filterHandler(xfilter.filter_handler)externalchangeChart.width($('#externalchange').width()).height(250).elasticX(true).margins({left: 10, top: 5, right: 5, bottom: 1}).dimension(externalchangeDim).group(externalchangeGroup).colors(blueScale).colorAccessor(function(d) { return d.value;}).title(function(d){return d.key+": "+d.value+" ("+Math.round((d.value/d.totalCount)*100)+"%)"}).on('preRender', function() {externalchangeChart.calculateColorDomain();handleEmpty(this);}).on('preRedraw', function() {handleEmptyRedraw(this);externalchangeChart.calculateColorDomain();}).on('filtered', function() {handleFilter(this);}).cap(10).othersGrouper(false).controlsUseVisibility(true).commitHandler(commitHandler).filterHandler(xfilter.filter_handler)losscostChart//.renderArea(true).width($('#losscost').width()).height(270).margins({top: 20, right: 30, bottom: 35, left: 30}).xAxisLabel('Effective Date').yAxisLabel('Rate').elasticY(true).elasticX(true).legend(new dc.Legend().horizontal(true).autoItemWidth(true).x(30)).compose([ new dc.LineChart(losscostChart) .dimension(losscostDim) .colors('#324759') .group(losscostGroup, "Loss Cost").interpolate('step-after').round(d3.timeMonth.round).xAxisPadding('10%').yAxisPadding('10%').dotRadius(6).keyAccessor(function(d){return new Date(d.key);}).renderDataPoints({radius:3}).commitHandler(commitHandler).filterHandler(xfilter.filter_handler) ,new dc.LineChart(losscostChart) .dimension(arDim) .colors('#75a8d4') .group(arGroup, "Assign Risk").interpolate('step-after').round(d3.timeMonth.round).xAxisPadding('10%').yAxisPadding('10%').dotRadius(6).keyAccessor(function(d){return new Date(d.key);}).renderDataPoints({radius:3}).commitHandler(commitHandler).filterHandler(xfilter.filter_handler) ,new dc.LineChart(losscostChart) .dimension(vrDim) .colors('#324759') .group(vrGroup, "Voluntary").interpolate('step-after').round(d3.timeMonth.round).xAxisPadding('10%').yAxisPadding('10%').dotRadius(6).keyAccessor(function(d){return new Date(d.key);}).renderDataPoints({radius:3}).commitHandler(commitHandler).filterHandler(xfilter.filter_handler) ,new dc.LineChart(losscostChart) .dimension(modHistoryDim) .colors('#ed8d5f') .group(modHistoryGroup, "Avg Mod").interpolate('step-after').round(d3.timeMonth.round).xAxisPadding('10%').yAxisPadding('10%').dotRadius(6).keyAccessor(function(d){return new Date(d.key);}).valueAccessor(function(d){return d.avgMod.value;}).renderDataPoints({radius:3}).commitHandler(commitHandler).filterHandler(xfilter.filter_handler)]).renderHorizontalGridLines(true).brushOn(false).on('preRender',function() {losscostChart.x(d3.scaleTime().domain([new Date(losscostDim.min()), new Date()]));handleEmpty(this);}).on('preRedraw', function() {handleEmptyRedraw(this);}).on('filtered', function() {handleFilter(this);});premiumHistoryChart//.renderArea(true).width($('#premiumHistory').width()).height(270).margins({top: 20, right: 50, bottom: 35, left: 50}).xAxisLabel('Xdate').yAxisLabel('Avg Prem').rightYAxisLabel('Tot Prem').elasticY(true).elasticX(true).legend(new dc.Legend().horizontal(true).autoItemWidth(true).x(30)).compose([ new dc.LineChart(premiumHistoryChart) .dimension(premiumHistoryDim) .colors('#324759') .group(premiumHistoryGroup, "Avg Prem").interpolate('step-before').round(d3.timeMonth.round).xAxisPadding('10%').yAxisPadding('10%').dotRadius(6).keyAccessor(function(d){return new Date(d.key);}).valueAccessor(function(d){return d.avgPremium.value;}).title(function(d){return d.avgPremium.value;}).renderDataPoints({radius:3}).commitHandler(commitHandler).filterHandler(xfilter.filter_handler) ,new dc.LineChart(premiumHistoryChart) .dimension(premiumHistoryDim) .colors('#75a8d4') .group(premiumHistoryGroup, "Tot Prem").interpolate('step-before').round(d3.timeMonth.round).xAxisPadding('10%').yAxisPadding('10%').dotRadius(6).keyAccessor(function(d){return new Date(d.key);}).valueAccessor(function(d){return d.totalPremium.value;}).title(function(d){return 'test'+d.totalPremium.value;}).useRightYAxis(true).renderDataPoints({radius:3}).commitHandler(commitHandler).filterHandler(xfilter.filter_handler)]).renderHorizontalGridLines(true).brushOn(false).on('preRender',function() {handleEmpty(this);premiumHistoryChart.x(d3.scaleTime().domain([new Date(premiumHistoryDim.min()), new Date()]));}).on('preRedraw', function() {handleEmptyRedraw(this);}).on('filtered', function() {handleFilter(this);});premiumHistoryChart.yAxis().ticks(10, ".0s").tickSize(5, 0);premiumHistoryChart.rightYAxis().ticks(10, ".0s").tickSize(5, 0);premiumLcmChart//.renderArea(true).width($('#carriername').width()).height(270).margins({top: 20, right: 50, bottom: 35, left: 50}).dimension(premiumLcmDim).group(premiumLcmGroup).colors(blueScale).keyAccessor(function(d) { return +d.key[1]; }).valueAccessor(function(d) { return +parseInt(d.key[0]); }).rowsLabel(function(d) { return d3.format('.2s')(d); }).colorAccessor(function(d) { return +d.value; }).on('preRender', function() {handleEmpty(this);premiumLcmChart.calculateColorDomain();}).on('preRedraw', function() {handleEmptyRedraw(this);premiumLcmChart.calculateColorDomain();}).on('filtered', function() {handleFilter(this);});modLcmChart//.renderArea(true).width($('#carriername').width()).height(270).margins({top: 20, right: 50, bottom: 35, left: 50}).dimension(modLcmDim).group(modLcmGroup).colors(blueScale).keyAccessor(function(d) { return +d.key[1]; }).valueAccessor(function(d) { return +parseFloat(d.key[0]).toFixed(2); }).colorAccessor(function(d) { console.log('color',d);return +d.value; }).on('preRender', function() {handleEmpty(this);modLcmChart.calculateColorDomain();}).on('preRedraw', function() {handleEmptyRedraw(this);modLcmChart.calculateColorDomain();}).on('filtered', function() {handleFilter(this);});carriernameChart.renderGroup();carriernameChart.on('postRender', function() {if (!$('.nodatahide').is(":visible")) {$('#noDataFull').removeClass('hidden');}});});