<?xml version="1.0" encoding="UTF-8"?>
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.23" id="1">
    <property name="createdBy">Eclipse BIRT Designer Version 4.8.0.v201806261756</property>
    <list-property name="userProperties">
        <structure>
            <property name="name">MailingSummaryDataCube.MailingSummaryDataSet.x</property>
            <property name="type">integer</property>
            <property name="isVisible">false</property>
        </structure>
        <structure>
            <property name="name">MailingSummaryDataCube.MailingSummaryDataSet.y</property>
            <property name="type">integer</property>
            <property name="isVisible">false</property>
        </structure>
        <structure>
            <property name="name">MailingSummaryDayDataCube.MailingSummaryDayDataSet.x</property>
            <property name="type">integer</property>
            <property name="isVisible">false</property>
        </structure>
        <structure>
            <property name="name">MailingSummaryDayDataCube.MailingSummaryDayDataSet.y</property>
            <property name="type">integer</property>
            <property name="isVisible">false</property>
        </structure>
        <structure>
            <property name="name">SummaryDataCube.OptimizationSummaryDataSet.x</property>
            <property name="type">integer</property>
            <property name="isVisible">false</property>
        </structure>
        <structure>
            <property name="name">SummaryDataCube.OptimizationSummaryDataSet.y</property>
            <property name="type">integer</property>
            <property name="isVisible">false</property>
        </structure>
    </list-property>
    <property name="MailingSummaryDataCube.MailingSummaryDataSet.x">135</property>
    <property name="MailingSummaryDataCube.MailingSummaryDataSet.y">80</property>
    <property name="MailingSummaryDayDataCube.MailingSummaryDayDataSet.x">135</property>
    <property name="MailingSummaryDayDataCube.MailingSummaryDayDataSet.y">80</property>
    <property name="SummaryDataCube.OptimizationSummaryDataSet.x">135</property>
    <property name="SummaryDataCube.OptimizationSummaryDataSet.y">80</property>
    <simple-property-list name="includeResource">
        <value>WEB-INF/classes/messages</value>
    </simple-property-list>
    <property name="units">in</property>
    <method name="initialize"><![CDATA[importPackage(Packages.com.agnitas.reporting.birt.external.dataset);
importPackage(Packages.org.eclipse.birt.report.model.api.util);
importPackage(Packages.org.eclipse.birt.chart.model.attribute.impl);
importPackage(Packages.com.agnitas.messages);
importPackage(Packages.org.apache.commons.lang);

var isCSVFormat = reportContext.getOutputFormat() == "csv";
var isPDFFormat = reportContext.getOutputFormat() == "pdf";

reportContext.setGlobalVariable("isDarkmode", params["darkmode"]);

var showNet = params["showNet"] == true;
var showGross = params["showGross"] == true;

if (isCSVFormat || isPDFFormat) {
	showNet = true;
	showGross = true;
}

reportContext.setPersistentGlobalVariable("showNet", new Boolean(showNet));
reportContext.setPersistentGlobalVariable("showGross", new Boolean(showGross));

optimizationDataSet = new Packages.com.agnitas.reporting.birt.external.dataset.TotalOptimizationDataSet();
optimizationDataSet.prepareOptimizationReport(params["optimizationID"], params["companyID"], params["showSoftbounces"]);

var autoOptData = new AutoOptimizationDataSet().getData(params["optimizationID"], params["companyID"]);

var trackingExists = true;
if(params["trackingAllowed"].value) {
  trackingExists = optimizationDataSet.isTrackingExistsOfOptimizationMailings(params["optimizationID"], params["companyID"]);
}
reportContext.setPersistentGlobalVariable("trackingExists", new Boolean(trackingExists));

mailingSummaryDataDefinition = {};
mailingSummaryDataDefinition[CommonKeys.RECIPIENTS_NUMBER] 			= {"position": 1, "color": "color-pure-blue"};
mailingSummaryDataDefinition[CommonKeys.DELIVERED_EMAILS] 			= {"position": 2, "color": "color-blue"};
mailingSummaryDataDefinition[CommonKeys.DELIVERED_EMAILS_DELIVERED] = {"position": 3, "color": "color-dark-blue"};
mailingSummaryDataDefinition[CommonKeys.OPENERS_MEASURED] 			= {"position": 4, "color": "color-light-green", "translationKey": "report.opens.measured"};
mailingSummaryDataDefinition[CommonKeys.OPENERS_INVISIBLE] 			= {"position": 5, "color": "color-middle-green", "translationKey": "report.opens.invisible"};
mailingSummaryDataDefinition[CommonKeys.OPENERS_TOTAL] 				= {"position": 6, "color": "color-dark-green"};
mailingSummaryDataDefinition[CommonKeys.OPENINGS_ANONYMOUS] 		= {"position": 7, "color": "color-light-grey", "hasNoPercentageRepresentation": true};
mailingSummaryDataDefinition[CommonKeys.CLICKER] 					= {"position": 8, "color": "color-petrol"};
mailingSummaryDataDefinition[CommonKeys.CLICKS_ANONYMOUS] 			= {"position": 9, "color": "color-light-grey", "hasNoPercentageRepresentation": true};
mailingSummaryDataDefinition[CommonKeys.OPT_OUTS] 					= {"position": 10, "color": "color-red"};
mailingSummaryDataDefinition[CommonKeys.SOFT_BOUNCES] 				= {"position": 11, "color": "color-vivid-orange"};
mailingSummaryDataDefinition[CommonKeys.HARD_BOUNCES] 				= {"position": 12, "color": "color-orange"};
mailingSummaryDataDefinition[CommonKeys.SOFT_BOUNCES_UNDELIVERABLE] = {"position": 13, "color": "color-yellow"};
mailingSummaryDataDefinition[CommonKeys.REVENUE] 					= {"position": 14, "color": "color-vivid-orange", "hasNoPercentageRepresentation": true};
mailingSummaryDataDefinition[CommonKeys.OPENERS_PC_AND_MOBILE] 		= {"translationKey": "report.opens.pc.and.mobileWithNote"};
mailingSummaryDataDefinition[CommonKeys.CLICKER_PC_AND_MOBILE] 		= {"translationKey": "statistic.clicker.multiple"};

var chartPalette;
if (params['darkmode'] == true) {
    chartPalette = [
        "#41641A", //reserved for winner
        "#0071B9",
        "#009999",
        "#92D04F",
        "#64C3FF",
        "#FFC000",
        "#888A85",
        "#FF8676"
    ];
} else {
    chartPalette = [
        "#41641A", //reserved for winner
        "#0071B9",
        "#009999",
        "#92D04F",
        "#64C3FF",
        "#FFC000",
        "#888A85",
        "#2E3436"
    ];
}


// color
function getPaletteColor(index) {
	return index < 0 || index > chartPalette.length ? "#0071B9" : chartPalette[index];
}

function getPaletteColorByGroupId(groupId) {
	if (isWinnerMailing(groupId)) {
		return translateColor(getPaletteColor(0)); //color-dark-green
	} else {
		return translateColor(getPaletteColor(groupId + 2));
	}
}

function translateColor(colorRgb) {
	var red = "0x" + colorRgb.substr(1, 2);
	var green = "0x" + colorRgb.substr(3, 2);
	var blue = "0x" + colorRgb.substr(5, 2);

	return ColorDefinitionImpl.create(red, green, blue);
}

function getColorDefinition(styleName) {
	var color = ColorUtil.format(reportContext.getDesignHandle().findStyle(styleName).getColor().getRGB(), ColorUtil.HTML_FORMAT);
	return translateColor(color);
};

//autooptimization groups data
function getMailingGroupName(groupId) {
	switch (groupId) {
		case -1:
			return "" + tr("Sum");
		case 0:
			return "" + tr("mailing.autooptimization");
		case 1:
			return autoOptData.getTestGroup1();
		case 2:
			return autoOptData.getTestGroup2();
		case 3:
			return autoOptData.getTestGroup3();
		case 4:
			return autoOptData.getTestGroup4();		
		case 5:
			return autoOptData.getTestGroup5();
		default:
			return "" + tr("Unknown");
	}
}

function getMailingIdByGroupId(groupId) {
	switch (groupId) {
		case -1:
		case 0:
			return -1;
		case 1:
			return autoOptData.getTestGroup1Id();
		case 2:
			return autoOptData.getTestGroup2Id();
		case 3:
			return autoOptData.getTestGroup3Id();
		case 4:
			return autoOptData.getTestGroup4Id();		
		case 5:
			return autoOptData.getTestGroup5Id();
		default:
			return -1;
	}
}

function getGroupIdByName(name) {	
	if (tr("Sum") == name) {
		return -1;
	}
	
	if (autoOptData.getTestGroup1() == name) {
		return 1;
	}
	if (autoOptData.getTestGroup2() == name) {
		return 2;
	}
	if (autoOptData.getTestGroup3() == name) {
		return 3;
	}
	if (autoOptData.getTestGroup4() == name) {
		return 4;
	}
	if (autoOptData.getTestGroup5() == name) {
		return 5;
	}
	
	return 0;
};

function isWinnerMailing(groupId) {
	return getMailingIdByGroupId(groupId) == autoOptData.getWinnerId();
}

function getMailingGroupNameTitle(groupId, baseGroupId) {
	var name = getMailingGroupName(groupId);
	if (groupId == 0) {
		name += "\n(" + getMailingGroupName(baseGroupId) + ")";
	}
	
	return name;
}

// percentage representation
function hasPercentageRepresentation(categoryKey) {
	if (mailingSummaryDataDefinition[categoryKey] &amp;&amp; mailingSummaryDataDefinition[categoryKey]["hasNoPercentageRepresentation"]) {
		return !mailingSummaryDataDefinition[categoryKey]["hasNoPercentageRepresentation"];
	}
	return true;
}

function calculatePercent(value, totalValue) {
	if (totalValue > 0) {
		return (value / totalValue) * 100;
	}
	
	return 0;
}

function formatPercent(percent) {
	return new Packages.java.text.DecimalFormat("##0.0").format(percent);
}

// position
function getKeyFiguresRowPosition(categoryKey, categoryIndex) {
	if (mailingSummaryDataDefinition[categoryKey] &amp;&amp; mailingSummaryDataDefinition[categoryKey]["position"]) {
		return parseInt(mailingSummaryDataDefinition[categoryKey]["position"]);
	}
	return parseInt(1000000 + categoryIndex);  // Bump to the end
};

function getCrossTableColumnPosition(groupId) {
	if (groupId == CommonKeys.OPTIMIZATION_SUMMARY_GROUP_ID) {
		return parseInt(1000000);   // Bump to the end
	}
	if (groupId == CommonKeys.OPTIMIZATION_WINNER_GROUP_ID){
		return 1;
	}
	return parseInt(groupId + 1);
}

function getKeyFiguresColumnPosition(groupId) {	
	if (groupId == CommonKeys.OPTIMIZATION_SUMMARY_GROUP_ID) {
		return 1;
	}
	if (groupId == CommonKeys.OPTIMIZATION_WINNER_GROUP_ID){
		return 2;
	}
	return parseInt(groupId + 2);  // Bump to the end
};

function getKeyFiguresColumnPositionByName(name) {
	return getKeyFiguresColumnPosition(parseInt(getGroupIdByName(name)));
}

//wrap
function wrap(str, width) {
	var length;

	if (str.length instanceof Function) {
		length = str.length();
	} else {
		length = str.length;
	}

	if (length <= width) {
		return str;
	}

	return str.substring(0, width) + "\n" + wrap(str.substring(width, length), width);
}

//format date
function formatDate(dateValue) {
	if (dateValue == null) {
		return "";
	}
	if (reportContext.getLocale().getLanguage() == "de") {
		return new Packages.java.text.SimpleDateFormat("dd.MM.yyyy").format(dateValue);	
	} else {
		return new Packages.java.text.SimpleDateFormat("yyyy-MM-dd").format(dateValue);
	}
}

// translation
function tr(key) {
	return Packages.com.agnitas.messages.I18nString.getLocaleString(key, reportContext.getLocale());
}

function getTranslationByCategory(categoryKey) {
	if (isDataDefinitionContainsTranslation(categoryKey)) {
		return tr(mailingSummaryDataDefinition[categoryKey]["translationKey"]);
	}
	return tr(categoryKey)
};

function isDataDefinitionContainsTranslation(categoryKey) {
	return mailingSummaryDataDefinition[categoryKey] &amp;&amp; mailingSummaryDataDefinition[categoryKey]["translationKey"]
};

//chart series and tooltips
function getSeriesTooltips(categoryKey, value, rate) {
	if (hasPercentageRepresentation(categoryKey)) {
		return makeLabelWithPercent(value, rate);
	} else {
		return value;
	}
}

function makeLabelWithPercent(value, rate) {
    curValue = Packages.java.text.NumberFormat.getNumberInstance(reportContext.getLocale()).parse(value);
    percent = Packages.java.text.NumberFormat.getNumberInstance(reportContext.getLocale()).parse(rate) * 100;
	return formatPercent(percent) + '%; ' + value;
}


reportContext.setGlobalVariable("mailingSummaryDataDefinition", mailingSummaryDataDefinition);
reportContext.setGlobalVariable("hasPercentageRepresentationFunction", hasPercentageRepresentation);
reportContext.setGlobalVariable("getKeyFiguresRowPositionFunction", getKeyFiguresRowPosition);
reportContext.setGlobalVariable("getKeyFiguresColumnPositionFunction", getKeyFiguresColumnPosition);
reportContext.setGlobalVariable("getCrossTableColumnPositionFunction", getCrossTableColumnPosition);
reportContext.setGlobalVariable("getPaletteColorByGroupIdFunction", getPaletteColorByGroupId);
reportContext.setGlobalVariable("tr", tr);
reportContext.setGlobalVariable("wrap", wrap);
reportContext.setGlobalVariable("formatDate", formatDate);
reportContext.setGlobalVariable("getTranslationByCategoryFunction", getTranslationByCategory);
reportContext.setGlobalVariable("getMailingGroupNameFunction", getMailingGroupName);
reportContext.setGlobalVariable("getSeriesTooltipsFunction", getSeriesTooltips);
reportContext.setGlobalVariable("calculatePercentFunction", calculatePercent);
reportContext.setGlobalVariable("formatPercentFunction", formatPercent);
reportContext.setGlobalVariable("getGroupIdByNameFunction", getGroupIdByName);
reportContext.setGlobalVariable("getKeyFiguresColumnPositionByNameFunction", getKeyFiguresColumnPositionByName);

]]></method>
    <method name="afterRender"><![CDATA[optimizationDataSet.destroy();]]></method>
    <property name="iconFile">/templates/blank_report.gif</property>
    <property name="layoutPreference">auto layout</property>
    <property name="bidiLayoutOrientation">ltr</property>
    <list-property name="cssStyleSheets">
        <structure>
            <property name="fileName">styles.css</property>
            <property name="useExternalCss">false</property>
        </structure>
        <structure>
            <property name="useExternalCss">true</property>
            <property name="externalCssURI">/birt/webcontent/birt/styles/redesign_style.css</property>
        </structure>
    </list-property>
    <parameters>
        <scalar-parameter name="companyID" id="129">
            <property name="valueType">static</property>
            <property name="dataType">integer</property>
            <property name="distinct">true</property>
            <simple-property-list name="defaultValue">
                <value type="constant">463</value>
            </simple-property-list>
            <property name="paramType">simple</property>
            <property name="controlType">text-box</property>
            <structure name="format">
                <property name="category">Unformatted</property>
            </structure>
        </scalar-parameter>
        <scalar-parameter name="language" id="134">
            <property name="valueType">static</property>
            <property name="dataType">string</property>
            <property name="distinct">true</property>
            <simple-property-list name="defaultValue">
                <value type="constant">DE</value>
            </simple-property-list>
            <property name="paramType">simple</property>
            <property name="controlType">text-box</property>
            <structure name="format">
                <property name="category">Unformatted</property>
            </structure>
        </scalar-parameter>
        <scalar-parameter name="emmsession" id="100">
            <property name="valueType">static</property>
            <property name="isRequired">false</property>
            <property name="dataType">string</property>
            <property name="distinct">true</property>
            <simple-property-list name="defaultValue">
                <value type="constant">;jsessionid=12345</value>
            </simple-property-list>
            <property name="paramType">simple</property>
            <property name="controlType">text-box</property>
            <structure name="format">
                <property name="category">Unformatted</property>
            </structure>
        </scalar-parameter>
        <scalar-parameter name="targetbaseurl" id="101">
            <property name="valueType">static</property>
            <property name="isRequired">false</property>
            <property name="dataType">string</property>
            <property name="distinct">true</property>
            <simple-property-list name="defaultValue">
                <value type="constant">http://localhost:8080/css</value>
            </simple-property-list>
            <property name="paramType">simple</property>
            <property name="controlType">text-box</property>
            <structure name="format">
                <property name="category">Unformatted</property>
            </structure>
        </scalar-parameter>
        <scalar-parameter name="trackingAllowed" id="742">
            <property name="valueType">static</property>
            <property name="dataType">boolean</property>
            <property name="distinct">true</property>
            <property name="paramType">simple</property>
            <property name="controlType">check-box</property>
            <structure name="format"/>
        </scalar-parameter>
        <scalar-parameter name="optimizationID" id="835">
            <property name="valueType">static</property>
            <property name="isRequired">false</property>
            <property name="dataType">integer</property>
            <property name="distinct">true</property>
            <simple-property-list name="defaultValue">
                <value type="constant">0</value>
            </simple-property-list>
            <property name="paramType">simple</property>
            <property name="controlType">text-box</property>
            <structure name="format">
                <property name="category">Unformatted</property>
            </structure>
        </scalar-parameter>
        <scalar-parameter name="showSoftbounces" id="969">
            <property name="valueType">static</property>
            <property name="dataType">boolean</property>
            <property name="distinct">true</property>
            <property name="paramType">simple</property>
            <property name="controlType">check-box</property>
            <structure name="format"/>
        </scalar-parameter>
        <scalar-parameter name="showNet" id="1085">
            <property name="valueType">static</property>
            <property name="isRequired">false</property>
            <property name="dataType">boolean</property>
            <property name="distinct">true</property>
            <simple-property-list name="defaultValue">
                <value type="constant">False</value>
            </simple-property-list>
            <list-property name="selectionList"/>
            <property name="paramType">simple</property>
            <property name="controlType">check-box</property>
            <structure name="format"/>
        </scalar-parameter>
        <scalar-parameter name="showGross" id="1086">
            <property name="valueType">static</property>
            <property name="isRequired">false</property>
            <property name="dataType">boolean</property>
            <property name="distinct">true</property>
            <simple-property-list name="defaultValue">
                <value type="constant">true</value>
            </simple-property-list>
            <list-property name="selectionList"/>
            <property name="paramType">simple</property>
            <property name="controlType">check-box</property>
            <structure name="format"/>
        </scalar-parameter>
        <scalar-parameter name="darkmode" id="1905">
            <property name="valueType">static</property>
            <property name="isRequired">false</property>
            <property name="dataType">boolean</property>
            <property name="distinct">true</property>
            <simple-property-list name="defaultValue">
                <value type="constant">false</value>
            </simple-property-list>
            <list-property name="selectionList"/>
            <property name="paramType">simple</property>
            <property name="controlType">check-box</property>
            <structure name="format"/>
        </scalar-parameter>
    </parameters>
    <data-sources>
        <script-data-source name="DummyDataSource" id="7"/>
    </data-sources>
    <data-sets>
        <script-data-set name="OptimizationMailingDataSet" id="1247">
            <list-property name="resultSetHints">
                <structure>
                    <property name="position">1</property>
                    <property name="name">mailingName</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">2</property>
                    <property name="name">mailingId</property>
                    <property name="dataType">integer</property>
                </structure>
                <structure>
                    <property name="position">3</property>
                    <property name="name">subject</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">4</property>
                    <property name="name">targetGroupName</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">5</property>
                    <property name="name">isWinner</property>
                    <property name="dataType">boolean</property>
                </structure>
                <structure>
                    <property name="position">6</property>
                    <property name="name">resultMailing</property>
                    <property name="dataType">integer</property>
                </structure>
                <structure>
                    <property name="position">7</property>
                    <property name="name">groupId</property>
                    <property name="dataType">integer</property>
                </structure>
                <structure>
                    <property name="position">8</property>
                    <property name="name">targetGroupId</property>
                    <property name="dataType">integer</property>
                </structure>
                <structure>
                    <property name="position">9</property>
                    <property name="name">avgMailSize</property>
                    <property name="dataType">float</property>
                </structure>
                <structure>
                    <property name="position">10</property>
                    <property name="name">sendDate</property>
                    <property name="dataType">date</property>
                </structure>
            </list-property>
            <list-property name="columnHints">
                <structure>
                    <property name="columnName">mailingName</property>
                </structure>
                <structure>
                    <property name="columnName">mailingId</property>
                </structure>
                <structure>
                    <property name="columnName">subject</property>
                </structure>
                <structure>
                    <property name="columnName">targetGroupName</property>
                </structure>
                <structure>
                    <property name="columnName">isWinner</property>
                </structure>
                <structure>
                    <property name="columnName">resultMailing</property>
                </structure>
                <structure>
                    <property name="columnName">groupId</property>
                </structure>
                <structure>
                    <property name="columnName">targetGroupId</property>
                </structure>
                <structure>
                    <property name="columnName">avgMailSize</property>
                </structure>
                <structure>
                    <property name="columnName">sendDate</property>
                </structure>
            </list-property>
            <structure name="cachedMetaData">
                <list-property name="resultSet">
                    <structure>
                        <property name="position">1</property>
                        <property name="name">mailingName</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">2</property>
                        <property name="name">mailingId</property>
                        <property name="dataType">integer</property>
                    </structure>
                    <structure>
                        <property name="position">3</property>
                        <property name="name">subject</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">4</property>
                        <property name="name">targetGroupName</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">5</property>
                        <property name="name">isWinner</property>
                        <property name="dataType">boolean</property>
                    </structure>
                    <structure>
                        <property name="position">6</property>
                        <property name="name">resultMailing</property>
                        <property name="dataType">integer</property>
                    </structure>
                    <structure>
                        <property name="position">7</property>
                        <property name="name">groupId</property>
                        <property name="dataType">integer</property>
                    </structure>
                    <structure>
                        <property name="position">8</property>
                        <property name="name">targetGroupId</property>
                        <property name="dataType">integer</property>
                    </structure>
                    <structure>
                        <property name="position">9</property>
                        <property name="name">avgMailSize</property>
                        <property name="dataType">float</property>
                    </structure>
                    <structure>
                        <property name="position">10</property>
                        <property name="name">sendDate</property>
                        <property name="dataType">date</property>
                    </structure>
                </list-property>
            </structure>
            <property name="dataSource">DummyDataSource</property>
            <method name="open"><![CDATA[importPackage(Packages.com.agnitas.reporting.birt.external.dataset);
optimizationMailings = optimizationDataSet.getOptimizationMailings();
currentrow = 0;]]></method>
            <method name="fetch"><![CDATA[
importPackage(Packages.org.apache.commons.lang);

if( currentrow < optimizationMailings.size() ) {
	dataRow = optimizationMailings.get(currentrow);
	row["mailingId"] = dataRow.getMailingId();
	row["mailingName"] = dataRow.getMailingName();
	row["isWinner"] = dataRow.isWinner();
	row["subject"] = dataRow.getMailingSubject();
	
	if (dataRow.getTargetGroupId() > 1) {
		row["targetGroupName"] = tr(dataRow.getTargetGroupName());
	} else {
		row["targetGroupName"] = tr("statistic.all_subscribers");	
	}
	row["targetGroupId"] = dataRow.getTargetGroupId();
	row["resultMailing"] = dataRow.getResultMailing();
	row["groupId"] = dataRow.getGroupId();
	row["targetGroupId"] = dataRow.getTargetGroupId();
	row["avgMailSize"] = dataRow.getAvgMailSize();
	row["sendDate"] = dataRow.getSendDate();	
	currentrow++;
	return true;
}
return false;]]></method>
        </script-data-set>
        <script-data-set name="OptimizationSummaryDataSet" id="1266">
            <list-property name="resultSetHints">
                <structure>
                    <property name="position">1</property>
                    <property name="name">category</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">2</property>
                    <property name="name">category_index</property>
                    <property name="dataType">integer</property>
                </structure>
                <structure>
                    <property name="position">3</property>
                    <property name="name">targetgroup</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">4</property>
                    <property name="name">targetgroupId</property>
                    <property name="dataType">integer</property>
                </structure>
                <structure>
                    <property name="position">5</property>
                    <property name="name">value</property>
                    <property name="dataType">integer</property>
                </structure>
                <structure>
                    <property name="position">6</property>
                    <property name="name">rate</property>
                    <property name="dataType">float</property>
                </structure>
                <structure>
                    <property name="position">7</property>
                    <property name="name">deliveredRate</property>
                    <property name="dataType">float</property>
                </structure>
                <structure>
                    <property name="position">8</property>
                    <property name="name">mailingId</property>
                    <property name="dataType">integer</property>
                </structure>
                <structure>
                    <property name="position">9</property>
                    <property name="name">mailingName</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">10</property>
                    <property name="name">groupId</property>
                    <property name="dataType">integer</property>
                </structure>
                <structure>
                    <property name="position">11</property>
                    <property name="name">categoryKey</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">12</property>
                    <property name="name">baseMailingName</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">13</property>
                    <property name="name">isWinner</property>
                    <property name="dataType">boolean</property>
                </structure>
                <structure>
                    <property name="position">14</property>
                    <property name="name">baseGroupId</property>
                    <property name="dataType">integer</property>
                </structure>
            </list-property>
            <list-property name="columnHints">
                <structure>
                    <property name="columnName">category</property>
                </structure>
                <structure>
                    <property name="columnName">category_index</property>
                </structure>
                <structure>
                    <property name="columnName">targetgroup</property>
                </structure>
                <structure>
                    <property name="columnName">targetgroupId</property>
                </structure>
                <structure>
                    <property name="columnName">value</property>
                </structure>
                <structure>
                    <property name="columnName">rate</property>
                </structure>
                <structure>
                    <property name="columnName">deliveredRate</property>
                </structure>
                <structure>
                    <property name="columnName">mailingId</property>
                </structure>
                <structure>
                    <property name="columnName">mailingName</property>
                </structure>
                <structure>
                    <property name="columnName">groupId</property>
                </structure>
                <structure>
                    <property name="columnName">categoryKey</property>
                </structure>
                <structure>
                    <property name="columnName">baseMailingName</property>
                </structure>
                <structure>
                    <property name="columnName">isWinner</property>
                </structure>
                <structure>
                    <property name="columnName">baseGroupId</property>
                </structure>
            </list-property>
            <structure name="cachedMetaData">
                <list-property name="resultSet">
                    <structure>
                        <property name="position">1</property>
                        <property name="name">category</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">2</property>
                        <property name="name">category_index</property>
                        <property name="dataType">integer</property>
                    </structure>
                    <structure>
                        <property name="position">3</property>
                        <property name="name">targetgroup</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">4</property>
                        <property name="name">targetgroupId</property>
                        <property name="dataType">integer</property>
                    </structure>
                    <structure>
                        <property name="position">5</property>
                        <property name="name">value</property>
                        <property name="dataType">integer</property>
                    </structure>
                    <structure>
                        <property name="position">6</property>
                        <property name="name">rate</property>
                        <property name="dataType">float</property>
                    </structure>
                    <structure>
                        <property name="position">7</property>
                        <property name="name">deliveredRate</property>
                        <property name="dataType">float</property>
                    </structure>
                    <structure>
                        <property name="position">8</property>
                        <property name="name">mailingId</property>
                        <property name="dataType">integer</property>
                    </structure>
                    <structure>
                        <property name="position">9</property>
                        <property name="name">mailingName</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">10</property>
                        <property name="name">groupId</property>
                        <property name="dataType">integer</property>
                    </structure>
                    <structure>
                        <property name="position">11</property>
                        <property name="name">categoryKey</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">12</property>
                        <property name="name">baseMailingName</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">13</property>
                        <property name="name">isWinner</property>
                        <property name="dataType">boolean</property>
                    </structure>
                    <structure>
                        <property name="position">14</property>
                        <property name="name">baseGroupId</property>
                        <property name="dataType">integer</property>
                    </structure>
                </list-property>
            </structure>
            <property name="dataSource">DummyDataSource</property>
            <method name="open"><![CDATA[importPackage(Packages.com.agnitas.reporting.birt.external.dataset);
mailingSummaryData = optimizationDataSet.getTotalOptimizationSummaryData();
currentrow = 0;

currentrow = 0;

max = 0;
for (i = 0; i < mailingSummaryData.size(); i++) {
	categoryIndex = mailingSummaryData.get(i).getCategoryindex();
	value = mailingSummaryData.get(i).getCount();
	if (categoryIndex == CommonKeys.REVENUE_INDEX) {
	    value = value / 100;
	}

	if (categoryIndex <= CommonKeys.REVENUE_INDEX &amp;&amp; value > max) {
		max = value;
	}
}

reportContext.setGlobalVariable("maxValue", parseInt(max));
reportContext.setGlobalVariable("total_sent", parseInt(0));
reportContext.setGlobalVariable("total_delivered", parseInt(0));]]></method>
            <method name="fetch"><![CDATA[
importPackage(Packages.org.apache.commons.lang);
importPackage(Packages.com.agnitas.messages);
importPackage(Packages.com.agnitas.reporting.birt.external.dataset);

if( currentrow < mailingSummaryData.size() ) {
	dataRow = mailingSummaryData.get(currentrow);

	categoryIndex = dataRow.getCategoryindex();
	targetIndex = dataRow.getTargetgroupindex();
	groupId = dataRow.getGroupId();

	row["categoryKey"] = dataRow.getCategory();
	row["category_index"] = categoryIndex;
	row["groupId"] = groupId;	
	switch (categoryIndex) {
		case CommonKeys.CLICKER_PC_AND_MOBILE_INDEX:
			row["category"] = tr("statistic.clicker.multiple");
			break;
		case CommonKeys.OPENERS_PC_AND_MOBILE_INDEX:
			row["category"] = tr("report.opens.pc.and.mobileWithNote");
			break;
		case CommonKeys.OPENERS_INVISIBLE_INDEX:
			row["category"] = tr("report.opens.invisible");
			break;
		case CommonKeys.OPENERS_MEASURED_INDEX:
			row["category"] = tr("report.opens.measured");
			break;
		default:
			row["category"] = tr(dataRow.getCategory());
			break;
	}
	
	
	// do some i18n stuff
	if (targetIndex > 1) {
		row["targetgroup"] = dataRow.getTargetgroup();
	} else {
		row["targetgroup"] = tr("statistic.all_subscribers");
	}

	if (groupId == CommonKeys.OPTIMIZATION_SUMMARY_GROUP_ID) {
		if (categoryIndex == CommonKeys.DELIVERED_EMAILS_INDEX) {
			total_sent = parseInt(dataRow.getCount());
			reportContext.setGlobalVariable("total_sent", total_sent);
		}
		if (categoryIndex == CommonKeys.DELIVERED_EMAILS_DELIVERED_INDEX) {
			total_delivered = parseInt(dataRow.getCount());
			reportContext.setGlobalVariable("total_delivered", total_delivered);
		}
		row["mailingName"] = tr("Sum");
	} else if (groupId == CommonKeys.OPTIMIZATION_WINNER_GROUP_ID) {
		row["mailingName"] = tr("mailing.autooptimization");
	} else {
		row["mailingName"] = dataRow.getMailingName();
	}
	row["targetgroupId"] = dataRow.getTargetgroupindex();
	row["value"] = dataRow.getCount();
	row["rate"] = dataRow.getRate() == -1 ? 0 : dataRow.getRate();
	row["deliveredRate"] = dataRow.getDeliveredRate() == -1 ? 0 : dataRow.getDeliveredRate();
	row["mailingId"] = dataRow.getMailingId();	

	row["isWinner"] = dataRow.isWinner();
	row["baseMailingName"] = dataRow.getBaseMailingName();
	row["baseGroupId"] = dataRow.getBaseGroupId();
	currentrow++;
	return true;
}
return false;]]></method>
        </script-data-set>
    </data-sets>
    <cubes>
        <tabular-cube name="SummaryOptimizationDataCube" id="1289">
            <property name="dimensions">
                <tabular-dimension name="categoryGroup" id="1290">
                    <property name="defaultHierarchy">NewTabularHierarchy</property>
                    <property name="hierarchies">
                        <tabular-hierarchy name="NewTabularHierarchy" id="1291">
                            <property name="levels">
                                <tabular-level name="category_index" id="1292">
                                    <property name="dataType">integer</property>
                                    <property name="levelType">dynamic</property>
                                    <list-property name="attributes">
                                        <structure>
                                            <property name="name">categoryKey</property>
                                            <property name="dataType">string</property>
                                        </structure>
                                        <structure>
                                            <property name="name">category</property>
                                            <property name="dataType">string</property>
                                        </structure>
                                    </list-property>
                                    <property name="columnName">category_index</property>
                                </tabular-level>
                            </property>
                        </tabular-hierarchy>
                    </property>
                </tabular-dimension>
                <tabular-dimension name="optimizationGroup" id="1293">
                    <property name="defaultHierarchy">NewTabularHierarchy1</property>
                    <property name="hierarchies">
                        <tabular-hierarchy name="NewTabularHierarchy1" id="1294">
                            <property name="levels">
                                <tabular-level name="optimizationGroupId" id="1295">
                                    <property name="dataType">integer</property>
                                    <property name="levelType">dynamic</property>
                                    <list-property name="attributes">
                                        <structure>
                                            <property name="name">baseMailingName</property>
                                            <property name="dataType">string</property>
                                        </structure>
                                        <structure>
                                            <property name="name">isWinner</property>
                                            <property name="dataType">boolean</property>
                                        </structure>
                                        <structure>
                                            <property name="name">baseGroupId</property>
                                            <property name="dataType">integer</property>
                                        </structure>
                                        <structure>
                                            <property name="name">targetgroup</property>
                                            <property name="dataType">string</property>
                                        </structure>
                                    </list-property>
                                    <property name="columnName">groupId</property>
                                </tabular-level>
                            </property>
                        </tabular-hierarchy>
                    </property>
                </tabular-dimension>
            </property>
            <property name="measureGroups">
                <tabular-measure-group name="Summary Field" id="1296">
                    <property name="measures">
                        <tabular-measure name="value" id="1297">
                            <property name="function">max</property>
                            <property name="isCalculated">false</property>
                            <expression name="measureExpression" type="javascript">dataSetRow["value"]</expression>
                            <property name="dataType">float</property>
                            <property name="isVisible">true</property>
                        </tabular-measure>
                        <tabular-measure name="rate" id="1298">
                            <property name="function">max</property>
                            <property name="isCalculated">false</property>
                            <expression name="measureExpression" type="javascript">dataSetRow["rate"]</expression>
                            <property name="dataType">float</property>
                            <property name="isVisible">true</property>
                        </tabular-measure>
                        <tabular-measure name="deliveredRate" id="1323">
                            <property name="function">max</property>
                            <property name="isCalculated">false</property>
                            <expression name="measureExpression" type="javascript">dataSetRow["deliveredRate"]</expression>
                            <property name="dataType">float</property>
                            <property name="isVisible">true</property>
                        </tabular-measure>
                    </property>
                </tabular-measure-group>
            </property>
            <property name="dataSet">OptimizationSummaryDataSet</property>
        </tabular-cube>
    </cubes>
    <page-setup>
        <simple-master-page name="Simple MasterPage" id="2">
            <property name="type">a4</property>
            <property name="orientation">landscape</property>
            <property name="topMargin">0.25in</property>
            <property name="leftMargin">0.25in</property>
            <property name="bottomMargin">0.25in</property>
            <property name="rightMargin">0.25in</property>
        </simple-master-page>
    </page-setup>
    <body>
        <grid name="generalReportData" id="1255">
            <property name="style">block-table</property>
            <property name="fontFamily">"Arial"</property>
            <property name="width">100%</property>
            <list-property name="visibility">
                <structure>
                    <property name="format">all</property>
                    <expression name="valueExpr" type="javascript">reportContext.getOutputFormat() != "pdf" &amp;&amp; reportContext.getOutputFormat() != "html"</expression>
                </structure>
            </list-property>
            <column id="1256">
                <property name="width">4.041666666666667in</property>
            </column>
            <column id="1257">
                <property name="width">7.09375in</property>
            </column>
            <row id="1258">
                <cell id="1259">
                    <property name="style">half-width</property>
                    <table name="generalData" id="1187">
                        <property name="style">table table-striped</property>
                        <property name="display">block</property>
                        <property name="width">100%</property>
                        <property name="dataSet">OptimizationMailingDataSet</property>
                        <list-property name="boundDataColumns">
                            <structure>
                                <property name="name">targetGroupName</property>
                                <text-property name="displayName">targetGroupName</text-property>
                                <expression name="expression" type="javascript">dataSetRow["targetGroupName"]</expression>
                                <property name="dataType">string</property>
                            </structure>
                            <structure>
                                <property name="name">isWinner</property>
                                <text-property name="displayName">isWinner</text-property>
                                <expression name="expression" type="javascript">dataSetRow["isWinner"]</expression>
                                <property name="dataType">boolean</property>
                            </structure>
                            <structure>
                                <property name="name">resultMailing</property>
                                <text-property name="displayName">resultMailing</text-property>
                                <expression name="expression" type="javascript">dataSetRow["resultMailing"]</expression>
                                <property name="dataType">integer</property>
                            </structure>
                            <structure>
                                <property name="name">groupId</property>
                                <text-property name="displayName">groupId</text-property>
                                <expression name="expression" type="javascript">dataSetRow["groupId"]</expression>
                                <property name="dataType">integer</property>
                            </structure>
                            <structure>
                                <property name="name">avgMailSize</property>
                                <text-property name="displayName">avgMailSize</text-property>
                                <expression name="expression" type="javascript">dataSetRow["avgMailSize"]</expression>
                                <property name="dataType">float</property>
                            </structure>
                            <structure>
                                <property name="name">mailingSubject</property>
                                <expression name="expression" type="javascript">dataSetRow["subject"]</expression>
                                <property name="dataType">string</property>
                                <property name="allowExport">true</property>
                            </structure>
                            <structure>
                                <property name="name">mailingName</property>
                                <text-property name="displayName">mailingName</text-property>
                                <expression name="expression" type="javascript">dataSetRow["mailingName"]</expression>
                                <property name="dataType">string</property>
                                <property name="allowExport">true</property>
                            </structure>
                            <structure>
                                <property name="name">mailingId</property>
                                <text-property name="displayName">mailingId</text-property>
                                <expression name="expression" type="javascript">dataSetRow["mailingId"]</expression>
                                <property name="dataType">integer</property>
                            </structure>
                            <structure>
                                <property name="name">targetGroupId</property>
                                <text-property name="displayName">targetGroupId</text-property>
                                <expression name="expression" type="javascript">dataSetRow["targetGroupId"]</expression>
                                <property name="dataType">integer</property>
                            </structure>
                            <structure>
                                <property name="name">subjectPrefix</property>
                                <expression name="expression" type="javascript">tr("mailing.Subject")</expression>
                                <property name="dataType">string</property>
                                <property name="allowExport">true</property>
                            </structure>
                            <structure>
                                <property name="name">mailingSubjectName</property>
                                <expression name="expression" type="javascript">if (row["isWinner"]) {tr("resultMailing")} else {row["mailingName"]}</expression>
                                <property name="dataType">string</property>
                                <property name="allowExport">true</property>
                            </structure>
                            <structure>
                                <property name="name">senDate</property>
                                <expression name="expression" type="javascript">if (dataSetRow["sendDate"] == null) {tr("statistic.DeliveryStatus.0")} else {formatDate(dataSetRow["sendDate"])}</expression>
                                <property name="dataType">string</property>
                                <property name="allowExport">true</property>
                            </structure>
                            <structure>
                                <property name="name">namePrefix</property>
                                <expression name="expression" type="javascript">tr("Mailing")</expression>
                                <property name="dataType">string</property>
                                <property name="allowExport">true</property>
                            </structure>
                        </list-property>
                        <list-property name="sort">
                            <structure>
                                <expression name="key" type="javascript">row["groupId"]</expression>
                                <property name="direction">asc</property>
                                <property name="strength">-1</property>
                            </structure>
                        </list-property>
                        <list-property name="filter">
                            <structure>
                                <property name="operator">ne</property>
                                <expression name="expr" type="javascript">row["groupId"]</expression>
                                <simple-property-list name="value1">
                                    <value>CommonKeys.OPTIMIZATION_SUMMARY_GROUP_ID</value>
                                </simple-property-list>
                                <property name="updateAggregation">true</property>
                            </structure>
                        </list-property>
                        <column id="1221"/>
                        <column id="1222"/>
                        <header>
                            <row id="1879">
                                <property name="style">table-head</property>
                                <cell id="1880">
                                    <text-data id="1227">
                                        <property name="textAlign">left</property>
                                        <expression name="valueExpr">tr("General2")</expression>
                                    </text-data>
                                </cell>
                                <cell id="1881"/>
                            </row>
                            <row id="1188">
                                <cell id="1189">
                                    <text-data id="1882">
                                        <property name="textAlign">left</property>
                                        <expression name="valueExpr">tr("birt.Target")</expression>
                                        <property name="contentType">html</property>
                                    </text-data>
                                </cell>
                                <cell id="1191">
                                    <data id="1887">
                                        <property name="textAlign">left</property>
                                        <property name="resultSetColumn">targetGroupName</property>
                                    </data>
                                </cell>
                            </row>
                        </header>
                        <detail>
                            <row id="1201">
                                <cell id="1202">
                                    <data id="1888">
                                        <property name="display">inline</property>
                                        <property name="resultSetColumn">namePrefix</property>
                                    </data>
                                    <data id="1889">
                                        <property name="fontWeight">bold</property>
                                        <property name="display">inline</property>
                                        <property name="resultSetColumn">mailingSubjectName</property>
                                    </data>
                                </cell>
                                <cell id="1204">
                                    <data id="1885">
                                        <property name="resultSetColumn">mailingSubject</property>
                                    </data>
                                </cell>
                            </row>
                            <row id="1229">
                                <cell id="1230">
                                    <text-data id="1244">
                                        <expression name="valueExpr">tr("report.mailsize")</expression>
                                    </text-data>
                                </cell>
                                <cell id="1231">
                                    <data id="1886">
                                        <property name="resultSetColumn">avgMailSize</property>
                                    </data>
                                </cell>
                            </row>
                            <row id="1895">
                                <cell id="1896">
                                    <text-data id="1901">
                                        <expression name="valueExpr">tr('mailing.senddate')</expression>
                                        <property name="contentType">html</property>
                                    </text-data>
                                </cell>
                                <cell id="1897">
                                    <data id="1903">
                                        <property name="resultSetColumn">senDate</property>
                                    </data>
                                </cell>
                            </row>
                        </detail>
                    </table>
                </cell>
                <cell id="1260">
                    <property name="style">half-width</property>
                    <grid id="1261">
                        <property name="style">table</property>
                        <property name="dataSet">OptimizationSummaryDataSet</property>
                        <list-property name="boundDataColumns">
                            <structure>
                                <property name="name">category</property>
                                <text-property name="displayName">category</text-property>
                                <expression name="expression" type="javascript">dataSetRow["category"]</expression>
                                <property name="dataType">string</property>
                            </structure>
                            <structure>
                                <property name="name">category_index</property>
                                <text-property name="displayName">category_index</text-property>
                                <expression name="expression" type="javascript">dataSetRow["category_index"]</expression>
                                <property name="dataType">integer</property>
                            </structure>
                            <structure>
                                <property name="name">targetgroup</property>
                                <text-property name="displayName">targetgroup</text-property>
                                <expression name="expression" type="javascript">dataSetRow["targetgroup"]</expression>
                                <property name="dataType">string</property>
                            </structure>
                            <structure>
                                <property name="name">targetgroupId</property>
                                <text-property name="displayName">targetgroupId</text-property>
                                <expression name="expression" type="javascript">dataSetRow["targetgroupId"]</expression>
                                <property name="dataType">integer</property>
                            </structure>
                            <structure>
                                <property name="name">value</property>
                                <text-property name="displayName">value</text-property>
                                <expression name="expression" type="javascript">dataSetRow["value"]</expression>
                                <property name="dataType">integer</property>
                            </structure>
                            <structure>
                                <property name="name">rate</property>
                                <text-property name="displayName">rate</text-property>
                                <expression name="expression" type="javascript">dataSetRow["rate"]</expression>
                                <property name="dataType">float</property>
                            </structure>
                            <structure>
                                <property name="name">deliveredRate</property>
                                <text-property name="displayName">deliveredRate</text-property>
                                <expression name="expression" type="javascript">dataSetRow["deliveredRate"]</expression>
                                <property name="dataType">float</property>
                            </structure>
                            <structure>
                                <property name="name">mailingId</property>
                                <text-property name="displayName">mailingId</text-property>
                                <expression name="expression" type="javascript">dataSetRow["mailingId"]</expression>
                                <property name="dataType">integer</property>
                            </structure>
                            <structure>
                                <property name="name">mailingName</property>
                                <text-property name="displayName">mailingName</text-property>
                                <expression name="expression" type="javascript">dataSetRow["mailingName"]</expression>
                                <property name="dataType">string</property>
                            </structure>
                            <structure>
                                <property name="name">groupId</property>
                                <text-property name="displayName">groupId</text-property>
                                <expression name="expression" type="javascript">dataSetRow["groupId"]</expression>
                                <property name="dataType">integer</property>
                            </structure>
                            <structure>
                                <property name="name">categoryKey</property>
                                <text-property name="displayName">categoryKey</text-property>
                                <expression name="expression" type="javascript">dataSetRow["categoryKey"]</expression>
                                <property name="dataType">string</property>
                            </structure>
                            <structure>
                                <property name="name">tooltip</property>
                                <expression name="expression" type="javascript">getSeriesTooltips(dataSetRow["categoryKey"], dataSetRow["value"], dataSetRow["rate"])</expression>
                                <property name="dataType">string</property>
                                <property name="allowExport">true</property>
                            </structure>
                        </list-property>
                        <structure name="toc"/>
                        <column id="1262"/>
                        <row id="1263">
                            <cell id="1264">
                                <extended-item extensionName="Chart" name="summaryData" id="1088">
                                    <xml-property name="xmlRepresentation"><![CDATA[<model:ChartWithAxes xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:attribute="http://www.birt.eclipse.org/ChartModelAttribute" xmlns:data="http://www.birt.eclipse.org/ChartModelData" xmlns:layout="http://www.birt.eclipse.org/ChartModelLayout" xmlns:model="http://www.birt.eclipse.org/ChartModel" xmlns:type="http://www.birt.eclipse.org/ChartModelType">
  <Version>2.6.1</Version>
  <Type>Bar Chart</Type>
  <SubType>Side-by-side</SubType>
  <Description>
    <Value></Value>
    <Font>
      <Alignment/>
    </Font>
  </Description>
  <Block>
    <Children xsi:type="layout:TitleBlock">
      <Bounds>
        <Left>0.0</Left>
        <Top>0.0</Top>
        <Width>0.0</Width>
        <Height>0.0</Height>
      </Bounds>
      <Insets>
        <Top>3.0</Top>
        <Left>3.0</Left>
        <Bottom>3.0</Bottom>
        <Right>3.0</Right>
      </Insets>
      <Row>-1</Row>
      <Column>-1</Column>
      <Rowspan>-1</Rowspan>
      <Columnspan>-1</Columnspan>
      <Outline>
        <Style>Solid</Style>
        <Thickness>1</Thickness>
        <Color>
          <Transparency>255</Transparency>
          <Red>0</Red>
          <Green>0</Green>
          <Blue>0</Blue>
        </Color>
        <Visible>false</Visible>
      </Outline>
      <Visible>false</Visible>
      <Label>
        <Caption>
          <Value>Bar Chart Title</Value>
          <Font>
            <Size>16.0</Size>
            <Bold>true</Bold>
            <Alignment>
              <horizontalAlignment>Center</horizontalAlignment>
              <verticalAlignment>Center</verticalAlignment>
            </Alignment>
          </Font>
        </Caption>
        <Background xsi:type="attribute:ColorDefinition">
          <Transparency>0</Transparency>
          <Red>255</Red>
          <Green>255</Green>
          <Blue>255</Blue>
        </Background>
        <Outline>
          <Style>Solid</Style>
          <Thickness>1</Thickness>
          <Color>
            <Transparency>255</Transparency>
            <Red>0</Red>
            <Green>0</Green>
            <Blue>0</Blue>
          </Color>
        </Outline>
        <Insets>
          <Top>0.0</Top>
          <Left>2.0</Left>
          <Bottom>0.0</Bottom>
          <Right>3.0</Right>
        </Insets>
        <Visible>true</Visible>
      </Label>
    </Children>
    <Children xsi:type="layout:Plot">
      <Bounds>
        <Left>0.0</Left>
        <Top>0.0</Top>
        <Width>0.0</Width>
        <Height>0.0</Height>
      </Bounds>
      <Insets>
        <Top>0.0</Top>
        <Left>0.0</Left>
        <Bottom>0.0</Bottom>
        <Right>30.0</Right>
      </Insets>
      <Row>-1</Row>
      <Column>-1</Column>
      <Rowspan>-1</Rowspan>
      <Columnspan>-1</Columnspan>
      <Outline>
        <Style>Solid</Style>
        <Thickness>1</Thickness>
        <Color>
          <Transparency>255</Transparency>
          <Red>0</Red>
          <Green>0</Green>
          <Blue>0</Blue>
        </Color>
        <Visible>false</Visible>
      </Outline>
      <Visible>true</Visible>
      <HorizontalSpacing>0</HorizontalSpacing>
      <VerticalSpacing>20</VerticalSpacing>
      <ClientArea>
        <Outline>
          <Style>Solid</Style>
          <Thickness>0</Thickness>
          <Color>
            <Transparency>255</Transparency>
            <Red>0</Red>
            <Green>0</Green>
            <Blue>0</Blue>
          </Color>
          <Visible>false</Visible>
        </Outline>
        <ShadowColor>
          <Transparency>0</Transparency>
          <Red>255</Red>
          <Green>255</Green>
          <Blue>255</Blue>
        </ShadowColor>
        <Insets>
          <Top>0.0</Top>
          <Left>0.0</Left>
          <Bottom>0.0</Bottom>
          <Right>30.0</Right>
        </Insets>
      </ClientArea>
    </Children>
    <Children xsi:type="layout:Legend">
      <Bounds>
        <Left>0.0</Left>
        <Top>0.0</Top>
        <Width>0.0</Width>
        <Height>0.0</Height>
      </Bounds>
      <Anchor>West</Anchor>
      <Stretch>Horizontal</Stretch>
      <Insets>
        <Top>3.0</Top>
        <Left>3.0</Left>
        <Bottom>5.0</Bottom>
        <Right>3.0</Right>
      </Insets>
      <Row>-1</Row>
      <Column>-1</Column>
      <Rowspan>-1</Rowspan>
      <Columnspan>-1</Columnspan>
      <Outline>
        <Style>Solid</Style>
        <Thickness>1</Thickness>
        <Color>
          <Transparency>255</Transparency>
          <Red>0</Red>
          <Green>0</Green>
          <Blue>0</Blue>
        </Color>
        <Visible>false</Visible>
      </Outline>
      <Background xsi:type="attribute:ColorDefinition">
        <Transparency>0</Transparency>
        <Red>255</Red>
        <Green>255</Green>
        <Blue>255</Blue>
      </Background>
      <Visible>true</Visible>
      <Triggers>
        <Condition>onclick</Condition>
        <Action>
          <Type>Toggle_Visibility</Type>
          <Value xsi:type="attribute:SeriesValue">
            <Name></Name>
          </Value>
        </Action>
      </Triggers>
      <Cursor>
        <Type>Pointer</Type>
      </Cursor>
      <ClientArea>
        <Outline>
          <Style>Solid</Style>
          <Thickness>0</Thickness>
          <Color>
            <Transparency>255</Transparency>
            <Red>0</Red>
            <Green>0</Green>
            <Blue>0</Blue>
          </Color>
          <Visible>false</Visible>
        </Outline>
        <Insets>
          <Top>2.0</Top>
          <Left>2.0</Left>
          <Bottom>2.0</Bottom>
          <Right>100.0</Right>
        </Insets>
      </ClientArea>
      <Text>
        <Value></Value>
        <Font>
          <Name>Arial</Name>
          <Size>10.0</Size>
          <Alignment/>
        </Font>
      </Text>
      <Orientation>Horizontal</Orientation>
      <Direction>Left_Right</Direction>
      <Separator>
        <Style>Solid</Style>
        <Thickness>1</Thickness>
        <Color>
          <Transparency>255</Transparency>
          <Red>255</Red>
          <Green>0</Green>
          <Blue>0</Blue>
        </Color>
        <Visible>false</Visible>
      </Separator>
      <Position>Above</Position>
      <ItemType>Series</ItemType>
      <Title>
        <Caption>
          <Value></Value>
          <Font>
            <Alignment/>
          </Font>
        </Caption>
        <Background xsi:type="attribute:ColorDefinition">
          <Transparency>0</Transparency>
          <Red>255</Red>
          <Green>255</Green>
          <Blue>255</Blue>
        </Background>
        <Outline>
          <Style>Solid</Style>
          <Thickness>1</Thickness>
          <Color>
            <Transparency>255</Transparency>
            <Red>0</Red>
            <Green>0</Green>
            <Blue>0</Blue>
          </Color>
          <Visible>false</Visible>
        </Outline>
        <Insets>
          <Top>0.0</Top>
          <Left>2.0</Left>
          <Bottom>0.0</Bottom>
          <Right>3.0</Right>
        </Insets>
        <Visible>false</Visible>
      </Title>
      <TitlePosition>Above</TitlePosition>
      <ShowValue>false</ShowValue>
      <WrappingSize>0.0</WrappingSize>
      <MaxPercent>0.33</MaxPercent>
      <TitlePercent>0.6</TitlePercent>
      <Ellipsis>40</Ellipsis>
    </Children>
    <Bounds>
      <Left>0.0</Left>
      <Top>0.0</Top>
      <Width>501.0</Width>
      <Height>270.0</Height>
    </Bounds>
    <Insets>
      <Top>0.0</Top>
      <Left>0.0</Left>
      <Bottom>0.0</Bottom>
      <Right>0.0</Right>
    </Insets>
    <Row>-1</Row>
    <Column>-1</Column>
    <Rowspan>-1</Rowspan>
    <Columnspan>-1</Columnspan>
    <Outline>
      <Style>Solid</Style>
      <Thickness>1</Thickness>
      <Color>
        <Transparency>255</Transparency>
        <Red>0</Red>
        <Green>0</Green>
        <Blue>0</Blue>
      </Color>
      <Visible>false</Visible>
    </Outline>
    <Background xsi:type="attribute:ColorDefinition">
      <Transparency>0</Transparency>
      <Red>255</Red>
      <Green>255</Green>
      <Blue>255</Blue>
    </Background>
    <Visible>true</Visible>
    <Cursor>
      <Type>Auto</Type>
    </Cursor>
  </Block>
  <Dimension>Two_Dimensional</Dimension>
  <Script>importPackage(Packages.org.eclipse.birt.chart.model.attribute.impl);
importPackage(Packages.org.eclipse.birt.chart.model.attribute);
importPackage(Packages.org.eclipse.birt.report.model.api.util);
importPackage(Packages.org.eclipse.birt.chart.model.data.impl);
importPackage(Packages.org.eclipse.birt.chart.computation);
importPackage(Packages.com.agnitas.messages);
importPackage(Packages.com.agnitas.reporting.birt.external.dataset);
importPackage(Packages.java.util);
importPackage(Packages.java.text);
importPackage(Packages.org.apache.commons.lang3);

var	ignoredBarIndexes = {}

/**
 * Called before generation of chart model to GeneratedChartState.
 *
 * @param chart Chart
 * @param icsc IChartScriptContext
 */
function beforeGeneration(chart, icsc) {
	var reportContext = icsc.getExternalContext().getObject();
	var externalScriptableContext = icsc.getExternalContext().getScriptable();

	// global functions
	var hasPercentageRepresentation = externalScriptableContext.getGlobalVariable(&quot;hasPercentageRepresentationFunction&quot;);

	var xAxis = chart.getAxes().get(0);
	var xSeriesDefinition = xAxis.getSeriesDefinitions().get(0);
	var xValues = xSeriesDefinition.getRunTimeSeries().get(0).getDataSet().getValues();

	for (i = 0; i &lt; xValues.length; i++) {
 		 categoryKey = xValues[i];

 		 // find out indexes of ignored burs.
 		 // uses in beforeDrawDataPointLabel method
 		 if (!hasPercentageRepresentation(categoryKey)) {
 		 	ignoredBarIndexes[i] = 0;
 		 }
	}
	chart.setSeriesThickness(60);
	
	//max = reportContext.getPersistentGlobalVariable(&quot;total_sent&quot;);
	max = reportContext.getPersistentGlobalVariable(&quot;maxValue&quot;);
	if (max > 0) {
		yAxis = chart.getOrthogonalAxes(chart.getBaseAxes()[0], true)[0];
		yscale = yAxis.getScale();
		yscale.setMax(NumberDataElementImpl.create(max * 1.25));
		yscale.setMin(NumberDataElementImpl.create(0));
		yAxis.setScale(yscale);
	}
};

/**
 * Called before rendering the label for each datapoint.
 *
 * @param dph DataPointHints
 * @param label Label
 * @param icsc IChartScriptContext
 */
function beforeDrawDataPointLabel(dph, label, icsc) {
	var reportContext = icsc.getExternalContext().getObject();
	var externalScriptableContext = icsc.getExternalContext().getScriptable();
	var calculatePercent = icsc.getExternalContext().getScriptable().getGlobalVariable(&quot;calculatePercentFunction&quot;);
	var formatPercent = icsc.getExternalContext().getScriptable().getGlobalVariable(&quot;formatPercentFunction&quot;);	
	var getGroupIdByName = icsc.getExternalContext().getScriptable().getGlobalVariable(&quot;getGroupIdByNameFunction&quot;);

	
	var values = new String(label.getCaption().getValue()).split(&quot;;&quot;);
	groupId = getGroupIdByName(values[1]); //get group ID from name
	var currentValue = values[0]; // series value		

	if (groupId != CommonKeys.OPTIMIZATION_SUMMARY_GROUP_ID) {
		//do not show series label for other groups ids
		label.getCaption().setValue('');
	} else if (!(dph.getIndex() in ignoredBarIndexes)) {		
		// code to display the percent value
		var totalSent = new Number(parseInt(reportContext.getGlobalVariable(&quot;total_sent&quot;)));
		var totalDelivered = new Number(parseInt(getGlobalVariable(&quot;total_delivered&quot;)));
		
		curValue = Packages.java.text.NumberFormat.getNumberInstance(getLocale()).parse(currentValue);
		var percent = 0;
		if(curValue >= totalDelivered){
			percent = calculatePercent(curValue, totalSent);
		} else {
			percent = calculatePercent(curValue, totalDelivered);
		}
		label.getCaption().setValue(formatPercent(percent) + '%; ' + currentValue);
	} else {
		label.getCaption().setValue(currentValue);
	}
	
	if(reportContext.getGlobalVariable(&quot;isDarkmode&quot;) == true){
		label.getCaption().getColor().set(255, 255, 255);
	}
};

/**
 * Called before drawing each datapoint graphical representation or marker.
 *
 * @param dph
 *            DataPointHints
 * @param fill
 *            Fill
 * @param icsc
 *            IChartScriptContext
 */

function beforeDrawDataPoint( dph, fill, icsc )
{
	var getPaletteColor = icsc.getExternalContext().getScriptable().getGlobalVariable(&quot;getPaletteColorByGroupIdFunction&quot;);
	var getGroupIdByName = icsc.getExternalContext().getScriptable().getGlobalVariable(&quot;getGroupIdByNameFunction&quot;);

	var context = icsc.getExternalContext().getObject();
	var groupId = getGroupIdByName(dph.getSeriesDisplayValue());
	var color = getPaletteColor(groupId);
	fill.set(color.getRed(), color.getGreen(), color.getBlue());
}

/**
 * Called before rendering each label on a given Axis.
 * 
 * @param axis
 *            Axis
 * @param label
 *            Label
 * @param icsc
 *            IChartScriptContext
 */

function beforeDrawAxisLabel( axis, label, icsc )
{
	var reportContext = icsc.getExternalContext().getObject();
	var getTranslationByCategory = icsc.getExternalContext().getScriptable().getGlobalVariable(&quot;getTranslationByCategoryFunction&quot;);

	importPackage(Packages.org.eclipse.birt.chart.model.attribute);
	if (axis.getType() == AxisType.TEXT_LITERAL){
		 // replace translation key to translation
		caption = label.getCaption();
		 
		var translated = StringUtils.abbreviate(getTranslationByCategory(caption.getValue()), 30);
	 	caption.setValue(translated);
	 	axis.setLabel(label);
	}
	
	if(reportContext.getGlobalVariable(&quot;isDarkmode&quot;) == true){
		label.getCaption().getColor().set(255, 255, 255);
	}
}

/**
 * Called before drawing the legend item.
 * 
 * @param lerh
 * 			  LegendEntryRenderingHints
 * @param bounds
 * 			  Bounds
 * @param icsc
 * 			  IChartScriptContext
 * @since Version 2.2.0
 */

function beforeDrawLegendItem( lerh, bounds, icsc )
{
	var reportContext = icsc.getExternalContext().getObject();
	var getPaletteColor = icsc.getExternalContext().getScriptable().getGlobalVariable(&quot;getPaletteColorByGroupIdFunction&quot;);
	var getGroupIdByName = icsc.getExternalContext().getScriptable().getGlobalVariable(&quot;getGroupIdByNameFunction&quot;);

	var curr = lerh.getLabel().getCaption();
	var name = curr.getValue();
	
	groupId = getGroupIdByName(name);
	lerh.getLabel().getCaption().setValue(StringUtils.abbreviate(name, 35));
		
	var color = getPaletteColor(groupId);
	lerh.getFill().set(color.getRed(), color.getGreen(), color.getBlue());
	
	if(reportContext.getGlobalVariable(&quot;isDarkmode&quot;) == true){
		curr.getColor().set(255, 255, 255);
	}
}

/**
 * Called before the chart is rendered.
 * 
 * @param gcs
 *            GeneratedChartState
 * @param icsc
 *            IChartScriptContext
 */
function beforeRendering( gcs, icsc )
{
	rtc = gcs.getRunTimeContext();
	llh = rtc.getLegendLayoutHints();
	liha = llh.getLegendItemHints();
	
	pointToPixel = gcs.getComputations().getPointToPixel();
	plotWidth = gcs.getComputations().getPlotBounds().getWidth() * pointToPixel;
	
	var rowsNum = parseInt(liha.length / 2) + liha.length % 2;
	width = (plotWidth / 2.0) - 17.42;
	height = liha[0].getItemHeight() + 5.33;
	
	for (var i = 0; i &lt; liha.length; i++) {
		lih = liha[i];
		var row = parseInt(i / 2);
		var col = i % 2;		
		
		lih.width(width);
		lih.top(row * height);
		lih.left(col * width);
	}
	
	legendLength = height * rowsNum;
	llhNew = new LegendLayoutHints(SizeImpl.create(plotWidth, legendLength), llh.getTitleSize(), null, llh.isMinSliceApplied(), llh.getMinSliceText(), liha);
	
	rtc.setLegendLayoutHints(llhNew);
}</Script>
  <Units>Points</Units>
  <SeriesThickness>10.0</SeriesThickness>
  <GridColumnCount>0</GridColumnCount>
  <ExtendedProperties>
    <Name>enable.area.alt</Name>
    <Value>false</Value>
  </ExtendedProperties>
  <SampleData>
    <BaseSampleData>
      <DataSetRepresentation>'A','B','C','D','E'</DataSetRepresentation>
    </BaseSampleData>
    <OrthogonalSampleData>
      <DataSetRepresentation>6,4,12,8,10</DataSetRepresentation>
      <SeriesDefinitionIndex>0</SeriesDefinitionIndex>
    </OrthogonalSampleData>
    <AncillarySampleData>
      <DataSetRepresentation>Series 1</DataSetRepresentation>
    </AncillarySampleData>
  </SampleData>
  <Interactivity>
    <Enable>true</Enable>
    <LegendBehavior>None</LegendBehavior>
  </Interactivity>
  <EmptyMessage>
    <Caption>
      <Value>No data available.</Value>
      <Font>
        <Alignment>
          <horizontalAlignment>Center</horizontalAlignment>
          <verticalAlignment>Center</verticalAlignment>
        </Alignment>
      </Font>
    </Caption>
    <Background xsi:type="attribute:ColorDefinition">
      <Transparency>64</Transparency>
      <Red>127</Red>
      <Green>127</Green>
      <Blue>127</Blue>
    </Background>
    <Outline>
      <Color>
        <Transparency>128</Transparency>
        <Red>127</Red>
        <Green>127</Green>
        <Blue>127</Blue>
      </Color>
      <Visible>true</Visible>
    </Outline>
    <Insets>
      <Top>10.0</Top>
      <Left>10.0</Left>
      <Bottom>10.0</Bottom>
      <Right>10.0</Right>
    </Insets>
    <Visible>true</Visible>
  </EmptyMessage>
  <Axes>
    <Type>Text</Type>
    <Title>
      <Caption>
        <Value>X-Axis Title</Value>
        <Font>
          <Size>14.0</Size>
          <Bold>true</Bold>
          <Alignment>
            <horizontalAlignment>Center</horizontalAlignment>
            <verticalAlignment>Center</verticalAlignment>
          </Alignment>
          <Rotation>0.0</Rotation>
        </Font>
      </Caption>
      <Background xsi:type="attribute:ColorDefinition">
        <Transparency>0</Transparency>
        <Red>255</Red>
        <Green>255</Green>
        <Blue>255</Blue>
      </Background>
      <Outline>
        <Style>Solid</Style>
        <Thickness>1</Thickness>
        <Color>
          <Transparency>255</Transparency>
          <Red>0</Red>
          <Green>0</Green>
          <Blue>0</Blue>
        </Color>
      </Outline>
      <Insets>
        <Top>0.0</Top>
        <Left>2.0</Left>
        <Bottom>0.0</Bottom>
        <Right>3.0</Right>
      </Insets>
      <Visible>false</Visible>
    </Title>
    <TitlePosition>Below</TitlePosition>
    <AssociatedAxes>
      <Type>Linear</Type>
      <Title>
        <Caption>
          <Value>Y-Axis Title</Value>
          <Font>
            <Size>14.0</Size>
            <Bold>true</Bold>
            <Alignment>
              <horizontalAlignment>Center</horizontalAlignment>
              <verticalAlignment>Center</verticalAlignment>
            </Alignment>
            <Rotation>90.0</Rotation>
          </Font>
        </Caption>
        <Background xsi:type="attribute:ColorDefinition">
          <Transparency>0</Transparency>
          <Red>255</Red>
          <Green>255</Green>
          <Blue>255</Blue>
        </Background>
        <Outline>
          <Style>Solid</Style>
          <Thickness>1</Thickness>
          <Color>
            <Transparency>255</Transparency>
            <Red>0</Red>
            <Green>0</Green>
            <Blue>0</Blue>
          </Color>
        </Outline>
        <Insets>
          <Top>0.0</Top>
          <Left>2.0</Left>
          <Bottom>0.0</Bottom>
          <Right>3.0</Right>
        </Insets>
        <Visible>false</Visible>
      </Title>
      <TitlePosition>Left</TitlePosition>
      <SeriesDefinitions ZOrder="0">
        <Query>
          <Definition>row[&quot;mailingName&quot;]</Definition>
          <Grouping>
            <GroupingInterval>1.0</GroupingInterval>
            <GroupType>Text</GroupType>
          </Grouping>
        </Query>
        <SeriesPalette>
          <Entries xsi:type="attribute:ColorDefinition">
            <Transparency>255</Transparency>
            <Red>46</Red>
            <Green>52</Green>
            <Blue>54</Blue>
          </Entries>
          <Entries xsi:type="attribute:ColorDefinition">
            <Transparency>255</Transparency>
            <Red>136</Red>
            <Green>138</Green>
            <Blue>133</Blue>
          </Entries>
          <Entries xsi:type="attribute:ColorDefinition">
            <Transparency>255</Transparency>
            <Red>255</Red>
            <Green>192</Green>
            <Blue>0</Blue>
          </Entries>
          <Entries xsi:type="attribute:ColorDefinition">
            <Transparency>255</Transparency>
            <Red>146</Red>
            <Green>208</Green>
            <Blue>79</Blue>
          </Entries>
          <Entries xsi:type="attribute:ColorDefinition">
            <Transparency>255</Transparency>
            <Red>0</Red>
            <Green>153</Green>
            <Blue>153</Blue>
          </Entries>
          <Entries xsi:type="attribute:ColorDefinition">
            <Transparency>255</Transparency>
            <Red>65</Red>
            <Green>100</Green>
            <Blue>26</Blue>
          </Entries>
          <Entries xsi:type="attribute:ColorDefinition">
            <Transparency>255</Transparency>
            <Red>0</Red>
            <Green>113</Green>
            <Blue>185</Blue>
          </Entries>
        </SeriesPalette>
        <Series xsi:type="type:BarSeries">
          <Visible>true</Visible>
          <Label>
            <Caption>
              <Value></Value>
              <Font>
                <Name>Arial</Name>
                <Size>10.0</Size>
                <Alignment/>
              </Font>
              <Color>
                <Transparency>255</Transparency>
                <Red>79</Red>
                <Green>80</Green>
                <Blue>81</Blue>
              </Color>
            </Caption>
            <Background xsi:type="attribute:ColorDefinition">
              <Transparency>0</Transparency>
              <Red>255</Red>
              <Green>255</Green>
              <Blue>255</Blue>
            </Background>
            <Outline>
              <Style>Solid</Style>
              <Thickness>1</Thickness>
              <Color>
                <Transparency>255</Transparency>
                <Red>0</Red>
                <Green>0</Green>
                <Blue>0</Blue>
              </Color>
              <Visible>false</Visible>
            </Outline>
            <ShadowColor>
              <Transparency>0</Transparency>
              <Red>255</Red>
              <Green>255</Green>
              <Blue>255</Blue>
            </ShadowColor>
            <Insets>
              <Top>0.0</Top>
              <Left>10.0</Left>
              <Bottom>0.0</Bottom>
              <Right>3.0</Right>
            </Insets>
            <Visible>true</Visible>
          </Label>
          <DataDefinition>
            <Definition>row[&quot;value&quot;] > 0 ? (row[&quot;category_index&quot;] != CommonKeys.REVENUE_INDEX ? row[&quot;value&quot;] : row[&quot;value&quot;]/100) : 0.000001</Definition>
            <Grouping>
              <GroupType>Text</GroupType>
              <AggregateExpression>Sum</AggregateExpression>
            </Grouping>
          </DataDefinition>
          <SeriesIdentifier>Series1</SeriesIdentifier>
          <DataPoint>
            <Components>
              <Type>Orthogonal_Value</Type>
            </Components>
            <Components>
              <Type>Series_Value</Type>
            </Components>
            <Suffix></Suffix>
            <Separator>;</Separator>
          </DataPoint>
          <LabelPosition>Outside</LabelPosition>
          <Stacked>false</Stacked>
          <Triggers>
            <Condition>onmouseover</Condition>
            <Action>
              <Type>Show_Tooltip</Type>
              <Value xsi:type="attribute:TooltipValue">
                <Text>row[&quot;tooltip&quot;]</Text>
                <Delay>200</Delay>
              </Value>
            </Action>
          </Triggers>
          <Cursor>
            <Type>Auto</Type>
          </Cursor>
          <Riser>Rectangle</Riser>
          <RiserOutline>
            <Transparency>0</Transparency>
            <Red>255</Red>
            <Green>255</Green>
            <Blue>255</Blue>
          </RiserOutline>
        </Series>
        <Grouping>
          <Enabled>false</Enabled>
          <GroupingInterval>1.0</GroupingInterval>
          <GroupType>Text</GroupType>
          <AggregateExpression>Sum</AggregateExpression>
        </Grouping>
        <Sorting>Descending</Sorting>
        <SortKey>
          <Definition>getKeyFiguresColumnPositionByName(row[&quot;mailingName&quot;])</Definition>
        </SortKey>
      </SeriesDefinitions>
      <Orientation>Vertical</Orientation>
      <LineAttributes>
        <Style>Solid</Style>
        <Thickness>1</Thickness>
        <Color>
          <Transparency>255</Transparency>
          <Red>128</Red>
          <Green>128</Green>
          <Blue>128</Blue>
        </Color>
        <Visible>true</Visible>
      </LineAttributes>
      <Label>
        <Caption>
          <Value></Value>
          <Font>
            <Name>Arial</Name>
            <Size>10.0</Size>
            <Alignment/>
          </Font>
          <Color>
            <Transparency>255</Transparency>
            <Red>79</Red>
            <Green>80</Green>
            <Blue>81</Blue>
          </Color>
        </Caption>
        <Background xsi:type="attribute:ColorDefinition">
          <Transparency>0</Transparency>
          <Red>255</Red>
          <Green>255</Green>
          <Blue>255</Blue>
        </Background>
        <Outline>
          <Style>Solid</Style>
          <Thickness>1</Thickness>
          <Color>
            <Transparency>255</Transparency>
            <Red>0</Red>
            <Green>0</Green>
            <Blue>0</Blue>
          </Color>
        </Outline>
        <Insets>
          <Top>10.0</Top>
          <Left>2.0</Left>
          <Bottom>0.0</Bottom>
          <Right>3.0</Right>
        </Insets>
        <Visible>true</Visible>
      </Label>
      <FormatSpecifier xsi:type="attribute:NumberFormatSpecifier">
        <Prefix></Prefix>
        <Suffix></Suffix>
        <FractionDigits>0</FractionDigits>
      </FormatSpecifier>
      <LabelPosition>Left</LabelPosition>
      <MajorGrid>
        <LineAttributes>
          <Style>Solid</Style>
          <Thickness>1</Thickness>
          <Color>
            <Transparency>255</Transparency>
            <Red>196</Red>
            <Green>196</Green>
            <Blue>196</Blue>
          </Color>
          <Visible>false</Visible>
        </LineAttributes>
        <TickStyle>Across</TickStyle>
        <TickAttributes>
          <Style>Solid</Style>
          <Thickness>1</Thickness>
          <Color>
            <Transparency>255</Transparency>
            <Red>204</Red>
            <Green>204</Green>
            <Blue>204</Blue>
          </Color>
          <Visible>true</Visible>
        </TickAttributes>
      </MajorGrid>
      <MinorGrid>
        <LineAttributes>
          <Style>Solid</Style>
          <Thickness>1</Thickness>
          <Color>
            <Transparency>255</Transparency>
            <Red>225</Red>
            <Green>225</Green>
            <Blue>225</Blue>
          </Color>
          <Visible>false</Visible>
        </LineAttributes>
        <TickStyle>Across</TickStyle>
        <TickAttributes>
          <Style>Solid</Style>
          <Thickness>1</Thickness>
          <Color>
            <Transparency>255</Transparency>
            <Red>225</Red>
            <Green>225</Green>
            <Blue>225</Blue>
          </Color>
          <Visible>false</Visible>
        </TickAttributes>
      </MinorGrid>
      <Scale>
        <Min xsi:type="data:NumberDataElement">
          <Value>0.0</Value>
        </Min>
        <MinorGridsPerUnit>5</MinorGridsPerUnit>
        <ShowOutside>false</ShowOutside>
        <AutoExpand>true</AutoExpand>
      </Scale>
      <Origin>
        <Type>Min</Type>
        <Value xsi:type="data:NumberDataElement">
          <Value>0.0</Value>
        </Value>
      </Origin>
      <PrimaryAxis>true</PrimaryAxis>
      <Percent>false</Percent>
    </AssociatedAxes>
    <AncillaryAxes>
      <Type>Text</Type>
      <Title>
        <Caption>
          <Value>Z-Axis Title</Value>
          <Font>
            <Size>14.0</Size>
            <Bold>true</Bold>
            <Alignment>
              <horizontalAlignment>Center</horizontalAlignment>
              <verticalAlignment>Center</verticalAlignment>
            </Alignment>
          </Font>
        </Caption>
        <Background xsi:type="attribute:ColorDefinition">
          <Transparency>0</Transparency>
          <Red>255</Red>
          <Green>255</Green>
          <Blue>255</Blue>
        </Background>
        <Outline>
          <Style>Solid</Style>
          <Thickness>1</Thickness>
          <Color>
            <Transparency>255</Transparency>
            <Red>0</Red>
            <Green>0</Green>
            <Blue>0</Blue>
          </Color>
        </Outline>
        <Insets>
          <Top>0.0</Top>
          <Left>2.0</Left>
          <Bottom>0.0</Bottom>
          <Right>3.0</Right>
        </Insets>
        <Visible>false</Visible>
      </Title>
      <TitlePosition>Below</TitlePosition>
      <SeriesDefinitions>
        <Query>
          <Definition></Definition>
        </Query>
        <SeriesPalette>
          <Entries xsi:type="attribute:ColorDefinition">
            <Transparency>255</Transparency>
            <Red>80</Red>
            <Green>166</Green>
            <Blue>218</Blue>
          </Entries>
          <Entries xsi:type="attribute:ColorDefinition">
            <Transparency>255</Transparency>
            <Red>242</Red>
            <Green>88</Green>
            <Blue>106</Blue>
          </Entries>
          <Entries xsi:type="attribute:ColorDefinition">
            <Transparency>255</Transparency>
            <Red>232</Red>
            <Green>172</Green>
            <Blue>57</Blue>
          </Entries>
          <Entries xsi:type="attribute:ColorDefinition">
            <Transparency>255</Transparency>
            <Red>128</Red>
            <Green>255</Green>
            <Blue>128</Blue>
          </Entries>
          <Entries xsi:type="attribute:ColorDefinition">
            <Transparency>255</Transparency>
            <Red>64</Red>
            <Green>128</Green>
            <Blue>128</Blue>
          </Entries>
          <Entries xsi:type="attribute:ColorDefinition">
            <Transparency>255</Transparency>
            <Red>128</Red>
            <Green>128</Green>
            <Blue>192</Blue>
          </Entries>
          <Entries xsi:type="attribute:ColorDefinition">
            <Transparency>255</Transparency>
            <Red>170</Red>
            <Green>85</Green>
            <Blue>85</Blue>
          </Entries>
          <Entries xsi:type="attribute:ColorDefinition">
            <Transparency>255</Transparency>
            <Red>128</Red>
            <Green>128</Green>
            <Blue>0</Blue>
          </Entries>
          <Entries xsi:type="attribute:ColorDefinition">
            <Transparency>255</Transparency>
            <Red>192</Red>
            <Green>192</Green>
            <Blue>192</Blue>
          </Entries>
          <Entries xsi:type="attribute:ColorDefinition">
            <Transparency>255</Transparency>
            <Red>255</Red>
            <Green>255</Green>
            <Blue>128</Blue>
          </Entries>
          <Entries xsi:type="attribute:ColorDefinition">
            <Transparency>255</Transparency>
            <Red>128</Red>
            <Green>192</Green>
            <Blue>128</Blue>
          </Entries>
          <Entries xsi:type="attribute:ColorDefinition">
            <Transparency>255</Transparency>
            <Red>7</Red>
            <Green>146</Green>
            <Blue>94</Blue>
          </Entries>
          <Entries xsi:type="attribute:ColorDefinition">
            <Transparency>255</Transparency>
            <Red>0</Red>
            <Green>128</Green>
            <Blue>255</Blue>
          </Entries>
          <Entries xsi:type="attribute:ColorDefinition">
            <Transparency>255</Transparency>
            <Red>255</Red>
            <Green>128</Green>
            <Blue>192</Blue>
          </Entries>
          <Entries xsi:type="attribute:ColorDefinition">
            <Transparency>255</Transparency>
            <Red>0</Red>
            <Green>255</Green>
            <Blue>255</Blue>
          </Entries>
          <Entries xsi:type="attribute:ColorDefinition">
            <Transparency>255</Transparency>
            <Red>255</Red>
            <Green>128</Green>
            <Blue>128</Blue>
          </Entries>
          <Entries xsi:type="attribute:ColorDefinition">
            <Transparency>255</Transparency>
            <Red>0</Red>
            <Green>128</Green>
            <Blue>192</Blue>
          </Entries>
          <Entries xsi:type="attribute:ColorDefinition">
            <Transparency>255</Transparency>
            <Red>128</Red>
            <Green>128</Green>
            <Blue>192</Blue>
          </Entries>
          <Entries xsi:type="attribute:ColorDefinition">
            <Transparency>255</Transparency>
            <Red>255</Red>
            <Green>0</Green>
            <Blue>255</Blue>
          </Entries>
          <Entries xsi:type="attribute:ColorDefinition">
            <Transparency>255</Transparency>
            <Red>128</Red>
            <Green>64</Green>
            <Blue>64</Blue>
          </Entries>
          <Entries xsi:type="attribute:ColorDefinition">
            <Transparency>255</Transparency>
            <Red>255</Red>
            <Green>128</Green>
            <Blue>64</Blue>
          </Entries>
          <Entries xsi:type="attribute:ColorDefinition">
            <Transparency>255</Transparency>
            <Red>80</Red>
            <Green>240</Green>
            <Blue>120</Blue>
          </Entries>
          <Entries xsi:type="attribute:ColorDefinition">
            <Transparency>255</Transparency>
            <Red>0</Red>
            <Green>64</Green>
            <Blue>128</Blue>
          </Entries>
          <Entries xsi:type="attribute:ColorDefinition">
            <Transparency>255</Transparency>
            <Red>128</Red>
            <Green>0</Green>
            <Blue>64</Blue>
          </Entries>
          <Entries xsi:type="attribute:ColorDefinition">
            <Transparency>255</Transparency>
            <Red>255</Red>
            <Green>0</Green>
            <Blue>128</Blue>
          </Entries>
          <Entries xsi:type="attribute:ColorDefinition">
            <Transparency>255</Transparency>
            <Red>128</Red>
            <Green>128</Green>
            <Blue>64</Blue>
          </Entries>
          <Entries xsi:type="attribute:ColorDefinition">
            <Transparency>255</Transparency>
            <Red>128</Red>
            <Green>128</Green>
            <Blue>128</Blue>
          </Entries>
          <Entries xsi:type="attribute:ColorDefinition">
            <Transparency>255</Transparency>
            <Red>255</Red>
            <Green>128</Green>
            <Blue>255</Blue>
          </Entries>
          <Entries xsi:type="attribute:ColorDefinition">
            <Transparency>255</Transparency>
            <Red>0</Red>
            <Green>64</Green>
            <Blue>0</Blue>
          </Entries>
          <Entries xsi:type="attribute:ColorDefinition">
            <Transparency>255</Transparency>
            <Red>0</Red>
            <Green>0</Green>
            <Blue>0</Blue>
          </Entries>
          <Entries xsi:type="attribute:ColorDefinition">
            <Transparency>255</Transparency>
            <Red>255</Red>
            <Green>255</Green>
            <Blue>255</Blue>
          </Entries>
          <Entries xsi:type="attribute:ColorDefinition">
            <Transparency>255</Transparency>
            <Red>255</Red>
            <Green>128</Green>
            <Blue>0</Blue>
          </Entries>
        </SeriesPalette>
        <Series>
          <Visible>true</Visible>
          <Label>
            <Caption>
              <Value></Value>
              <Font>
                <Alignment/>
              </Font>
            </Caption>
            <Background xsi:type="attribute:ColorDefinition">
              <Transparency>0</Transparency>
              <Red>255</Red>
              <Green>255</Green>
              <Blue>255</Blue>
            </Background>
            <Outline>
              <Style>Solid</Style>
              <Thickness>1</Thickness>
              <Color>
                <Transparency>255</Transparency>
                <Red>0</Red>
                <Green>0</Green>
                <Blue>0</Blue>
              </Color>
              <Visible>false</Visible>
            </Outline>
            <Insets>
              <Top>0.0</Top>
              <Left>2.0</Left>
              <Bottom>0.0</Bottom>
              <Right>3.0</Right>
            </Insets>
            <Visible>false</Visible>
          </Label>
          <SeriesIdentifier></SeriesIdentifier>
          <DataPoint>
            <Components>
              <Type>Orthogonal_Value</Type>
            </Components>
            <Separator>, </Separator>
          </DataPoint>
          <LabelPosition>Outside</LabelPosition>
          <Stacked>false</Stacked>
        </Series>
        <Grouping>
          <GroupType>Text</GroupType>
          <AggregateExpression>Sum</AggregateExpression>
        </Grouping>
      </SeriesDefinitions>
      <Orientation>Horizontal</Orientation>
      <LineAttributes>
        <Style>Solid</Style>
        <Thickness>1</Thickness>
        <Visible>true</Visible>
      </LineAttributes>
      <Label>
        <Caption>
          <Value></Value>
          <Font>
            <Alignment/>
          </Font>
        </Caption>
        <Background xsi:type="attribute:ColorDefinition">
          <Transparency>0</Transparency>
          <Red>255</Red>
          <Green>255</Green>
          <Blue>255</Blue>
        </Background>
        <Outline>
          <Style>Solid</Style>
          <Thickness>1</Thickness>
          <Color>
            <Transparency>255</Transparency>
            <Red>0</Red>
            <Green>0</Green>
            <Blue>0</Blue>
          </Color>
        </Outline>
        <Insets>
          <Top>0.0</Top>
          <Left>2.0</Left>
          <Bottom>0.0</Bottom>
          <Right>3.0</Right>
        </Insets>
        <Visible>true</Visible>
      </Label>
      <LabelPosition>Below</LabelPosition>
      <MajorGrid>
        <LineAttributes>
          <Style>Solid</Style>
          <Thickness>1</Thickness>
          <Color>
            <Transparency>255</Transparency>
            <Red>196</Red>
            <Green>196</Green>
            <Blue>196</Blue>
          </Color>
          <Visible>false</Visible>
        </LineAttributes>
        <TickStyle>Across</TickStyle>
        <TickAttributes>
          <Style>Solid</Style>
          <Thickness>1</Thickness>
          <Color>
            <Transparency>255</Transparency>
            <Red>196</Red>
            <Green>196</Green>
            <Blue>196</Blue>
          </Color>
          <Visible>true</Visible>
        </TickAttributes>
      </MajorGrid>
      <MinorGrid>
        <LineAttributes>
          <Style>Solid</Style>
          <Thickness>1</Thickness>
          <Color>
            <Transparency>255</Transparency>
            <Red>225</Red>
            <Green>225</Green>
            <Blue>225</Blue>
          </Color>
          <Visible>false</Visible>
        </LineAttributes>
        <TickStyle>Across</TickStyle>
        <TickAttributes>
          <Style>Solid</Style>
          <Thickness>1</Thickness>
          <Color>
            <Transparency>255</Transparency>
            <Red>225</Red>
            <Green>225</Green>
            <Blue>225</Blue>
          </Color>
          <Visible>false</Visible>
        </TickAttributes>
      </MinorGrid>
      <Scale>
        <MinorGridsPerUnit>5</MinorGridsPerUnit>
      </Scale>
      <Origin>
        <Type>Min</Type>
        <Value xsi:type="data:NumberDataElement">
          <Value>0.0</Value>
        </Value>
      </Origin>
      <PrimaryAxis>true</PrimaryAxis>
      <Percent>false</Percent>
    </AncillaryAxes>
    <SeriesDefinitions>
      <Query>
        <Definition></Definition>
      </Query>
      <SeriesPalette>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>46</Red>
          <Green>52</Green>
          <Blue>54</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>242</Red>
          <Green>88</Green>
          <Blue>106</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>232</Red>
          <Green>172</Green>
          <Blue>57</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>128</Red>
          <Green>255</Green>
          <Blue>128</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>64</Red>
          <Green>128</Green>
          <Blue>128</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>128</Red>
          <Green>128</Green>
          <Blue>192</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>170</Red>
          <Green>85</Green>
          <Blue>85</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>128</Red>
          <Green>128</Green>
          <Blue>0</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>192</Red>
          <Green>192</Green>
          <Blue>192</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>255</Red>
          <Green>255</Green>
          <Blue>128</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>128</Red>
          <Green>192</Green>
          <Blue>128</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>7</Red>
          <Green>146</Green>
          <Blue>94</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>0</Red>
          <Green>128</Green>
          <Blue>255</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>255</Red>
          <Green>128</Green>
          <Blue>192</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>0</Red>
          <Green>255</Green>
          <Blue>255</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>255</Red>
          <Green>128</Green>
          <Blue>128</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>0</Red>
          <Green>128</Green>
          <Blue>192</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>128</Red>
          <Green>128</Green>
          <Blue>192</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>255</Red>
          <Green>0</Green>
          <Blue>255</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>128</Red>
          <Green>64</Green>
          <Blue>64</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>255</Red>
          <Green>128</Green>
          <Blue>64</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>80</Red>
          <Green>240</Green>
          <Blue>120</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>0</Red>
          <Green>64</Green>
          <Blue>128</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>128</Red>
          <Green>0</Green>
          <Blue>64</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>255</Red>
          <Green>0</Green>
          <Blue>128</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>128</Red>
          <Green>128</Green>
          <Blue>64</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>128</Red>
          <Green>128</Green>
          <Blue>128</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>255</Red>
          <Green>128</Green>
          <Blue>255</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>0</Red>
          <Green>64</Green>
          <Blue>0</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>0</Red>
          <Green>0</Green>
          <Blue>0</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>255</Red>
          <Green>255</Green>
          <Blue>255</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>255</Red>
          <Green>128</Green>
          <Blue>0</Blue>
        </Entries>
      </SeriesPalette>
      <Series>
        <Visible>true</Visible>
        <Label>
          <Caption>
            <Value></Value>
            <Font>
              <Alignment/>
            </Font>
          </Caption>
          <Background xsi:type="attribute:ColorDefinition">
            <Transparency>0</Transparency>
            <Red>255</Red>
            <Green>255</Green>
            <Blue>255</Blue>
          </Background>
          <Outline>
            <Style>Solid</Style>
            <Thickness>1</Thickness>
            <Color>
              <Transparency>255</Transparency>
              <Red>0</Red>
              <Green>0</Green>
              <Blue>0</Blue>
            </Color>
            <Visible>false</Visible>
          </Outline>
          <Insets>
            <Top>0.0</Top>
            <Left>2.0</Left>
            <Bottom>0.0</Bottom>
            <Right>3.0</Right>
          </Insets>
          <Visible>false</Visible>
        </Label>
        <DataDefinition>
          <Definition>row[&quot;categoryKey&quot;]</Definition>
        </DataDefinition>
        <SeriesIdentifier></SeriesIdentifier>
        <DataPoint>
          <Components>
            <Type>Orthogonal_Value</Type>
          </Components>
          <Separator>, </Separator>
        </DataPoint>
        <LabelPosition>Outside</LabelPosition>
        <Stacked>false</Stacked>
      </Series>
      <Grouping>
        <Enabled>true</Enabled>
        <GroupingInterval>1.0</GroupingInterval>
        <GroupType>Text</GroupType>
        <AggregateExpression>Last</AggregateExpression>
      </Grouping>
      <Sorting>Descending</Sorting>
      <SortKey>
        <Definition>getKeyFiguresRowPosition(row[&quot;categoryKey&quot;], row[&quot;category_index&quot;])</Definition>
      </SortKey>
    </SeriesDefinitions>
    <Orientation>Horizontal</Orientation>
    <LineAttributes>
      <Style>Solid</Style>
      <Thickness>1</Thickness>
      <Color>
        <Transparency>0</Transparency>
        <Red>255</Red>
        <Green>255</Green>
        <Blue>255</Blue>
      </Color>
      <Visible>false</Visible>
    </LineAttributes>
    <Label>
      <Caption>
        <Value></Value>
        <Font>
          <Name>Arial</Name>
          <Size>10.0</Size>
          <Bold>false</Bold>
          <Alignment/>
        </Font>
        <Color>
          <Transparency>255</Transparency>
          <Red>0</Red>
          <Green>0</Green>
          <Blue>0</Blue>
        </Color>
      </Caption>
      <Background xsi:type="attribute:ColorDefinition">
        <Transparency>0</Transparency>
        <Red>255</Red>
        <Green>255</Green>
        <Blue>255</Blue>
      </Background>
      <Outline>
        <Style>Solid</Style>
        <Thickness>1</Thickness>
        <Color>
          <Transparency>255</Transparency>
          <Red>0</Red>
          <Green>0</Green>
          <Blue>0</Blue>
        </Color>
        <Visible>false</Visible>
      </Outline>
      <Insets>
        <Top>0.0</Top>
        <Left>0.0</Left>
        <Bottom>0.0</Bottom>
        <Right>0.0</Right>
      </Insets>
      <Visible>true</Visible>
      <Ellipsis>40</Ellipsis>
    </Label>
    <LabelPosition>Below</LabelPosition>
    <MajorGrid>
      <LineAttributes>
        <Style>Solid</Style>
        <Thickness>1</Thickness>
        <Color>
          <Transparency>255</Transparency>
          <Red>196</Red>
          <Green>196</Green>
          <Blue>196</Blue>
        </Color>
        <Visible>false</Visible>
      </LineAttributes>
      <TickStyle>Across</TickStyle>
      <TickAttributes>
        <Style>Solid</Style>
        <Thickness>1</Thickness>
        <Color>
          <Transparency>255</Transparency>
          <Red>196</Red>
          <Green>196</Green>
          <Blue>196</Blue>
        </Color>
        <Visible>false</Visible>
      </TickAttributes>
    </MajorGrid>
    <MinorGrid>
      <LineAttributes>
        <Style>Solid</Style>
        <Thickness>1</Thickness>
        <Color>
          <Transparency>255</Transparency>
          <Red>225</Red>
          <Green>225</Green>
          <Blue>225</Blue>
        </Color>
        <Visible>false</Visible>
      </LineAttributes>
      <TickStyle>Across</TickStyle>
      <TickAttributes>
        <Style>Solid</Style>
        <Thickness>1</Thickness>
        <Color>
          <Transparency>255</Transparency>
          <Red>225</Red>
          <Green>225</Green>
          <Blue>225</Blue>
        </Color>
        <Visible>false</Visible>
      </TickAttributes>
    </MinorGrid>
    <Scale>
      <MinorGridsPerUnit>5</MinorGridsPerUnit>
      <ShowOutside>false</ShowOutside>
      <TickBetweenCategories>true</TickBetweenCategories>
      <MajorGridsStepNumber>1</MajorGridsStepNumber>
    </Scale>
    <Origin>
      <Type>Min</Type>
      <Value xsi:type="data:NumberDataElement">
        <Value>0.0</Value>
      </Value>
    </Origin>
    <PrimaryAxis>true</PrimaryAxis>
    <CategoryAxis>true</CategoryAxis>
    <Percent>false</Percent>
    <Cursor>
      <Type>Auto</Type>
    </Cursor>
  </Axes>
  <WallFill xsi:type="attribute:ColorDefinition">
    <Transparency>255</Transparency>
    <Red>192</Red>
    <Green>192</Green>
    <Blue>192</Blue>
  </WallFill>
  <FloorFill xsi:type="attribute:ColorDefinition">
    <Transparency>255</Transparency>
    <Red>192</Red>
    <Green>192</Green>
    <Blue>192</Blue>
  </FloorFill>
  <Orientation>Horizontal</Orientation>
  <UnitSpacing>22.0</UnitSpacing>
  <Rotation>
    <Angles>
      <XAngle>-20.0</XAngle>
      <YAngle>45.0</YAngle>
      <ZAngle>0.0</ZAngle>
      <Type>None</Type>
    </Angles>
  </Rotation>
  <ReverseCategory>false</ReverseCategory>
</model:ChartWithAxes>
]]></xml-property>
                                    <property name="outputFormat">SVG</property>
                                    <list-property name="filter">
                                        <structure>
                                            <property name="operator">is-true</property>
                                            <expression name="expr" type="javascript">row["category_index"] &lt;= CommonKeys.REVENUE_INDEX ||
row["category_index"] == CommonKeys.OPENINGS_ANONYMOUS_INDEX ||
row["category_index"] == CommonKeys.CLICKS_ANONYMOUS_INDEX</expression>
                                            <property name="updateAggregation">true</property>
                                        </structure>
                                    </list-property>
                                    <property name="inheritColumns">true</property>
                                    <property name="marginTop">0px</property>
                                    <property name="marginBottom">0px</property>
                                    <property name="height">760px</property>
                                    <property name="width">747px</property>
                                    <list-property name="visibility">
                                        <structure>
                                            <property name="format">all</property>
                                            <expression name="valueExpr" type="javascript">reportContext.getPersistentGlobalVariable("showNet") == false</expression>
                                        </structure>
                                    </list-property>
                                </extended-item>
                                <extended-item extensionName="Chart" name="summaryDataDelivered" id="431">
                                    <xml-property name="xmlRepresentation"><![CDATA[<model:ChartWithAxes xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:attribute="http://www.birt.eclipse.org/ChartModelAttribute" xmlns:data="http://www.birt.eclipse.org/ChartModelData" xmlns:layout="http://www.birt.eclipse.org/ChartModelLayout" xmlns:model="http://www.birt.eclipse.org/ChartModel" xmlns:type="http://www.birt.eclipse.org/ChartModelType">
  <Version>2.6.1</Version>
  <Type>Bar Chart</Type>
  <SubType>Side-by-side</SubType>
  <Description>
    <Value></Value>
    <Font>
      <Alignment/>
    </Font>
  </Description>
  <Block>
    <Children xsi:type="layout:TitleBlock">
      <Bounds>
        <Left>0.0</Left>
        <Top>0.0</Top>
        <Width>0.0</Width>
        <Height>0.0</Height>
      </Bounds>
      <Insets>
        <Top>3.0</Top>
        <Left>3.0</Left>
        <Bottom>3.0</Bottom>
        <Right>3.0</Right>
      </Insets>
      <Row>-1</Row>
      <Column>-1</Column>
      <Rowspan>-1</Rowspan>
      <Columnspan>-1</Columnspan>
      <Outline>
        <Style>Solid</Style>
        <Thickness>1</Thickness>
        <Color>
          <Transparency>255</Transparency>
          <Red>0</Red>
          <Green>0</Green>
          <Blue>0</Blue>
        </Color>
        <Visible>false</Visible>
      </Outline>
      <Visible>false</Visible>
      <Label>
        <Caption>
          <Value>Bar Chart Title</Value>
          <Font>
            <Size>16.0</Size>
            <Bold>true</Bold>
            <Alignment>
              <horizontalAlignment>Center</horizontalAlignment>
              <verticalAlignment>Center</verticalAlignment>
            </Alignment>
          </Font>
        </Caption>
        <Background xsi:type="attribute:ColorDefinition">
          <Transparency>0</Transparency>
          <Red>255</Red>
          <Green>255</Green>
          <Blue>255</Blue>
        </Background>
        <Outline>
          <Style>Solid</Style>
          <Thickness>1</Thickness>
          <Color>
            <Transparency>255</Transparency>
            <Red>0</Red>
            <Green>0</Green>
            <Blue>0</Blue>
          </Color>
        </Outline>
        <Insets>
          <Top>0.0</Top>
          <Left>2.0</Left>
          <Bottom>0.0</Bottom>
          <Right>3.0</Right>
        </Insets>
        <Visible>true</Visible>
      </Label>
    </Children>
    <Children xsi:type="layout:Plot">
      <Bounds>
        <Left>0.0</Left>
        <Top>0.0</Top>
        <Width>0.0</Width>
        <Height>0.0</Height>
      </Bounds>
      <Anchor>North</Anchor>
      <Stretch>Horizontal</Stretch>
      <Insets>
        <Top>0.0</Top>
        <Left>0.0</Left>
        <Bottom>0.0</Bottom>
        <Right>30.0</Right>
      </Insets>
      <Row>-1</Row>
      <Column>-1</Column>
      <Rowspan>-1</Rowspan>
      <Columnspan>-1</Columnspan>
      <Outline>
        <Style>Solid</Style>
        <Thickness>1</Thickness>
        <Color>
          <Transparency>255</Transparency>
          <Red>0</Red>
          <Green>0</Green>
          <Blue>0</Blue>
        </Color>
        <Visible>false</Visible>
      </Outline>
      <Visible>true</Visible>
      <HorizontalSpacing>5</HorizontalSpacing>
      <VerticalSpacing>20</VerticalSpacing>
      <ClientArea>
        <Outline>
          <Style>Solid</Style>
          <Thickness>0</Thickness>
          <Color>
            <Transparency>255</Transparency>
            <Red>0</Red>
            <Green>0</Green>
            <Blue>0</Blue>
          </Color>
          <Visible>false</Visible>
        </Outline>
        <Insets>
          <Top>0.0</Top>
          <Left>0.0</Left>
          <Bottom>0.0</Bottom>
          <Right>30.0</Right>
        </Insets>
      </ClientArea>
    </Children>
    <Children xsi:type="layout:Legend">
      <Bounds>
        <Left>0.0</Left>
        <Top>0.0</Top>
        <Width>0.0</Width>
        <Height>0.0</Height>
      </Bounds>
      <Anchor>West</Anchor>
      <Stretch>Horizontal</Stretch>
      <Insets>
        <Top>3.0</Top>
        <Left>3.0</Left>
        <Bottom>5.0</Bottom>
        <Right>3.0</Right>
      </Insets>
      <Row>-1</Row>
      <Column>-1</Column>
      <Rowspan>-1</Rowspan>
      <Columnspan>-1</Columnspan>
      <Outline>
        <Style>Solid</Style>
        <Thickness>1</Thickness>
        <Color>
          <Transparency>255</Transparency>
          <Red>0</Red>
          <Green>0</Green>
          <Blue>0</Blue>
        </Color>
        <Visible>false</Visible>
      </Outline>
      <Background xsi:type="attribute:ColorDefinition">
        <Transparency>0</Transparency>
        <Red>255</Red>
        <Green>255</Green>
        <Blue>255</Blue>
      </Background>
      <Visible>true</Visible>
      <Triggers>
        <Condition>onclick</Condition>
        <Action>
          <Type>Toggle_Visibility</Type>
          <Value xsi:type="attribute:SeriesValue">
            <Name></Name>
          </Value>
        </Action>
      </Triggers>
      <Cursor>
        <Type>Pointer</Type>
      </Cursor>
      <ClientArea>
        <Outline>
          <Style>Solid</Style>
          <Thickness>0</Thickness>
          <Color>
            <Transparency>255</Transparency>
            <Red>0</Red>
            <Green>0</Green>
            <Blue>0</Blue>
          </Color>
          <Visible>false</Visible>
        </Outline>
        <Insets>
          <Top>2.0</Top>
          <Left>2.0</Left>
          <Bottom>2.0</Bottom>
          <Right>100.0</Right>
        </Insets>
      </ClientArea>
      <Text>
        <Value></Value>
        <Font>
          <Name>Arial</Name>
          <Size>10.0</Size>
          <Alignment/>
        </Font>
      </Text>
      <Orientation>Horizontal</Orientation>
      <Direction>Left_Right</Direction>
      <Separator>
        <Style>Solid</Style>
        <Thickness>1</Thickness>
        <Color>
          <Transparency>255</Transparency>
          <Red>255</Red>
          <Green>0</Green>
          <Blue>0</Blue>
        </Color>
        <Visible>false</Visible>
      </Separator>
      <Position>Above</Position>
      <ItemType>Series</ItemType>
      <Title>
        <Caption>
          <Value></Value>
          <Font>
            <Alignment/>
          </Font>
        </Caption>
        <Background xsi:type="attribute:ColorDefinition">
          <Transparency>0</Transparency>
          <Red>255</Red>
          <Green>255</Green>
          <Blue>255</Blue>
        </Background>
        <Outline>
          <Style>Solid</Style>
          <Thickness>1</Thickness>
          <Color>
            <Transparency>255</Transparency>
            <Red>0</Red>
            <Green>0</Green>
            <Blue>0</Blue>
          </Color>
          <Visible>false</Visible>
        </Outline>
        <Insets>
          <Top>0.0</Top>
          <Left>2.0</Left>
          <Bottom>0.0</Bottom>
          <Right>3.0</Right>
        </Insets>
        <Visible>false</Visible>
      </Title>
      <TitlePosition>Above</TitlePosition>
      <ShowValue>false</ShowValue>
      <WrappingSize>0.0</WrappingSize>
      <MaxPercent>0.33</MaxPercent>
      <TitlePercent>0.6</TitlePercent>
      <Ellipsis>40</Ellipsis>
    </Children>
    <Bounds>
      <Left>0.0</Left>
      <Top>0.0</Top>
      <Width>501.0</Width>
      <Height>270.0</Height>
    </Bounds>
    <Insets>
      <Top>0.0</Top>
      <Left>0.0</Left>
      <Bottom>0.0</Bottom>
      <Right>0.0</Right>
    </Insets>
    <Row>-1</Row>
    <Column>-1</Column>
    <Rowspan>-1</Rowspan>
    <Columnspan>-1</Columnspan>
    <Outline>
      <Style>Solid</Style>
      <Thickness>1</Thickness>
      <Color>
        <Transparency>255</Transparency>
        <Red>0</Red>
        <Green>0</Green>
        <Blue>0</Blue>
      </Color>
      <Visible>false</Visible>
    </Outline>
    <Background xsi:type="attribute:ColorDefinition">
      <Transparency>0</Transparency>
      <Red>255</Red>
      <Green>255</Green>
      <Blue>255</Blue>
    </Background>
    <Visible>true</Visible>
  </Block>
  <Dimension>Two_Dimensional</Dimension>
  <Script>importPackage(Packages.org.eclipse.birt.chart.model.attribute.impl);
importPackage(Packages.org.eclipse.birt.chart.model.attribute);
importPackage(Packages.org.eclipse.birt.report.model.api.util);
importPackage(Packages.org.eclipse.birt.chart.model.data.impl);
importPackage(Packages.org.eclipse.birt.chart.computation);
importPackage(Packages.com.agnitas.messages);
importPackage(Packages.com.agnitas.reporting.birt.external.dataset);
importPackage(Packages.java.util);
importPackage(Packages.java.text);
importPackage(Packages.org.apache.commons.lang3);

var	ignoredBarIndexes = {}

/**
 * Called before generation of chart model to GeneratedChartState.
 *
 * @param chart Chart
 * @param icsc IChartScriptContext
 */
function beforeGeneration(chart, icsc){
	var reportContext = icsc.getExternalContext().getObject();
	var externalScriptableContext = icsc.getExternalContext().getScriptable();

	// global functions
	var hasPercentageRepresentation = externalScriptableContext.getGlobalVariable(&quot;hasPercentageRepresentationFunction&quot;);

	// axis
	var xAxis = chart.getAxes().get(0);
	var xSeriesDefinition = xAxis.getSeriesDefinitions().get(0);
	var xValues = xSeriesDefinition.getRunTimeSeries().get(0).getDataSet().getValues();

	for (i = 0; i &lt; xValues.length; i++) {
 		 var categoryKey = xValues[i];
 		 // find out indexes of ignored burs.
 		 // uses in beforeDrawDataPointLabel method
 		 if (!hasPercentageRepresentation(categoryKey)) {
 		 	ignoredBarIndexes[i] = 0;
 		 }
	}
	chart.setSeriesThickness(60);

	max = reportContext.getPersistentGlobalVariable(&quot;maxValue&quot;);
	if (max > 0) {
		yAxis = chart.getOrthogonalAxes(chart.getBaseAxes()[0], true)[0];
		yscale = yAxis.getScale();
		yscale.setMax(NumberDataElementImpl.create(max * 1.25));
		yscale.setMin(NumberDataElementImpl.create(0));
		yAxis.setScale(yscale);
	}
};

/**
 * Called before rendering the label for each datapoint.
 *
 * @param dph DataPointHints
 * @param label Label
 * @param icsc IChartScriptContext
 */
function beforeDrawDataPointLabel(dph, label, icsc) {
	var reportContext = icsc.getExternalContext().getObject();
	var externalScriptableContext = icsc.getExternalContext().getScriptable();
	var calculatePercent = icsc.getExternalContext().getScriptable().getGlobalVariable(&quot;calculatePercentFunction&quot;);
	var formatPercent = icsc.getExternalContext().getScriptable().getGlobalVariable(&quot;formatPercentFunction&quot;);	
	var getGroupIdByName = icsc.getExternalContext().getScriptable().getGlobalVariable(&quot;getGroupIdByNameFunction&quot;);
	
	var values = new String(label.getCaption().getValue()).split(&quot;;&quot;);
	var groupId = getGroupIdByName(values[1]);
	var currentValue = values[0]; // series value
	
	if (groupId != CommonKeys.OPTIMIZATION_SUMMARY_GROUP_ID) {
		//do not show series label for other groups ids
		label.getCaption().setValue('');
	} else if (!(dph.getIndex() in ignoredBarIndexes)) {
		// code to display the percent value
		//calculate proper percent based on sent e-mails
		var totalSent = parseInt(reportContext.getGlobalVariable(&quot;total_sent&quot;));
		curValue = Packages.java.text.NumberFormat.getNumberInstance(getLocale()).parse(currentValue);			
		formattedPercent = formatPercent(calculatePercent(curValue, new Number(totalSent)));
		label.getCaption().setValue(formattedPercent + '%; ' + currentValue);
	} else {
		label.getCaption().setValue(currentValue);
	}
		
	if(reportContext.getGlobalVariable(&quot;isDarkmode&quot;) == true){
		label.getCaption().getColor().set(255, 255, 255);
	}
};

/**
 * Called before drawing each datapoint graphical representation or marker.
 *
 * @param dph
 *            DataPointHints
 * @param fill
 *            Fill
 * @param icsc
 *            IChartScriptContext
 */

function beforeDrawDataPoint( dph, fill, icsc )
{
	var getPaletteColor = icsc.getExternalContext().getScriptable().getGlobalVariable(&quot;getPaletteColorByGroupIdFunction&quot;);
	var getGroupIdByName = icsc.getExternalContext().getScriptable().getGlobalVariable(&quot;getGroupIdByNameFunction&quot;);

	var context = icsc.getExternalContext().getObject();
	var groupId = getGroupIdByName(dph.getSeriesDisplayValue());
	var color = getPaletteColor(groupId);
	fill.set(color.getRed(), color.getGreen(), color.getBlue());
}

/**
 * Called before rendering each label on a given Axis.
 * 
 * @param axis
 *            Axis
 * @param label
 *            Label
 * @param icsc
 *            IChartScriptContext
 */

function beforeDrawAxisLabel( axis, label, icsc )
{
	var reportContext = icsc.getExternalContext().getObject();
	var getTranslationByCategory = icsc.getExternalContext().getScriptable().getGlobalVariable(&quot;getTranslationByCategoryFunction&quot;);

	importPackage(Packages.org.eclipse.birt.chart.model.attribute);
	if (axis.getType() == AxisType.TEXT_LITERAL){
		 // replace translation key to translation
 	 	caption = label.getCaption();
 	 			 
		var translated = StringUtils.abbreviate(getTranslationByCategory(caption.getValue()), 30);
	 	caption.setValue(translated);
	 	axis.setLabel(label);
	}

	if(reportContext.getGlobalVariable(&quot;isDarkmode&quot;) == true){
		label.getCaption().getColor().set(255, 255, 255);
	}
}

/**
 * Called before drawing the legend item.
 * 
 * @param lerh
 * 			  LegendEntryRenderingHints
 * @param bounds
 * 			  Bounds
 * @param icsc
 * 			  IChartScriptContext
 * @since Version 2.2.0
 */

function beforeDrawLegendItem( lerh, bounds, icsc )
{
	var reportContext = icsc.getExternalContext().getObject();
	var getPaletteColor = icsc.getExternalContext().getScriptable().getGlobalVariable(&quot;getPaletteColorByGroupIdFunction&quot;);
	var getGroupIdByName = icsc.getExternalContext().getScriptable().getGlobalVariable(&quot;getGroupIdByNameFunction&quot;);

	var curr = lerh.getLabel().getCaption();
	var name = curr.getValue();
		
	var groupId = getGroupIdByName(name);
	lerh.getLabel().getCaption().setValue(StringUtils.abbreviate(name, 35));
	
		
	var color = getPaletteColor(groupId);
	lerh.getFill().set(color.getRed(), color.getGreen(), color.getBlue());
	
	if(reportContext.getGlobalVariable(&quot;isDarkmode&quot;) == true){
		curr.getColor().set(255, 255, 255);
	}
}

/**
 * Called before the chart is rendered.
 * 
 * @param gcs
 *            GeneratedChartState
 * @param icsc
 *            IChartScriptContext
 */

function beforeRendering( gcs, icsc )
{
	rtc = gcs.getRunTimeContext();
	llh = rtc.getLegendLayoutHints();
	liha = llh.getLegendItemHints();
	
	pointToPixel = gcs.getComputations().getPointToPixel();
	plotWidth = gcs.getComputations().getPlotBounds().getWidth() * pointToPixel;
	
	var rowsNum = parseInt(liha.length / 2) + liha.length % 2;
	width = (plotWidth / 2.0) - 17.42;
	height = liha[0].getItemHeight() + 5.33;
	
	for (var i = 0; i &lt; liha.length; i++) {
		lih = liha[i];
		var row = parseInt(i / 2);
		var col = i % 2;		
		
		lih.width(width);
		lih.top(row * height);
		lih.left(col * width);
	}
	
	legendLength = height * rowsNum;
	llhNew = new LegendLayoutHints(SizeImpl.create(plotWidth, legendLength), llh.getTitleSize(), null, llh.isMinSliceApplied(), llh.getMinSliceText(), liha);
	
	rtc.setLegendLayoutHints(llhNew);
}</Script>
  <Units>Points</Units>
  <SeriesThickness>10.0</SeriesThickness>
  <GridColumnCount>0</GridColumnCount>
  <ExtendedProperties>
    <Name>enable.area.alt</Name>
    <Value>false</Value>
  </ExtendedProperties>
  <SampleData>
    <BaseSampleData>
      <DataSetRepresentation>'A','B','C','D','E'</DataSetRepresentation>
    </BaseSampleData>
    <OrthogonalSampleData>
      <DataSetRepresentation>6,4,12,8,10</DataSetRepresentation>
      <SeriesDefinitionIndex>0</SeriesDefinitionIndex>
    </OrthogonalSampleData>
    <AncillarySampleData>
      <DataSetRepresentation>Series 1</DataSetRepresentation>
    </AncillarySampleData>
  </SampleData>
  <Interactivity>
    <Enable>true</Enable>
    <LegendBehavior>None</LegendBehavior>
  </Interactivity>
  <EmptyMessage>
    <Caption>
      <Value>No data available.</Value>
      <Font>
        <Alignment>
          <horizontalAlignment>Center</horizontalAlignment>
          <verticalAlignment>Center</verticalAlignment>
        </Alignment>
      </Font>
    </Caption>
    <Background xsi:type="attribute:ColorDefinition">
      <Transparency>64</Transparency>
      <Red>127</Red>
      <Green>127</Green>
      <Blue>127</Blue>
    </Background>
    <Outline>
      <Color>
        <Transparency>128</Transparency>
        <Red>127</Red>
        <Green>127</Green>
        <Blue>127</Blue>
      </Color>
      <Visible>true</Visible>
    </Outline>
    <Insets>
      <Top>10.0</Top>
      <Left>10.0</Left>
      <Bottom>10.0</Bottom>
      <Right>10.0</Right>
    </Insets>
    <Visible>true</Visible>
  </EmptyMessage>
  <Axes>
    <Type>Text</Type>
    <Title>
      <Caption>
        <Value>X-Axis Title</Value>
        <Font>
          <Size>14.0</Size>
          <Bold>true</Bold>
          <Alignment>
            <horizontalAlignment>Center</horizontalAlignment>
            <verticalAlignment>Center</verticalAlignment>
          </Alignment>
          <Rotation>0.0</Rotation>
        </Font>
      </Caption>
      <Background xsi:type="attribute:ColorDefinition">
        <Transparency>0</Transparency>
        <Red>255</Red>
        <Green>255</Green>
        <Blue>255</Blue>
      </Background>
      <Outline>
        <Style>Solid</Style>
        <Thickness>1</Thickness>
        <Color>
          <Transparency>255</Transparency>
          <Red>0</Red>
          <Green>0</Green>
          <Blue>0</Blue>
        </Color>
      </Outline>
      <Insets>
        <Top>0.0</Top>
        <Left>2.0</Left>
        <Bottom>0.0</Bottom>
        <Right>3.0</Right>
      </Insets>
      <Visible>false</Visible>
    </Title>
    <TitlePosition>Below</TitlePosition>
    <AssociatedAxes>
      <Type>Linear</Type>
      <Title>
        <Caption>
          <Value>Y-Axis Title</Value>
          <Font>
            <Size>14.0</Size>
            <Bold>true</Bold>
            <Alignment>
              <horizontalAlignment>Center</horizontalAlignment>
              <verticalAlignment>Center</verticalAlignment>
            </Alignment>
            <Rotation>90.0</Rotation>
          </Font>
        </Caption>
        <Background xsi:type="attribute:ColorDefinition">
          <Transparency>0</Transparency>
          <Red>255</Red>
          <Green>255</Green>
          <Blue>255</Blue>
        </Background>
        <Outline>
          <Style>Solid</Style>
          <Thickness>1</Thickness>
          <Color>
            <Transparency>255</Transparency>
            <Red>0</Red>
            <Green>0</Green>
            <Blue>0</Blue>
          </Color>
        </Outline>
        <Insets>
          <Top>0.0</Top>
          <Left>2.0</Left>
          <Bottom>0.0</Bottom>
          <Right>3.0</Right>
        </Insets>
        <Visible>false</Visible>
      </Title>
      <TitlePosition>Left</TitlePosition>
      <SeriesDefinitions>
        <Query>
          <Definition>row[&quot;mailingName&quot;]</Definition>
          <Grouping>
            <GroupingUnit>String</GroupingUnit>
            <GroupingInterval>1.0</GroupingInterval>
            <GroupType>Text</GroupType>
          </Grouping>
        </Query>
        <SeriesPalette>
          <Entries xsi:type="attribute:ColorDefinition">
            <Transparency>255</Transparency>
            <Red>46</Red>
            <Green>52</Green>
            <Blue>54</Blue>
          </Entries>
          <Entries xsi:type="attribute:ColorDefinition">
            <Transparency>255</Transparency>
            <Red>136</Red>
            <Green>138</Green>
            <Blue>133</Blue>
          </Entries>
          <Entries xsi:type="attribute:ColorDefinition">
            <Transparency>255</Transparency>
            <Red>146</Red>
            <Green>208</Green>
            <Blue>79</Blue>
          </Entries>
          <Entries xsi:type="attribute:ColorDefinition">
            <Transparency>255</Transparency>
            <Red>255</Red>
            <Green>192</Green>
            <Blue>0</Blue>
          </Entries>
          <Entries xsi:type="attribute:ColorDefinition">
            <Transparency>255</Transparency>
            <Red>0</Red>
            <Green>153</Green>
            <Blue>153</Blue>
          </Entries>
          <Entries xsi:type="attribute:ColorDefinition">
            <Transparency>255</Transparency>
            <Red>65</Red>
            <Green>100</Green>
            <Blue>26</Blue>
          </Entries>
          <Entries xsi:type="attribute:ColorDefinition">
            <Transparency>255</Transparency>
            <Red>0</Red>
            <Green>113</Green>
            <Blue>185</Blue>
          </Entries>
        </SeriesPalette>
        <Series xsi:type="type:BarSeries">
          <Visible>true</Visible>
          <Label>
            <Caption>
              <Value></Value>
              <Font>
                <Name>Arial</Name>
                <Size>10.0</Size>
                <Alignment/>
              </Font>
              <Color>
                <Transparency>255</Transparency>
                <Red>79</Red>
                <Green>80</Green>
                <Blue>81</Blue>
              </Color>
            </Caption>
            <Background xsi:type="attribute:ColorDefinition">
              <Transparency>0</Transparency>
              <Red>255</Red>
              <Green>255</Green>
              <Blue>255</Blue>
            </Background>
            <Outline>
              <Style>Solid</Style>
              <Thickness>1</Thickness>
              <Color>
                <Transparency>255</Transparency>
                <Red>0</Red>
                <Green>0</Green>
                <Blue>0</Blue>
              </Color>
              <Visible>false</Visible>
            </Outline>
            <Insets>
              <Top>0.0</Top>
              <Left>10.0</Left>
              <Bottom>0.0</Bottom>
              <Right>3.0</Right>
            </Insets>
            <Visible>true</Visible>
          </Label>
          <DataDefinition>
            <Definition>row[&quot;value&quot;] > 0 ? (row[&quot;category_index&quot;] != CommonKeys.REVENUE_INDEX ? row[&quot;value&quot;] : row[&quot;value&quot;]/100) : 0.000001</Definition>
            <Grouping>
              <GroupType>Text</GroupType>
              <AggregateExpression>Sum</AggregateExpression>
            </Grouping>
          </DataDefinition>
          <SeriesIdentifier>Series 1</SeriesIdentifier>
          <DataPoint>
            <Components>
              <Type>Orthogonal_Value</Type>
              <FormatSpecifier xsi:type="attribute:NumberFormatSpecifier">
                <Prefix></Prefix>
                <Suffix></Suffix>
                <FractionDigits>0</FractionDigits>
              </FormatSpecifier>
            </Components>
            <Components>
              <Type>Series_Value</Type>
            </Components>
            <Suffix></Suffix>
            <Separator>;</Separator>
          </DataPoint>
          <LabelPosition>Outside</LabelPosition>
          <Stacked>false</Stacked>
          <Triggers>
            <Condition>onmouseover</Condition>
            <Action>
              <Type>Show_Tooltip</Type>
              <Value xsi:type="attribute:TooltipValue">
                <Text>row[&quot;tooltip&quot;]</Text>
                <Delay>200</Delay>
              </Value>
            </Action>
          </Triggers>
          <Cursor>
            <Type>Auto</Type>
          </Cursor>
          <Riser>Rectangle</Riser>
          <RiserOutline>
            <Transparency>0</Transparency>
            <Red>255</Red>
            <Green>255</Green>
            <Blue>255</Blue>
          </RiserOutline>
        </Series>
        <Grouping>
          <Enabled>false</Enabled>
          <GroupingInterval>1.0</GroupingInterval>
          <GroupType>Text</GroupType>
          <AggregateExpression>Sum</AggregateExpression>
        </Grouping>
        <Sorting>Descending</Sorting>
        <SortKey>
          <Definition>getKeyFiguresColumnPositionByName(row[&quot;mailingName&quot;])</Definition>
        </SortKey>
        <SortStrength>0</SortStrength>
      </SeriesDefinitions>
      <Orientation>Vertical</Orientation>
      <LineAttributes>
        <Style>Solid</Style>
        <Thickness>1</Thickness>
        <Color>
          <Transparency>0</Transparency>
          <Red>255</Red>
          <Green>255</Green>
          <Blue>255</Blue>
        </Color>
        <Visible>true</Visible>
      </LineAttributes>
      <Label>
        <Caption>
          <Value></Value>
          <Font>
            <Name>Arial</Name>
            <Size>10.0</Size>
            <Alignment/>
          </Font>
          <Color>
            <Transparency>255</Transparency>
            <Red>79</Red>
            <Green>80</Green>
            <Blue>81</Blue>
          </Color>
        </Caption>
        <Background xsi:type="attribute:ColorDefinition">
          <Transparency>0</Transparency>
          <Red>255</Red>
          <Green>255</Green>
          <Blue>255</Blue>
        </Background>
        <Outline>
          <Style>Solid</Style>
          <Thickness>1</Thickness>
          <Color>
            <Transparency>255</Transparency>
            <Red>0</Red>
            <Green>0</Green>
            <Blue>0</Blue>
          </Color>
        </Outline>
        <Insets>
          <Top>10.0</Top>
          <Left>2.0</Left>
          <Bottom>0.0</Bottom>
          <Right>3.0</Right>
        </Insets>
        <Visible>true</Visible>
      </Label>
      <LabelPosition>Left</LabelPosition>
      <MajorGrid>
        <LineAttributes>
          <Style>Solid</Style>
          <Thickness>1</Thickness>
          <Color>
            <Transparency>255</Transparency>
            <Red>196</Red>
            <Green>196</Green>
            <Blue>196</Blue>
          </Color>
          <Visible>false</Visible>
        </LineAttributes>
        <TickStyle>Across</TickStyle>
        <TickAttributes>
          <Style>Solid</Style>
          <Thickness>1</Thickness>
          <Color>
            <Transparency>255</Transparency>
            <Red>204</Red>
            <Green>204</Green>
            <Blue>204</Blue>
          </Color>
          <Visible>true</Visible>
        </TickAttributes>
      </MajorGrid>
      <MinorGrid>
        <LineAttributes>
          <Style>Solid</Style>
          <Thickness>1</Thickness>
          <Color>
            <Transparency>255</Transparency>
            <Red>225</Red>
            <Green>225</Green>
            <Blue>225</Blue>
          </Color>
          <Visible>false</Visible>
        </LineAttributes>
        <TickStyle>Across</TickStyle>
        <TickAttributes>
          <Style>Solid</Style>
          <Thickness>1</Thickness>
          <Color>
            <Transparency>255</Transparency>
            <Red>225</Red>
            <Green>225</Green>
            <Blue>225</Blue>
          </Color>
          <Visible>false</Visible>
        </TickAttributes>
      </MinorGrid>
      <Scale>
        <Min xsi:type="data:NumberDataElement">
          <Value>0.0</Value>
        </Min>
        <MinorGridsPerUnit>5</MinorGridsPerUnit>
        <ShowOutside>false</ShowOutside>
        <AutoExpand>true</AutoExpand>
      </Scale>
      <Origin>
        <Type>Min</Type>
        <Value xsi:type="data:NumberDataElement">
          <Value>0.0</Value>
        </Value>
      </Origin>
      <PrimaryAxis>true</PrimaryAxis>
      <Percent>false</Percent>
      <SideBySide>false</SideBySide>
    </AssociatedAxes>
    <AncillaryAxes>
      <Type>Text</Type>
      <Title>
        <Caption>
          <Value>Z-Axis Title</Value>
          <Font>
            <Size>14.0</Size>
            <Bold>true</Bold>
            <Alignment>
              <horizontalAlignment>Center</horizontalAlignment>
              <verticalAlignment>Center</verticalAlignment>
            </Alignment>
          </Font>
        </Caption>
        <Background xsi:type="attribute:ColorDefinition">
          <Transparency>0</Transparency>
          <Red>255</Red>
          <Green>255</Green>
          <Blue>255</Blue>
        </Background>
        <Outline>
          <Style>Solid</Style>
          <Thickness>1</Thickness>
          <Color>
            <Transparency>255</Transparency>
            <Red>0</Red>
            <Green>0</Green>
            <Blue>0</Blue>
          </Color>
        </Outline>
        <Insets>
          <Top>0.0</Top>
          <Left>2.0</Left>
          <Bottom>0.0</Bottom>
          <Right>3.0</Right>
        </Insets>
        <Visible>false</Visible>
      </Title>
      <TitlePosition>Below</TitlePosition>
      <SeriesDefinitions>
        <Query>
          <Definition></Definition>
        </Query>
        <SeriesPalette>
          <Entries xsi:type="attribute:ColorDefinition">
            <Transparency>255</Transparency>
            <Red>80</Red>
            <Green>166</Green>
            <Blue>218</Blue>
          </Entries>
          <Entries xsi:type="attribute:ColorDefinition">
            <Transparency>255</Transparency>
            <Red>242</Red>
            <Green>88</Green>
            <Blue>106</Blue>
          </Entries>
          <Entries xsi:type="attribute:ColorDefinition">
            <Transparency>255</Transparency>
            <Red>232</Red>
            <Green>172</Green>
            <Blue>57</Blue>
          </Entries>
          <Entries xsi:type="attribute:ColorDefinition">
            <Transparency>255</Transparency>
            <Red>128</Red>
            <Green>255</Green>
            <Blue>128</Blue>
          </Entries>
          <Entries xsi:type="attribute:ColorDefinition">
            <Transparency>255</Transparency>
            <Red>64</Red>
            <Green>128</Green>
            <Blue>128</Blue>
          </Entries>
          <Entries xsi:type="attribute:ColorDefinition">
            <Transparency>255</Transparency>
            <Red>128</Red>
            <Green>128</Green>
            <Blue>192</Blue>
          </Entries>
          <Entries xsi:type="attribute:ColorDefinition">
            <Transparency>255</Transparency>
            <Red>170</Red>
            <Green>85</Green>
            <Blue>85</Blue>
          </Entries>
          <Entries xsi:type="attribute:ColorDefinition">
            <Transparency>255</Transparency>
            <Red>128</Red>
            <Green>128</Green>
            <Blue>0</Blue>
          </Entries>
          <Entries xsi:type="attribute:ColorDefinition">
            <Transparency>255</Transparency>
            <Red>192</Red>
            <Green>192</Green>
            <Blue>192</Blue>
          </Entries>
          <Entries xsi:type="attribute:ColorDefinition">
            <Transparency>255</Transparency>
            <Red>255</Red>
            <Green>255</Green>
            <Blue>128</Blue>
          </Entries>
          <Entries xsi:type="attribute:ColorDefinition">
            <Transparency>255</Transparency>
            <Red>128</Red>
            <Green>192</Green>
            <Blue>128</Blue>
          </Entries>
          <Entries xsi:type="attribute:ColorDefinition">
            <Transparency>255</Transparency>
            <Red>7</Red>
            <Green>146</Green>
            <Blue>94</Blue>
          </Entries>
          <Entries xsi:type="attribute:ColorDefinition">
            <Transparency>255</Transparency>
            <Red>0</Red>
            <Green>128</Green>
            <Blue>255</Blue>
          </Entries>
          <Entries xsi:type="attribute:ColorDefinition">
            <Transparency>255</Transparency>
            <Red>255</Red>
            <Green>128</Green>
            <Blue>192</Blue>
          </Entries>
          <Entries xsi:type="attribute:ColorDefinition">
            <Transparency>255</Transparency>
            <Red>0</Red>
            <Green>255</Green>
            <Blue>255</Blue>
          </Entries>
          <Entries xsi:type="attribute:ColorDefinition">
            <Transparency>255</Transparency>
            <Red>255</Red>
            <Green>128</Green>
            <Blue>128</Blue>
          </Entries>
          <Entries xsi:type="attribute:ColorDefinition">
            <Transparency>255</Transparency>
            <Red>0</Red>
            <Green>128</Green>
            <Blue>192</Blue>
          </Entries>
          <Entries xsi:type="attribute:ColorDefinition">
            <Transparency>255</Transparency>
            <Red>128</Red>
            <Green>128</Green>
            <Blue>192</Blue>
          </Entries>
          <Entries xsi:type="attribute:ColorDefinition">
            <Transparency>255</Transparency>
            <Red>255</Red>
            <Green>0</Green>
            <Blue>255</Blue>
          </Entries>
          <Entries xsi:type="attribute:ColorDefinition">
            <Transparency>255</Transparency>
            <Red>128</Red>
            <Green>64</Green>
            <Blue>64</Blue>
          </Entries>
          <Entries xsi:type="attribute:ColorDefinition">
            <Transparency>255</Transparency>
            <Red>255</Red>
            <Green>128</Green>
            <Blue>64</Blue>
          </Entries>
          <Entries xsi:type="attribute:ColorDefinition">
            <Transparency>255</Transparency>
            <Red>80</Red>
            <Green>240</Green>
            <Blue>120</Blue>
          </Entries>
          <Entries xsi:type="attribute:ColorDefinition">
            <Transparency>255</Transparency>
            <Red>0</Red>
            <Green>64</Green>
            <Blue>128</Blue>
          </Entries>
          <Entries xsi:type="attribute:ColorDefinition">
            <Transparency>255</Transparency>
            <Red>128</Red>
            <Green>0</Green>
            <Blue>64</Blue>
          </Entries>
          <Entries xsi:type="attribute:ColorDefinition">
            <Transparency>255</Transparency>
            <Red>255</Red>
            <Green>0</Green>
            <Blue>128</Blue>
          </Entries>
          <Entries xsi:type="attribute:ColorDefinition">
            <Transparency>255</Transparency>
            <Red>128</Red>
            <Green>128</Green>
            <Blue>64</Blue>
          </Entries>
          <Entries xsi:type="attribute:ColorDefinition">
            <Transparency>255</Transparency>
            <Red>128</Red>
            <Green>128</Green>
            <Blue>128</Blue>
          </Entries>
          <Entries xsi:type="attribute:ColorDefinition">
            <Transparency>255</Transparency>
            <Red>255</Red>
            <Green>128</Green>
            <Blue>255</Blue>
          </Entries>
          <Entries xsi:type="attribute:ColorDefinition">
            <Transparency>255</Transparency>
            <Red>0</Red>
            <Green>64</Green>
            <Blue>0</Blue>
          </Entries>
          <Entries xsi:type="attribute:ColorDefinition">
            <Transparency>255</Transparency>
            <Red>0</Red>
            <Green>0</Green>
            <Blue>0</Blue>
          </Entries>
          <Entries xsi:type="attribute:ColorDefinition">
            <Transparency>255</Transparency>
            <Red>255</Red>
            <Green>255</Green>
            <Blue>255</Blue>
          </Entries>
          <Entries xsi:type="attribute:ColorDefinition">
            <Transparency>255</Transparency>
            <Red>255</Red>
            <Green>128</Green>
            <Blue>0</Blue>
          </Entries>
        </SeriesPalette>
        <Series>
          <Visible>true</Visible>
          <Label>
            <Caption>
              <Value></Value>
              <Font>
                <Alignment/>
              </Font>
            </Caption>
            <Background xsi:type="attribute:ColorDefinition">
              <Transparency>0</Transparency>
              <Red>255</Red>
              <Green>255</Green>
              <Blue>255</Blue>
            </Background>
            <Outline>
              <Style>Solid</Style>
              <Thickness>1</Thickness>
              <Color>
                <Transparency>255</Transparency>
                <Red>0</Red>
                <Green>0</Green>
                <Blue>0</Blue>
              </Color>
              <Visible>false</Visible>
            </Outline>
            <Insets>
              <Top>0.0</Top>
              <Left>2.0</Left>
              <Bottom>0.0</Bottom>
              <Right>3.0</Right>
            </Insets>
            <Visible>false</Visible>
          </Label>
          <SeriesIdentifier></SeriesIdentifier>
          <DataPoint>
            <Components>
              <Type>Orthogonal_Value</Type>
            </Components>
            <Separator>, </Separator>
          </DataPoint>
          <LabelPosition>Outside</LabelPosition>
          <Stacked>false</Stacked>
        </Series>
        <Grouping>
          <GroupType>Text</GroupType>
          <AggregateExpression>Sum</AggregateExpression>
        </Grouping>
      </SeriesDefinitions>
      <Orientation>Horizontal</Orientation>
      <LineAttributes>
        <Style>Solid</Style>
        <Thickness>1</Thickness>
        <Visible>true</Visible>
      </LineAttributes>
      <Label>
        <Caption>
          <Value></Value>
          <Font>
            <Alignment/>
          </Font>
        </Caption>
        <Background xsi:type="attribute:ColorDefinition">
          <Transparency>0</Transparency>
          <Red>255</Red>
          <Green>255</Green>
          <Blue>255</Blue>
        </Background>
        <Outline>
          <Style>Solid</Style>
          <Thickness>1</Thickness>
          <Color>
            <Transparency>255</Transparency>
            <Red>0</Red>
            <Green>0</Green>
            <Blue>0</Blue>
          </Color>
        </Outline>
        <Insets>
          <Top>0.0</Top>
          <Left>2.0</Left>
          <Bottom>0.0</Bottom>
          <Right>3.0</Right>
        </Insets>
        <Visible>true</Visible>
      </Label>
      <LabelPosition>Below</LabelPosition>
      <MajorGrid>
        <LineAttributes>
          <Style>Solid</Style>
          <Thickness>1</Thickness>
          <Color>
            <Transparency>255</Transparency>
            <Red>196</Red>
            <Green>196</Green>
            <Blue>196</Blue>
          </Color>
          <Visible>false</Visible>
        </LineAttributes>
        <TickStyle>Across</TickStyle>
        <TickAttributes>
          <Style>Solid</Style>
          <Thickness>1</Thickness>
          <Color>
            <Transparency>255</Transparency>
            <Red>196</Red>
            <Green>196</Green>
            <Blue>196</Blue>
          </Color>
          <Visible>true</Visible>
        </TickAttributes>
      </MajorGrid>
      <MinorGrid>
        <LineAttributes>
          <Style>Solid</Style>
          <Thickness>1</Thickness>
          <Color>
            <Transparency>255</Transparency>
            <Red>225</Red>
            <Green>225</Green>
            <Blue>225</Blue>
          </Color>
          <Visible>false</Visible>
        </LineAttributes>
        <TickStyle>Across</TickStyle>
        <TickAttributes>
          <Style>Solid</Style>
          <Thickness>1</Thickness>
          <Color>
            <Transparency>255</Transparency>
            <Red>225</Red>
            <Green>225</Green>
            <Blue>225</Blue>
          </Color>
          <Visible>false</Visible>
        </TickAttributes>
      </MinorGrid>
      <Scale>
        <MinorGridsPerUnit>5</MinorGridsPerUnit>
      </Scale>
      <Origin>
        <Type>Min</Type>
        <Value xsi:type="data:NumberDataElement">
          <Value>0.0</Value>
        </Value>
      </Origin>
      <PrimaryAxis>true</PrimaryAxis>
      <Percent>false</Percent>
    </AncillaryAxes>
    <SeriesDefinitions>
      <Query>
        <Definition></Definition>
      </Query>
      <SeriesPalette>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>80</Red>
          <Green>166</Green>
          <Blue>218</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>242</Red>
          <Green>88</Green>
          <Blue>106</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>232</Red>
          <Green>172</Green>
          <Blue>57</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>128</Red>
          <Green>255</Green>
          <Blue>128</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>64</Red>
          <Green>128</Green>
          <Blue>128</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>128</Red>
          <Green>128</Green>
          <Blue>192</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>170</Red>
          <Green>85</Green>
          <Blue>85</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>128</Red>
          <Green>128</Green>
          <Blue>0</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>192</Red>
          <Green>192</Green>
          <Blue>192</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>255</Red>
          <Green>255</Green>
          <Blue>128</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>128</Red>
          <Green>192</Green>
          <Blue>128</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>7</Red>
          <Green>146</Green>
          <Blue>94</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>0</Red>
          <Green>128</Green>
          <Blue>255</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>255</Red>
          <Green>128</Green>
          <Blue>192</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>0</Red>
          <Green>255</Green>
          <Blue>255</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>255</Red>
          <Green>128</Green>
          <Blue>128</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>0</Red>
          <Green>128</Green>
          <Blue>192</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>128</Red>
          <Green>128</Green>
          <Blue>192</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>255</Red>
          <Green>0</Green>
          <Blue>255</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>128</Red>
          <Green>64</Green>
          <Blue>64</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>255</Red>
          <Green>128</Green>
          <Blue>64</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>80</Red>
          <Green>240</Green>
          <Blue>120</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>0</Red>
          <Green>64</Green>
          <Blue>128</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>128</Red>
          <Green>0</Green>
          <Blue>64</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>255</Red>
          <Green>0</Green>
          <Blue>128</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>128</Red>
          <Green>128</Green>
          <Blue>64</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>128</Red>
          <Green>128</Green>
          <Blue>128</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>255</Red>
          <Green>128</Green>
          <Blue>255</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>0</Red>
          <Green>64</Green>
          <Blue>0</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>0</Red>
          <Green>0</Green>
          <Blue>0</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>255</Red>
          <Green>255</Green>
          <Blue>255</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>255</Red>
          <Green>128</Green>
          <Blue>0</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>255</Red>
          <Green>255</Green>
          <Blue>255</Blue>
        </Entries>
      </SeriesPalette>
      <Series>
        <Visible>true</Visible>
        <Label>
          <Caption>
            <Value></Value>
            <Font>
              <Alignment/>
            </Font>
          </Caption>
          <Background xsi:type="attribute:ColorDefinition">
            <Transparency>0</Transparency>
            <Red>255</Red>
            <Green>255</Green>
            <Blue>255</Blue>
          </Background>
          <Outline>
            <Style>Solid</Style>
            <Thickness>1</Thickness>
            <Color>
              <Transparency>255</Transparency>
              <Red>0</Red>
              <Green>0</Green>
              <Blue>0</Blue>
            </Color>
            <Visible>false</Visible>
          </Outline>
          <Insets>
            <Top>0.0</Top>
            <Left>2.0</Left>
            <Bottom>0.0</Bottom>
            <Right>3.0</Right>
          </Insets>
          <Visible>false</Visible>
        </Label>
        <DataDefinition>
          <Definition>row[&quot;categoryKey&quot;]</Definition>
        </DataDefinition>
        <SeriesIdentifier></SeriesIdentifier>
        <DataPoint>
          <Components>
            <Type>Orthogonal_Value</Type>
          </Components>
          <Separator>, </Separator>
        </DataPoint>
        <LabelPosition>Outside</LabelPosition>
        <Stacked>false</Stacked>
      </Series>
      <Grouping>
        <Enabled>true</Enabled>
        <GroupingInterval>1.0</GroupingInterval>
        <GroupType>Text</GroupType>
        <AggregateExpression>Last</AggregateExpression>
      </Grouping>
      <Sorting>Descending</Sorting>
      <SortKey>
        <Definition>getKeyFiguresRowPosition(row[&quot;categoryKey&quot;], row[&quot;category_index&quot;])</Definition>
      </SortKey>
    </SeriesDefinitions>
    <Orientation>Horizontal</Orientation>
    <LineAttributes>
      <Style>Solid</Style>
      <Thickness>1</Thickness>
      <Color>
        <Transparency>0</Transparency>
        <Red>255</Red>
        <Green>255</Green>
        <Blue>255</Blue>
      </Color>
      <Visible>false</Visible>
    </LineAttributes>
    <Label>
      <Caption>
        <Value></Value>
        <Font>
          <Name>Arial</Name>
          <Size>10.0</Size>
          <Bold>false</Bold>
          <Alignment/>
        </Font>
        <Color>
          <Transparency>255</Transparency>
          <Red>0</Red>
          <Green>0</Green>
          <Blue>0</Blue>
        </Color>
      </Caption>
      <Background xsi:type="attribute:ColorDefinition">
        <Transparency>0</Transparency>
        <Red>255</Red>
        <Green>255</Green>
        <Blue>255</Blue>
      </Background>
      <Outline>
        <Style>Solid</Style>
        <Thickness>1</Thickness>
        <Color>
          <Transparency>255</Transparency>
          <Red>0</Red>
          <Green>0</Green>
          <Blue>0</Blue>
        </Color>
        <Visible>false</Visible>
      </Outline>
      <Insets>
        <Top>0.0</Top>
        <Left>0.0</Left>
        <Bottom>0.0</Bottom>
        <Right>0.0</Right>
      </Insets>
      <Visible>true</Visible>
      <Ellipsis>40</Ellipsis>
    </Label>
    <LabelPosition>Below</LabelPosition>
    <Staggered>false</Staggered>
    <Interval>1</Interval>
    <MajorGrid>
      <LineAttributes>
        <Style>Solid</Style>
        <Thickness>1</Thickness>
        <Color>
          <Transparency>255</Transparency>
          <Red>196</Red>
          <Green>196</Green>
          <Blue>196</Blue>
        </Color>
        <Visible>false</Visible>
      </LineAttributes>
      <TickStyle>Across</TickStyle>
      <TickAttributes>
        <Style>Solid</Style>
        <Thickness>1</Thickness>
        <Color>
          <Transparency>255</Transparency>
          <Red>196</Red>
          <Green>196</Green>
          <Blue>196</Blue>
        </Color>
        <Visible>false</Visible>
      </TickAttributes>
    </MajorGrid>
    <MinorGrid>
      <LineAttributes>
        <Style>Solid</Style>
        <Thickness>1</Thickness>
        <Color>
          <Transparency>255</Transparency>
          <Red>225</Red>
          <Green>225</Green>
          <Blue>225</Blue>
        </Color>
        <Visible>false</Visible>
      </LineAttributes>
      <TickStyle>Across</TickStyle>
      <TickAttributes>
        <Style>Solid</Style>
        <Thickness>1</Thickness>
        <Color>
          <Transparency>255</Transparency>
          <Red>225</Red>
          <Green>225</Green>
          <Blue>225</Blue>
        </Color>
        <Visible>false</Visible>
      </TickAttributes>
    </MinorGrid>
    <Scale>
      <MinorGridsPerUnit>5</MinorGridsPerUnit>
      <ShowOutside>false</ShowOutside>
      <TickBetweenCategories>true</TickBetweenCategories>
      <MajorGridsStepNumber>1</MajorGridsStepNumber>
    </Scale>
    <Origin>
      <Type>Min</Type>
    </Origin>
    <PrimaryAxis>true</PrimaryAxis>
    <CategoryAxis>true</CategoryAxis>
    <Percent>false</Percent>
  </Axes>
  <WallFill xsi:type="attribute:ColorDefinition">
    <Transparency>255</Transparency>
    <Red>192</Red>
    <Green>192</Green>
    <Blue>192</Blue>
  </WallFill>
  <FloorFill xsi:type="attribute:ColorDefinition">
    <Transparency>255</Transparency>
    <Red>192</Red>
    <Green>192</Green>
    <Blue>192</Blue>
  </FloorFill>
  <Orientation>Horizontal</Orientation>
  <UnitSpacing>22.0</UnitSpacing>
  <Rotation>
    <Angles>
      <XAngle>-20.0</XAngle>
      <YAngle>45.0</YAngle>
      <ZAngle>0.0</ZAngle>
      <Type>None</Type>
    </Angles>
  </Rotation>
  <ReverseCategory>false</ReverseCategory>
</model:ChartWithAxes>
]]></xml-property>
                                    <property name="outputFormat">SVG</property>
                                    <list-property name="filter">
                                        <structure>
                                            <property name="operator">is-true</property>
                                            <expression name="expr" type="javascript">row["category_index"] &lt;= CommonKeys.REVENUE_INDEX ||
row["category_index"] == CommonKeys.OPENINGS_ANONYMOUS_INDEX ||
row["category_index"] == CommonKeys.CLICKS_ANONYMOUS_INDEX</expression>
                                            <property name="updateAggregation">true</property>
                                        </structure>
                                    </list-property>
                                    <property name="inheritColumns">true</property>
                                    <property name="marginTop">0px</property>
                                    <property name="marginBottom">0px</property>
                                    <property name="height">760px</property>
                                    <property name="width">747px</property>
                                    <list-property name="visibility">
                                        <structure>
                                            <property name="format">all</property>
                                            <expression name="valueExpr" type="javascript">reportContext.getPersistentGlobalVariable("showGross") == false</expression>
                                        </structure>
                                    </list-property>
                                </extended-item>
                            </cell>
                        </row>
                    </grid>
                </cell>
            </row>
            <row id="1282">
                <cell id="1283">
                    <property name="colSpan">2</property>
                    <property name="rowSpan">1</property>
                    <property name="style">full-width</property>
                    <extended-item extensionName="Crosstab" extensionVersion="3.7.0" name="summaryTable"
 id="1404">
                        <property name="cube">SummaryOptimizationDataCube</property>
                        <property name="measures">
                            <extended-item extensionName="MeasureView" id="1416">
                                <property name="measure">value</property>
                                <property name="detail">
                                    <extended-item extensionName="AggregationCell" id="1417">
                                        <property name="aggregationOnRow">categoryGroup/category_index</property>
                                        <property name="aggregationOnColumn">optimizationGroup/optimizationGroupId</property>
                                        <property name="content">
                                            <text-data id="828">
                                                <list-property name="visibility">
                                                    <structure>
                                                        <property name="format">all</property>
                                                        <expression name="valueExpr" type="javascript">data["value_categoryGroup/category_index_optimizationGroup/optimizationGroupId"] >= 0 &amp;&amp;
data["value_categoryGroup/category_index_optimizationGroup/optimizationGroupId"] != null</expression>
                                                    </structure>
                                                </list-property>
                                                <expression name="valueExpr">tr("NotAvailableShort")</expression>
                                            </text-data>
                                            <data id="1437">
                                                <structure name="numberFormat">
                                                    <property name="category">Currency</property>
                                                    <property name="pattern">#,##0.00{RoundingMode=HALF_UP}</property>
                                                </structure>
                                                <list-property name="visibility">
                                                    <structure>
                                                        <property name="format">all</property>
                                                        <expression name="valueExpr" type="javascript">data["value_categoryGroup/category_index_optimizationGroup/optimizationGroupId"] &lt; 0 ||
data["value_categoryGroup/category_index_optimizationGroup/optimizationGroupId"] == null ||
data["category_index"] != CommonKeys.REVENUE_INDEX</expression>
                                                    </structure>
                                                </list-property>
                                                <property name="resultSetColumn">revenue</property>
                                            </data>
                                            <data id="1418">
                                                <structure name="numberFormat">
                                                    <property name="category">Currency</property>
                                                    <property name="pattern">#,##0{RoundingMode=HALF_UP}</property>
                                                </structure>
                                                <list-property name="visibility">
                                                    <structure>
                                                        <property name="format">all</property>
                                                        <expression name="valueExpr" type="javascript">data["value_categoryGroup/category_index_optimizationGroup/optimizationGroupId"] &lt; 0 ||
data["value_categoryGroup/category_index_optimizationGroup/optimizationGroupId"] == null ||
data["category_index"] == CommonKeys.REVENUE_INDEX</expression>
                                                    </structure>
                                                </list-property>
                                                <property name="resultSetColumn">value_categoryGroup/category_index_optimizationGroup/optimizationGroupId</property>
                                            </data>
                                        </property>
                                        <property name="style">crosstab-value</property>
                                    </extended-item>
                                </property>
                                <property name="header">
                                    <extended-item extensionName="CrosstabCell" id="1419">
                                        <property name="style">to-hide</property>
                                    </extended-item>
                                </property>
                            </extended-item>
                            <extended-item extensionName="MeasureView" id="1421">
                                <property name="measure">rate</property>
                                <property name="detail">
                                    <extended-item extensionName="AggregationCell" id="1422">
                                        <property name="aggregationOnRow">categoryGroup/category_index</property>
                                        <property name="aggregationOnColumn">optimizationGroup/optimizationGroupId</property>
                                        <property name="content">
                                            <text-data id="829">
                                                <list-property name="visibility">
                                                    <structure>
                                                        <property name="format">all</property>
                                                        <expression name="valueExpr" type="javascript">data["value_categoryGroup/category_index_optimizationGroup/optimizationGroupId"] >= 0 &amp;&amp;
data["value_categoryGroup/category_index_optimizationGroup/optimizationGroupId"] != null</expression>
                                                    </structure>
                                                </list-property>
                                                <expression name="valueExpr">tr("NotAvailableShort")</expression>
                                            </text-data>
                                            <data id="1423">
                                                <structure name="numberFormat">
                                                    <property name="category">Custom</property>
                                                    <property name="pattern">(0.0%)</property>
                                                </structure>
                                                <list-property name="visibility">
                                                    <structure>
                                                        <property name="format">all</property>
                                                        <expression name="valueExpr" type="javascript">data["value_categoryGroup/category_index_optimizationGroup/optimizationGroupId"] &lt; 0 ||
data["value_categoryGroup/category_index_optimizationGroup/optimizationGroupId"] == null</expression>
                                                    </structure>
                                                </list-property>
                                                <property name="resultSetColumn">rate_categoryGroup/category_index_optimizationGroup/optimizationGroupId</property>
                                            </data>
                                        </property>
                                        <property name="style">crosstab-value</property>
                                    </extended-item>
                                </property>
                                <property name="header">
                                    <extended-item extensionName="CrosstabCell" id="1424">
                                        <property name="style">to-hide</property>
                                    </extended-item>
                                </property>
                            </extended-item>
                        </property>
                        <property name="rows">
                            <extended-item extensionName="CrosstabView" id="1406">
                                <property name="views">
                                    <extended-item extensionName="DimensionView" id="1407">
                                        <property name="dimension">categoryGroup</property>
                                        <property name="levels">
                                            <extended-item extensionName="LevelView" name="NewLevel View" id="1408">
                                                <property name="level">categoryGroup/category_index</property>
                                                <property name="sort">
                                                    <sort-element>
                                                        <expression name="key" type="javascript">getKeyFiguresRowPosition(dimension["categoryGroup"]["category_index"]["categoryKey"], dimension["categoryGroup"]["category_index"])</expression>
                                                        <property name="direction">asc</property>
                                                    </sort-element>
                                                </property>
                                                <property name="member">
                                                    <extended-item extensionName="CrosstabCell" id="1409">
                                                        <property name="content">
                                                            <data name="category_index" id="1410">
                                                                <property name="resultSetColumn">category</property>
                                                            </data>
                                                        </property>
                                                        <property name="textAlign">left</property>
                                                    </extended-item>
                                                </property>
                                            </extended-item>
                                        </property>
                                    </extended-item>
                                </property>
                            </extended-item>
                        </property>
                        <property name="columns">
                            <extended-item extensionName="CrosstabView" id="1433">
                                <property name="views">
                                    <extended-item extensionName="DimensionView" id="1411">
                                        <property name="dimension">optimizationGroup</property>
                                        <property name="levels">
                                            <extended-item extensionName="LevelView" name="NewLevel View1" id="1412">
                                                <property name="level">optimizationGroup/optimizationGroupId</property>
                                                <property name="sort">
                                                    <sort-element>
                                                        <expression name="key" type="javascript">getCrossTableColumnPosition(dimension["optimizationGroup"]["optimizationGroupId"])</expression>
                                                        <property name="direction">asc</property>
                                                        <property name="strength">-1</property>
                                                    </sort-element>
                                                </property>
                                                <property name="member">
                                                    <extended-item extensionName="CrosstabCell" id="1413">
                                                        <property name="content">
                                                            <data name="optimizationGroup12" id="1874">
                                                                <property name="textAlign">left</property>
                                                                <property name="display">inline</property>
                                                                <property name="resultSetColumn">groupTitle</property>
                                                            </data>
                                                            <image id="1875">
                                                                <property name="display">inline</property>
                                                                <property name="height">16px</property>
                                                                <property name="width">16px</property>
                                                                <list-property name="visibility">
                                                                    <structure>
                                                                        <property name="format">all</property>
                                                                        <expression name="valueExpr" type="javascript">!isWinnerMailing(data["optimizationGroupId"])</expression>
                                                                    </structure>
                                                                </list-property>
                                                                <property name="source">embed</property>
                                                                <property name="imageName">ok_icon.png</property>
                                                            </image>
                                                        </property>
                                                        <property name="textAlign">center</property>
                                                        <property name="verticalAlign">middle</property>
                                                        <property name="style">table-head crosstab-header</property>
                                                    </extended-item>
                                                </property>
                                            </extended-item>
                                        </property>
                                    </extended-item>
                                </property>
                            </extended-item>
                        </property>
                        <property name="header">
                            <extended-item extensionName="CrosstabCell" id="1434">
                                <property name="content">
                                    <text-data id="1438">
                                        <expression name="valueExpr">tr("KeydataGeneral")</expression>
                                        <property name="contentType">html</property>
                                    </text-data>
                                </property>
                                <property name="style">table-head</property>
                            </extended-item>
                        </property>
                        <property name="filter">
                            <filter-condition-element>
                                <expression name="expr" type="javascript">data["category_index"] &lt;= CommonKeys.REVENUE_INDEX ||
data["category_index"] == CommonKeys.OPENINGS_ANONYMOUS_INDEX ||
data["category_index"] == CommonKeys.CLICKS_ANONYMOUS_INDEX</expression>
                                <property name="operator">is-true</property>
                            </filter-condition-element>
                        </property>
                        <list-property name="visibility">
                            <structure>
                                <property name="format">all</property>
                                <expression name="valueExpr" type="javascript">reportContext.getPersistentGlobalVariable("showGross") == false</expression>
                            </structure>
                        </list-property>
                        <list-property name="boundDataColumns">
                            <structure>
                                <property name="name">category_index</property>
                                <expression name="expression">dimension["categoryGroup"]["category_index"]</expression>
                                <property name="dataType">integer</property>
                            </structure>
                            <structure>
                                <property name="name">optimizationGroup</property>
                                <expression name="expression" type="javascript">dimension["optimizationGroup"]["optimizationGroupId"]</expression>
                                <property name="dataType">integer</property>
                            </structure>
                            <structure>
                                <property name="name">value_categoryGroup/category_index</property>
                                <expression name="expression">measure["value"]</expression>
                                <property name="dataType">integer</property>
                                <simple-property-list name="aggregateOn">
                                    <value>categoryGroup/category_index</value>
                                </simple-property-list>
                                <property name="aggregateFunction">SUM</property>
                            </structure>
                            <structure>
                                <property name="name">rate_categoryGroup/category_index</property>
                                <expression name="expression">measure["rate"]</expression>
                                <property name="dataType">float</property>
                                <simple-property-list name="aggregateOn">
                                    <value>categoryGroup/category_index</value>
                                </simple-property-list>
                                <property name="aggregateFunction">SUM</property>
                            </structure>
                            <structure>
                                <property name="name">category</property>
                                <expression name="expression" type="javascript">dimension["categoryGroup"]["category_index"]["category"]</expression>
                                <property name="dataType">string</property>
                            </structure>
                            <structure>
                                <property name="name">optimizationGroupId</property>
                                <expression name="expression">dimension["optimizationGroup"]["optimizationGroupId"]</expression>
                                <property name="dataType">integer</property>
                            </structure>
                            <structure>
                                <property name="name">groupTitle</property>
                                <expression name="expression" type="javascript">getMailingGroupNameTitle(data["optimizationGroupId"], dimension["optimizationGroup"]["optimizationGroupId"]["baseGroupId"])</expression>
                                <property name="dataType">string</property>
                            </structure>
                            <structure>
                                <property name="name">value_categoryGroup/category_index_optimizationGroup/optimizationGroupId</property>
                                <property name="dataType">float</property>
                                <simple-property-list name="aggregateOn">
                                    <value>categoryGroup/category_index</value>
                                    <value>optimizationGroup/optimizationGroupId</value>
                                </simple-property-list>
                                <property name="aggregateFunction">SUM</property>
                                <list-property name="arguments">
                                    <structure>
                                        <property name="name">Expression</property>
                                        <expression name="value" type="javascript">measure["value"]</expression>
                                    </structure>
                                </list-property>
                            </structure>
                            <structure>
                                <property name="name">rate_categoryGroup/category_index_optimizationGroup/optimizationGroupId</property>
                                <property name="dataType">float</property>
                                <simple-property-list name="aggregateOn">
                                    <value>categoryGroup/category_index</value>
                                    <value>optimizationGroup/optimizationGroupId</value>
                                </simple-property-list>
                                <property name="aggregateFunction">SUM</property>
                                <list-property name="arguments">
                                    <structure>
                                        <property name="name">Expression</property>
                                        <expression name="value" type="javascript">measure["rate"]</expression>
                                    </structure>
                                </list-property>
                                <expression name="filterExpr" type="javascript">dimension["categoryGroup"]["category_index"] &lt; CommonKeys.REVENUE_INDEX &amp;&amp;
hasPercentageRepresentation(dimension["categoryGroup"]["category_index"]["categoryKey"])</expression>
                            </structure>
                            <structure>
                                <property name="name">categoryKey</property>
                                <expression name="expression" type="javascript">dimension["categoryGroup"]["category_index"]["categoryKey"]</expression>
                                <property name="dataType">string</property>
                            </structure>
                            <structure>
                                <property name="name">value</property>
                                <expression name="expression" type="javascript">measure["value"]</expression>
                                <property name="dataType">integer</property>
                            </structure>
                            <structure>
                                <property name="name">revenue</property>
                                <expression name="expression" type="javascript">data["value_categoryGroup/category_index_optimizationGroup/optimizationGroupId"]/100</expression>
                                <property name="dataType">integer</property>
                            </structure>
                        </list-property>
                        <property name="style">table table-striped</property>
                    </extended-item>
                    <extended-item extensionName="Crosstab" extensionVersion="3.7.0" name="summaryTableDelivered"
 id="1439">
                        <property name="cube">SummaryOptimizationDataCube</property>
                        <property name="measures">
                            <extended-item extensionName="MeasureView" id="1440">
                                <property name="measure">value</property>
                                <property name="detail">
                                    <extended-item extensionName="AggregationCell" id="1441">
                                        <property name="aggregationOnRow">categoryGroup/category_index</property>
                                        <property name="aggregationOnColumn">optimizationGroup/optimizationGroupId</property>
                                        <property name="content">
                                            <text-data id="1442">
                                                <list-property name="visibility">
                                                    <structure>
                                                        <property name="format">all</property>
                                                        <expression name="valueExpr" type="javascript">data["value_categoryGroup/category_index_optimizationGroup/optimizationGroupId"] >= 0 &amp;&amp;
data["value_categoryGroup/category_index_optimizationGroup/optimizationGroupId"] != null</expression>
                                                    </structure>
                                                </list-property>
                                                <expression name="valueExpr">tr("NotAvailableShort")</expression>
                                            </text-data>
                                            <data id="1443">
                                                <structure name="numberFormat">
                                                    <property name="category">Currency</property>
                                                    <property name="pattern">#,##0.00{RoundingMode=HALF_UP}</property>
                                                </structure>
                                                <list-property name="visibility">
                                                    <structure>
                                                        <property name="format">all</property>
                                                        <expression name="valueExpr" type="javascript">data["value_categoryGroup/category_index_optimizationGroup/optimizationGroupId"] &lt; 0 ||
data["value_categoryGroup/category_index_optimizationGroup/optimizationGroupId"] == null ||
data["category_index"] != CommonKeys.REVENUE_INDEX</expression>
                                                    </structure>
                                                </list-property>
                                                <property name="resultSetColumn">revenue</property>
                                            </data>
                                            <data id="1444">
                                                <structure name="numberFormat">
                                                    <property name="category">Currency</property>
                                                    <property name="pattern">#,##0{RoundingMode=HALF_UP}</property>
                                                </structure>
                                                <list-property name="visibility">
                                                    <structure>
                                                        <property name="format">all</property>
                                                        <expression name="valueExpr" type="javascript">data["value_categoryGroup/category_index_optimizationGroup/optimizationGroupId"] &lt; 0 ||
data["value_categoryGroup/category_index_optimizationGroup/optimizationGroupId"] == null ||
data["category_index"] == CommonKeys.REVENUE_INDEX</expression>
                                                    </structure>
                                                </list-property>
                                                <property name="resultSetColumn">value_categoryGroup/category_index_optimizationGroup/optimizationGroupId</property>
                                            </data>
                                        </property>
                                        <property name="style">crosstab-value</property>
                                    </extended-item>
                                </property>
                                <property name="header">
                                    <extended-item extensionName="CrosstabCell" id="1445">
                                        <property name="style">to-hide</property>
                                    </extended-item>
                                </property>
                            </extended-item>
                            <extended-item extensionName="MeasureView" id="1446">
                                <property name="measure">rate</property>
                                <property name="detail">
                                    <extended-item extensionName="AggregationCell" id="1447">
                                        <property name="aggregationOnRow">categoryGroup/category_index</property>
                                        <property name="aggregationOnColumn">optimizationGroup/optimizationGroupId</property>
                                        <property name="content">
                                            <text-data id="1448">
                                                <list-property name="visibility">
                                                    <structure>
                                                        <property name="format">all</property>
                                                        <expression name="valueExpr" type="javascript">data["value_categoryGroup/category_index_optimizationGroup/optimizationGroupId"] >= 0 &amp;&amp;
data["value_categoryGroup/category_index_optimizationGroup/optimizationGroupId"] != null</expression>
                                                    </structure>
                                                </list-property>
                                                <expression name="valueExpr">tr("NotAvailableShort")</expression>
                                            </text-data>
                                            <data id="1469">
                                                <structure name="numberFormat">
                                                    <property name="category">Custom</property>
                                                    <property name="pattern">(0.0%)</property>
                                                </structure>
                                                <list-property name="visibility">
                                                    <structure>
                                                        <property name="format">all</property>
                                                        <expression name="valueExpr" type="javascript">data["value_categoryGroup/category_index_optimizationGroup/optimizationGroupId"] &lt; 0 ||
data["value_categoryGroup/category_index_optimizationGroup/optimizationGroupId"] == null</expression>
                                                    </structure>
                                                </list-property>
                                                <property name="resultSetColumn">delivered_Binding</property>
                                            </data>
                                        </property>
                                        <property name="style">crosstab-value</property>
                                    </extended-item>
                                </property>
                                <property name="header">
                                    <extended-item extensionName="CrosstabCell" id="1450">
                                        <property name="style">to-hide</property>
                                    </extended-item>
                                </property>
                            </extended-item>
                        </property>
                        <property name="rows">
                            <extended-item extensionName="CrosstabView" id="1451">
                                <property name="views">
                                    <extended-item extensionName="DimensionView" id="1452">
                                        <property name="dimension">categoryGroup</property>
                                        <property name="levels">
                                            <extended-item extensionName="LevelView" name="NewLevel View2" id="1453">
                                                <property name="level">categoryGroup/category_index</property>
                                                <property name="sort">
                                                    <sort-element>
                                                        <expression name="key" type="javascript">getKeyFiguresRowPosition(dimension["categoryGroup"]["category_index"]["categoryKey"], dimension["categoryGroup"]["category_index"])</expression>
                                                        <property name="direction">asc</property>
                                                    </sort-element>
                                                </property>
                                                <property name="member">
                                                    <extended-item extensionName="CrosstabCell" id="1454">
                                                        <property name="content">
                                                            <data name="category_index1" id="1455">
                                                                <property name="resultSetColumn">category</property>
                                                            </data>
                                                        </property>
                                                        <property name="textAlign">left</property>
                                                    </extended-item>
                                                </property>
                                            </extended-item>
                                        </property>
                                    </extended-item>
                                </property>
                            </extended-item>
                        </property>
                        <property name="columns">
                            <extended-item extensionName="CrosstabView" id="1456">
                                <property name="views">
                                    <extended-item extensionName="DimensionView" id="1457">
                                        <property name="dimension">optimizationGroup</property>
                                        <property name="levels">
                                            <extended-item extensionName="LevelView" name="NewLevel View11" id="1458">
                                                <property name="level">optimizationGroup/optimizationGroupId</property>
                                                <property name="sort">
                                                    <sort-element>
                                                        <expression name="key" type="javascript">getCrossTableColumnPosition(dimension["optimizationGroup"]["optimizationGroupId"])</expression>
                                                        <property name="direction">asc</property>
                                                        <property name="strength">-1</property>
                                                    </sort-element>
                                                </property>
                                                <property name="member">
                                                    <extended-item extensionName="CrosstabCell" id="1459">
                                                        <property name="content">
                                                            <data name="optimizationGroup1" id="1460">
                                                                <property name="display">inline</property>
                                                                <property name="resultSetColumn">groupTitle</property>
                                                            </data>
                                                            <image id="1876">
                                                                <property name="display">inline</property>
                                                                <property name="height">16px</property>
                                                                <property name="width">16px</property>
                                                                <list-property name="visibility">
                                                                    <structure>
                                                                        <property name="format">all</property>
                                                                        <expression name="valueExpr" type="javascript">!isWinnerMailing(data["optimizationGroupId"])</expression>
                                                                    </structure>
                                                                </list-property>
                                                                <property name="source">embed</property>
                                                                <property name="imageName">ok_icon.png</property>
                                                            </image>
                                                        </property>
                                                        <property name="style">table-head crosstab-header</property>
                                                    </extended-item>
                                                </property>
                                            </extended-item>
                                        </property>
                                    </extended-item>
                                </property>
                            </extended-item>
                        </property>
                        <property name="header">
                            <extended-item extensionName="CrosstabCell" id="1461">
                                <property name="content">
                                    <text-data id="1462">
                                        <expression name="valueExpr">tr("KeydataGeneral")</expression>
                                        <property name="contentType">html</property>
                                    </text-data>
                                </property>
                                <property name="style">table-head</property>
                            </extended-item>
                        </property>
                        <property name="filter">
                            <filter-condition-element>
                                <expression name="expr" type="javascript">data["category_index"] &lt;= CommonKeys.REVENUE_INDEX ||
data["category_index"] == CommonKeys.OPENINGS_ANONYMOUS_INDEX ||
data["category_index"] == CommonKeys.CLICKS_ANONYMOUS_INDEX</expression>
                                <property name="operator">is-true</property>
                            </filter-condition-element>
                        </property>
                        <list-property name="visibility">
                            <structure>
                                <property name="format">all</property>
                                <expression name="valueExpr" type="javascript">reportContext.getPersistentGlobalVariable("showNet") == false</expression>
                            </structure>
                        </list-property>
                        <list-property name="boundDataColumns">
                            <structure>
                                <property name="name">category_index</property>
                                <expression name="expression">dimension["categoryGroup"]["category_index"]</expression>
                                <property name="dataType">integer</property>
                            </structure>
                            <structure>
                                <property name="name">optimizationGroup</property>
                                <expression name="expression" type="javascript">dimension["optimizationGroup"]["optimizationGroupId"]</expression>
                                <property name="dataType">integer</property>
                            </structure>
                            <structure>
                                <property name="name">value_categoryGroup/category_index</property>
                                <expression name="expression">measure["value"]</expression>
                                <property name="dataType">integer</property>
                                <simple-property-list name="aggregateOn">
                                    <value>categoryGroup/category_index</value>
                                </simple-property-list>
                                <property name="aggregateFunction">SUM</property>
                            </structure>
                            <structure>
                                <property name="name">rate_categoryGroup/category_index</property>
                                <expression name="expression">measure["rate"]</expression>
                                <property name="dataType">float</property>
                                <simple-property-list name="aggregateOn">
                                    <value>categoryGroup/category_index</value>
                                </simple-property-list>
                                <property name="aggregateFunction">SUM</property>
                            </structure>
                            <structure>
                                <property name="name">category</property>
                                <expression name="expression" type="javascript">dimension["categoryGroup"]["category_index"]["category"]</expression>
                                <property name="dataType">string</property>
                            </structure>
                            <structure>
                                <property name="name">optimizationGroupId</property>
                                <expression name="expression">dimension["optimizationGroup"]["optimizationGroupId"]</expression>
                                <property name="dataType">integer</property>
                            </structure>
                            <structure>
                                <property name="name">groupTitle</property>
                                <expression name="expression" type="javascript">getMailingGroupNameTitle(data["optimizationGroupId"], dimension["optimizationGroup"]["optimizationGroupId"]["baseGroupId"])</expression>
                                <property name="dataType">string</property>
                            </structure>
                            <structure>
                                <property name="name">value_categoryGroup/category_index_optimizationGroup/optimizationGroupId</property>
                                <property name="dataType">float</property>
                                <simple-property-list name="aggregateOn">
                                    <value>categoryGroup/category_index</value>
                                    <value>optimizationGroup/optimizationGroupId</value>
                                </simple-property-list>
                                <property name="aggregateFunction">SUM</property>
                                <list-property name="arguments">
                                    <structure>
                                        <property name="name">Expression</property>
                                        <expression name="value" type="javascript">measure["value"]</expression>
                                    </structure>
                                </list-property>
                            </structure>
                            <structure>
                                <property name="name">rate_categoryGroup/category_index_optimizationGroup/optimizationGroupId</property>
                                <property name="dataType">float</property>
                                <simple-property-list name="aggregateOn">
                                    <value>categoryGroup/category_index</value>
                                    <value>optimizationGroup/optimizationGroupId</value>
                                </simple-property-list>
                                <property name="aggregateFunction">SUM</property>
                                <list-property name="arguments">
                                    <structure>
                                        <property name="name">Expression</property>
                                        <expression name="value" type="javascript">measure["rate"]</expression>
                                    </structure>
                                </list-property>
                                <expression name="filterExpr" type="javascript">dimension["CategoryGroup"]["category_index"] &lt; CommonKeys.REVENUE_INDEX &amp;&amp;
hasPercentageRepresentation(dimension["CategoryGroup"]["category_index"]["categoryKey"])</expression>
                            </structure>
                            <structure>
                                <property name="name">categoryKey</property>
                                <expression name="expression" type="javascript">dimension["categoryGroup"]["category_index"]["categoryKey"]</expression>
                                <property name="dataType">string</property>
                            </structure>
                            <structure>
                                <property name="name">value</property>
                                <expression name="expression" type="javascript">measure["value"]</expression>
                                <property name="dataType">integer</property>
                            </structure>
                            <structure>
                                <property name="name">revenue</property>
                                <expression name="expression" type="javascript">data["value_categoryGroup/category_index_optimizationGroup/optimizationGroupId"]/100</expression>
                                <property name="dataType">integer</property>
                            </structure>
                            <structure>
                                <property name="name">deliveredRate</property>
                                <expression name="expression" type="javascript">data["rate_categoryGroup/category_index_optimizationGroup/optimizationGroupId"]</expression>
                                <property name="dataType">float</property>
                            </structure>
                            <structure>
                                <property name="name">delivered_Binding</property>
                                <property name="dataType">float</property>
                                <simple-property-list name="aggregateOn">
                                    <value>categoryGroup/category_index</value>
                                    <value>optimizationGroup/optimizationGroupId</value>
                                </simple-property-list>
                                <property name="aggregateFunction">SUM</property>
                                <list-property name="arguments">
                                    <structure>
                                        <property name="name">Expression</property>
                                        <expression name="value" type="javascript">measure["deliveredRate"]</expression>
                                    </structure>
                                </list-property>
                                <expression name="filterExpr" type="javascript">dimension["categoryGroup"]["category_index"] &lt; CommonKeys.REVENUE_INDEX &amp;&amp;
hasPercentageRepresentation(dimension["categoryGroup"]["category_index"]["categoryKey"])</expression>
                            </structure>
                        </list-property>
                        <property name="style">table table-striped</property>
                    </extended-item>
                </cell>
            </row>
            <row id="1470">
                <cell id="1471">
                    <property name="colSpan">2</property>
                    <property name="rowSpan">1</property>
                    <property name="style">full-width</property>
                </cell>
            </row>
            <row id="1473">
                <cell id="1474">
                    <property name="style">half-width</property>
                    <grid id="977">
                        <property name="style">table</property>
                        <column id="978"/>
                        <row id="987">
                            <cell id="988">
                                <property name="style">report-title</property>
                                <text-data id="991">
                                    <expression name="valueExpr">tr("report.mailing.openersByDevices") + " - " + getMailingGroupName(CommonKeys.OPTIMIZATION_WINNER_GROUP_ID)</expression>
                                </text-data>
                            </cell>
                        </row>
                        <row id="979">
                            <cell id="980">
                                <property name="textAlign">center</property>
                                <extended-item extensionName="Chart" name="OpeningsChart" id="823">
                                    <xml-property name="xmlRepresentation"><![CDATA[<model:ChartWithoutAxes xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:attribute="http://www.birt.eclipse.org/ChartModelAttribute" xmlns:layout="http://www.birt.eclipse.org/ChartModelLayout" xmlns:model="http://www.birt.eclipse.org/ChartModel" xmlns:type="http://www.birt.eclipse.org/ChartModelType">
  <Version>2.6.1</Version>
  <Type>Pie Chart</Type>
  <SubType>Standard</SubType>
  <Description>
    <Value></Value>
    <Font>
      <Alignment/>
    </Font>
  </Description>
  <Block>
    <Children xsi:type="layout:TitleBlock">
      <Bounds>
        <Left>0.0</Left>
        <Top>0.0</Top>
        <Width>0.0</Width>
        <Height>0.0</Height>
      </Bounds>
      <Anchor>South</Anchor>
      <Insets>
        <Top>0.0</Top>
        <Left>0.0</Left>
        <Bottom>0.0</Bottom>
        <Right>0.0</Right>
      </Insets>
      <Row>-1</Row>
      <Column>-1</Column>
      <Rowspan>-1</Rowspan>
      <Columnspan>-1</Columnspan>
      <Outline>
        <Style>Solid</Style>
        <Thickness>1</Thickness>
        <Color>
          <Transparency>255</Transparency>
          <Red>0</Red>
          <Green>0</Green>
          <Blue>0</Blue>
        </Color>
        <Visible>false</Visible>
      </Outline>
      <Visible>false</Visible>
      <Label>
        <Caption>
          <Value>report.opens=Pie Chart Title</Value>
          <Font>
            <Size>16.0</Size>
            <Bold>true</Bold>
            <Alignment>
              <horizontalAlignment>Center</horizontalAlignment>
              <verticalAlignment>Top</verticalAlignment>
            </Alignment>
          </Font>
        </Caption>
        <Background xsi:type="attribute:ColorDefinition">
          <Transparency>0</Transparency>
          <Red>255</Red>
          <Green>255</Green>
          <Blue>255</Blue>
        </Background>
        <Outline>
          <Style>Solid</Style>
          <Thickness>1</Thickness>
          <Color>
            <Transparency>255</Transparency>
            <Red>0</Red>
            <Green>0</Green>
            <Blue>0</Blue>
          </Color>
        </Outline>
        <Insets>
          <Top>0.0</Top>
          <Left>0.0</Left>
          <Bottom>0.0</Bottom>
          <Right>0.0</Right>
        </Insets>
        <Visible>true</Visible>
      </Label>
    </Children>
    <Children xsi:type="layout:Plot">
      <Bounds>
        <Left>0.0</Left>
        <Top>0.0</Top>
        <Width>0.0</Width>
        <Height>0.0</Height>
      </Bounds>
      <Insets>
        <Top>3.0</Top>
        <Left>3.0</Left>
        <Bottom>3.0</Bottom>
        <Right>3.0</Right>
      </Insets>
      <Row>-1</Row>
      <Column>-1</Column>
      <Rowspan>-1</Rowspan>
      <Columnspan>-1</Columnspan>
      <Outline>
        <Style>Solid</Style>
        <Thickness>1</Thickness>
        <Color>
          <Transparency>255</Transparency>
          <Red>0</Red>
          <Green>0</Green>
          <Blue>0</Blue>
        </Color>
        <Visible>false</Visible>
      </Outline>
      <Visible>true</Visible>
      <HorizontalSpacing>5</HorizontalSpacing>
      <VerticalSpacing>5</VerticalSpacing>
      <ClientArea>
        <Outline>
          <Style>Solid</Style>
          <Thickness>0</Thickness>
          <Color>
            <Transparency>255</Transparency>
            <Red>0</Red>
            <Green>0</Green>
            <Blue>0</Blue>
          </Color>
          <Visible>false</Visible>
        </Outline>
        <Insets>
          <Top>0.0</Top>
          <Left>0.0</Left>
          <Bottom>0.0</Bottom>
          <Right>0.0</Right>
        </Insets>
      </ClientArea>
    </Children>
    <Children xsi:type="layout:Legend">
      <Bounds>
        <Left>0.0</Left>
        <Top>0.0</Top>
        <Width>0.0</Width>
        <Height>0.0</Height>
      </Bounds>
      <Insets>
        <Top>3.0</Top>
        <Left>3.0</Left>
        <Bottom>3.0</Bottom>
        <Right>3.0</Right>
      </Insets>
      <Row>-1</Row>
      <Column>-1</Column>
      <Rowspan>-1</Rowspan>
      <Columnspan>-1</Columnspan>
      <Outline>
        <Style>Solid</Style>
        <Thickness>1</Thickness>
        <Color>
          <Transparency>255</Transparency>
          <Red>0</Red>
          <Green>0</Green>
          <Blue>0</Blue>
        </Color>
        <Visible>false</Visible>
      </Outline>
      <Visible>false</Visible>
      <ClientArea>
        <Outline>
          <Style>Solid</Style>
          <Thickness>0</Thickness>
          <Color>
            <Transparency>255</Transparency>
            <Red>0</Red>
            <Green>0</Green>
            <Blue>0</Blue>
          </Color>
          <Visible>false</Visible>
        </Outline>
        <Insets>
          <Top>2.0</Top>
          <Left>2.0</Left>
          <Bottom>2.0</Bottom>
          <Right>2.0</Right>
        </Insets>
      </ClientArea>
      <Text>
        <Value></Value>
        <Font>
          <Alignment/>
        </Font>
      </Text>
      <Orientation>Vertical</Orientation>
      <Direction>Top_Bottom</Direction>
      <Separator>
        <Style>Solid</Style>
        <Thickness>1</Thickness>
        <Color>
          <Transparency>255</Transparency>
          <Red>0</Red>
          <Green>0</Green>
          <Blue>0</Blue>
        </Color>
        <Visible>true</Visible>
      </Separator>
      <Position>Right</Position>
      <ItemType>Categories</ItemType>
      <Title>
        <Caption>
          <Value></Value>
          <Font>
            <Alignment/>
          </Font>
        </Caption>
        <Background xsi:type="attribute:ColorDefinition">
          <Transparency>0</Transparency>
          <Red>255</Red>
          <Green>255</Green>
          <Blue>255</Blue>
        </Background>
        <Outline>
          <Style>Solid</Style>
          <Thickness>1</Thickness>
          <Color>
            <Transparency>255</Transparency>
            <Red>0</Red>
            <Green>0</Green>
            <Blue>0</Blue>
          </Color>
          <Visible>false</Visible>
        </Outline>
        <Insets>
          <Top>0.0</Top>
          <Left>2.0</Left>
          <Bottom>0.0</Bottom>
          <Right>3.0</Right>
        </Insets>
        <Visible>false</Visible>
      </Title>
      <TitlePosition>Above</TitlePosition>
    </Children>
    <Bounds>
      <Left>0.0</Left>
      <Top>0.0</Top>
      <Width>315.0</Width>
      <Height>150.0</Height>
    </Bounds>
    <Insets>
      <Top>3.0</Top>
      <Left>3.0</Left>
      <Bottom>3.0</Bottom>
      <Right>3.0</Right>
    </Insets>
    <Row>-1</Row>
    <Column>-1</Column>
    <Rowspan>-1</Rowspan>
    <Columnspan>-1</Columnspan>
    <Outline>
      <Style>Solid</Style>
      <Thickness>1</Thickness>
      <Color>
        <Transparency>255</Transparency>
        <Red>0</Red>
        <Green>0</Green>
        <Blue>0</Blue>
      </Color>
      <Visible>false</Visible>
    </Outline>
    <Background xsi:type="attribute:ColorDefinition">
      <Transparency>0</Transparency>
      <Red>255</Red>
      <Green>255</Green>
      <Blue>255</Blue>
    </Background>
    <Visible>true</Visible>
  </Block>
  <Dimension>Two_Dimensional</Dimension>
  <Script>importPackage(Packages.org.eclipse.birt.chart.model.attribute.impl);
importPackage(Packages.org.eclipse.birt.chart.model.attribute);
importPackage(Packages.org.eclipse.birt.report.model.api.util);
importPackage(Packages.java.util);
importPackage(Packages.org.eclipse.birt.chart.model.data.impl);
importPackage(Packages.java.lang);
importPackage(Packages.java.text);

/**
 * Called before rendering Series.
 * 
 * @param series
 *            Series
 * @param isr
 *            ISeriesRenderer
 * @param icsc
 *            IChartScriptContext
 */
function beforeGeneration( chart, icsc )
{
	reportContext = icsc.getExternalContext().getObject();
	
	sd = chart.getSeriesDefinitions( ).get( 0 );
	sd.getSeriesPalette( ).getEntries( ).clear( );
	
	sd.getSeriesPalette().getEntries().add(getColorDefinition(&quot;color-blue&quot;));		
	sd.getSeriesPalette().getEntries().add(getColorDefinition(&quot;color-petrol&quot;));
	sd.getSeriesPalette().getEntries().add(getColorDefinition(&quot;color-light-green&quot;));
	sd.getSeriesPalette().getEntries().add(getColorDefinition(&quot;color-dark-green&quot;));			
	sd.getSeriesPalette().getEntries().add(getColorDefinition(&quot;color-orange&quot;));			
}

function getColorDefinition( styleName ) {
	var color = ColorUtil.format(this.getDesignHandle().findStyle(styleName).getColor().getRGB(),ColorUtil.HTML_FORMAT);
	var red = &quot;0x&quot;+color.substr(1,2);
	var green = &quot;0x&quot;+color.substr(3,2);
	var blue = &quot;0x&quot;+color.substr(5,2);
	return ColorDefinitionImpl.create(red,green,blue);
}

/**
 * Called before rendering the label for each datapoint.
 * 
 * @param dph
 *            DataPointHints
 * @param label
 *            Label
 * @param icsc
 *            IChartScriptContext
 */
function beforeDrawDataPointLabel( dph, label, icsc )
{
	importPackage(Packages.com.agnitas.reporting.birt.external.dataset);
	
	var reportContext = icsc.getExternalContext().getObject();
	
	var labelText = label.getCaption().getValue();
	var cIndex = labelText.subSequence(labelText.lastIndexOf(&quot;%&quot;) + 2, labelText.lastIndexOf(&quot;%&quot;) + 4);
	var messageKey = &quot;&quot;;
	if(cIndex == CommonKeys.OPENERS_PC_INDEX){
		messageKey = &quot;statistic.pc&quot;;
	} else if(cIndex == CommonKeys.OPENERS_MOBILE_INDEX){
		messageKey = &quot;report.opens.mobile.chartLabel&quot;;
	} else if(cIndex == CommonKeys.OPENERS_TABLET_INDEX){
		messageKey = &quot;report.opens.tablet.chartLabel&quot;;
	} else if(cIndex == CommonKeys.OPENERS_SMARTTV_INDEX){
		messageKey = &quot;statistic.smarttv&quot;;
	} else if (cIndex == CommonKeys.OPENERS_PC_AND_MOBILE_INDEX) {
		messageKey = &quot;report.opens.pc.and.mobile.chartLabel&quot;;
	}
	
	var tr = icsc.getExternalContext().getScriptable().getGlobalVariable(&quot;tr&quot;);	
	var message = tr(messageKey);
	
	labelText = labelText.subSequence(0, labelText.lastIndexOf(&quot;%&quot;) + 1) + &quot; &quot; + message;
	//labelText = labelText.subSequence(0, labelText.lastIndexOf(&quot;%&quot;) + 1) + &quot;\n&quot; + message;
	label.getCaption().setValue(labelText);
	
	preparePointLabelColor(label, icsc);
}

function beforeDrawMarkerLine(axis, line, icsc) {
	var reportContext = icsc.getExternalContext().getObject();
	if(reportContext.getGlobalVariable(&quot;isDarkmode&quot;) == true){
		line.getLabel().getCaption().getColor().set(255, 255, 255);
	}
};

function preparePointLabelColor(label, icsc) {
	var reportContext = icsc.getExternalContext().getObject();
	if(reportContext.getGlobalVariable(&quot;isDarkmode&quot;) == true){
		label.getCaption().getColor().set(255, 255, 255);
	}
};
</Script>
  <Units>Points</Units>
  <SeriesThickness>20.0</SeriesThickness>
  <GridColumnCount>0</GridColumnCount>
  <ExtendedProperties>
    <Name>enable.area.alt</Name>
    <Value>false</Value>
  </ExtendedProperties>
  <SampleData>
    <BaseSampleData>
      <DataSetRepresentation>'A','B','C','D','E'</DataSetRepresentation>
    </BaseSampleData>
    <OrthogonalSampleData>
      <DataSetRepresentation>6,4,12,8,10</DataSetRepresentation>
      <SeriesDefinitionIndex>0</SeriesDefinitionIndex>
    </OrthogonalSampleData>
  </SampleData>
  <Interactivity>
    <Enable>true</Enable>
    <LegendBehavior>None</LegendBehavior>
  </Interactivity>
  <EmptyMessage>
    <Caption>
      <Value>No data available.</Value>
      <Font>
        <Alignment>
          <horizontalAlignment>Center</horizontalAlignment>
          <verticalAlignment>Center</verticalAlignment>
        </Alignment>
      </Font>
    </Caption>
    <Background xsi:type="attribute:ColorDefinition">
      <Transparency>64</Transparency>
      <Red>127</Red>
      <Green>127</Green>
      <Blue>127</Blue>
    </Background>
    <Outline>
      <Color>
        <Transparency>128</Transparency>
        <Red>127</Red>
        <Green>127</Green>
        <Blue>127</Blue>
      </Color>
      <Visible>true</Visible>
    </Outline>
    <Insets>
      <Top>10.0</Top>
      <Left>10.0</Left>
      <Bottom>10.0</Bottom>
      <Right>10.0</Right>
    </Insets>
    <Visible>true</Visible>
  </EmptyMessage>
  <SeriesDefinitions>
    <Query>
      <Definition></Definition>
    </Query>
    <SeriesPalette>
      <Entries xsi:type="attribute:ColorDefinition">
        <Transparency>255</Transparency>
        <Red>255</Red>
        <Green>204</Green>
        <Blue>153</Blue>
      </Entries>
      <Entries xsi:type="attribute:ColorDefinition">
        <Transparency>255</Transparency>
        <Red>255</Red>
        <Green>255</Green>
        <Blue>153</Blue>
      </Entries>
      <Entries xsi:type="attribute:ColorDefinition">
        <Transparency>255</Transparency>
        <Red>255</Red>
        <Green>204</Green>
        <Blue>0</Blue>
      </Entries>
      <Entries xsi:type="attribute:ColorDefinition">
        <Transparency>255</Transparency>
        <Red>204</Red>
        <Green>255</Green>
        <Blue>204</Blue>
      </Entries>
      <Entries xsi:type="attribute:ColorDefinition">
        <Transparency>255</Transparency>
        <Red>154</Red>
        <Green>204</Green>
        <Blue>0</Blue>
      </Entries>
    </SeriesPalette>
    <SeriesDefinitions>
      <Query>
        <Definition></Definition>
        <Grouping>
          <GroupType>Numeric</GroupType>
        </Grouping>
      </Query>
      <SeriesPalette>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>255</Red>
          <Green>204</Green>
          <Blue>153</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>255</Red>
          <Green>255</Green>
          <Blue>153</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>255</Red>
          <Green>204</Green>
          <Blue>0</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>204</Red>
          <Green>255</Green>
          <Blue>204</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>154</Red>
          <Green>204</Green>
          <Blue>0</Blue>
        </Entries>
      </SeriesPalette>
      <Series xsi:type="type:PieSeries">
        <Visible>true</Visible>
        <Label>
          <Caption>
            <Value></Value>
            <Font>
              <Name>Arial</Name>
              <Size>10.0</Size>
              <Bold>false</Bold>
              <Alignment/>
              <Rotation>0.0</Rotation>
            </Font>
          </Caption>
          <Background xsi:type="attribute:ColorDefinition">
            <Transparency>0</Transparency>
            <Red>255</Red>
            <Green>255</Green>
            <Blue>255</Blue>
          </Background>
          <Outline>
            <Style>Solid</Style>
            <Thickness>1</Thickness>
            <Color>
              <Transparency>255</Transparency>
              <Red>0</Red>
              <Green>0</Green>
              <Blue>0</Blue>
            </Color>
            <Visible>false</Visible>
          </Outline>
          <Insets>
            <Top>5.0</Top>
            <Left>5.0</Left>
            <Bottom>5.0</Bottom>
            <Right>5.0</Right>
          </Insets>
          <Visible>true</Visible>
        </Label>
        <DataDefinition>
          <Definition>row[&quot;rate&quot;]</Definition>
          <Grouping>
            <Enabled>false</Enabled>
            <GroupType>Text</GroupType>
            <AggregateExpression xsi:nil="true"/>
          </Grouping>
        </DataDefinition>
        <SeriesIdentifier>Series 1</SeriesIdentifier>
        <DataPoint>
          <Components>
            <Type>Orthogonal_Value</Type>
            <FormatSpecifier xsi:type="attribute:JavaNumberFormatSpecifier">
              <Pattern>##.#%</Pattern>
            </FormatSpecifier>
          </Components>
          <Components>
            <Type>Base_Value</Type>
          </Components>
          <Prefix></Prefix>
          <Suffix></Suffix>
          <Separator> </Separator>
        </DataPoint>
        <LabelPosition>Outside</LabelPosition>
        <Stacked>false</Stacked>
        <Triggers>
          <Condition>onmouseover</Condition>
          <Action>
            <Type>Highlight</Type>
            <Value xsi:type="attribute:SeriesValue">
              <Name></Name>
            </Value>
          </Action>
        </Triggers>
        <Cursor>
          <Type>Auto</Type>
        </Cursor>
        <Explosion>0</Explosion>
        <ExplosionExpression></ExplosionExpression>
        <Title>
          <Caption>
            <Value></Value>
            <Font>
              <Size>16.0</Size>
              <Bold>true</Bold>
              <Alignment/>
            </Font>
          </Caption>
          <Background xsi:type="attribute:ColorDefinition">
            <Transparency>0</Transparency>
            <Red>255</Red>
            <Green>255</Green>
            <Blue>255</Blue>
          </Background>
          <Outline>
            <Style>Solid</Style>
            <Thickness>1</Thickness>
            <Color>
              <Transparency>255</Transparency>
              <Red>0</Red>
              <Green>0</Green>
              <Blue>0</Blue>
            </Color>
          </Outline>
          <Insets>
            <Top>0.0</Top>
            <Left>2.0</Left>
            <Bottom>0.0</Bottom>
            <Right>3.0</Right>
          </Insets>
          <Visible>false</Visible>
        </Title>
        <TitlePosition>Below</TitlePosition>
        <LeaderLineAttributes>
          <Style>Solid</Style>
          <Thickness>1</Thickness>
          <Color>
            <Transparency>255</Transparency>
            <Red>128</Red>
            <Green>128</Green>
            <Blue>128</Blue>
          </Color>
          <Visible>true</Visible>
        </LeaderLineAttributes>
        <LeaderLineStyle>Fixed_Length</LeaderLineStyle>
        <LeaderLineLength>0.0</LeaderLineLength>
        <SliceOutline>
          <Transparency>0</Transparency>
          <Red>255</Red>
          <Green>255</Green>
          <Blue>255</Blue>
        </SliceOutline>
        <Ratio>1.0</Ratio>
        <Rotation>0.0</Rotation>
        <Clockwise>false</Clockwise>
        <InnerRadius>60.0</InnerRadius>
      </Series>
    </SeriesDefinitions>
    <Series>
      <Visible>true</Visible>
      <Label>
        <Caption>
          <Value></Value>
          <Font>
            <Alignment/>
          </Font>
        </Caption>
        <Background xsi:type="attribute:ColorDefinition">
          <Transparency>0</Transparency>
          <Red>255</Red>
          <Green>255</Green>
          <Blue>255</Blue>
        </Background>
        <Outline>
          <Style>Solid</Style>
          <Thickness>1</Thickness>
          <Color>
            <Transparency>255</Transparency>
            <Red>0</Red>
            <Green>0</Green>
            <Blue>0</Blue>
          </Color>
          <Visible>false</Visible>
        </Outline>
        <Insets>
          <Top>0.0</Top>
          <Left>2.0</Left>
          <Bottom>0.0</Bottom>
          <Right>3.0</Right>
        </Insets>
        <Visible>false</Visible>
      </Label>
      <DataDefinition>
        <Definition>row[&quot;category_index&quot;]</Definition>
      </DataDefinition>
      <SeriesIdentifier></SeriesIdentifier>
      <DataPoint>
        <Components>
          <Type>Orthogonal_Value</Type>
        </Components>
        <Separator>, </Separator>
      </DataPoint>
      <LabelPosition>Outside</LabelPosition>
      <Stacked>false</Stacked>
    </Series>
    <Grouping>
      <Enabled>false</Enabled>
      <GroupType>Numeric</GroupType>
      <AggregateExpression>Sum</AggregateExpression>
    </Grouping>
    <Sorting>Ascending</Sorting>
    <SortKey>
      <Definition>row[&quot;category_index&quot;]</Definition>
    </SortKey>
  </SeriesDefinitions>
  <MinSlicePercent>false</MinSlicePercent>
  <Coverage>0.65</Coverage>
</model:ChartWithoutAxes>
]]></xml-property>
                                    <property name="outputFormat">SVG</property>
                                    <list-property name="filter">
                                        <structure>
                                            <property name="operator">is-true</property>
                                            <expression name="expr" type="javascript">row["category_index"] == CommonKeys.OPENERS_PC_INDEX || row["category_index"] == CommonKeys.OPENERS_TABLET_INDEX || row["category_index"] == CommonKeys.OPENERS_MOBILE_INDEX || row["category_index"] == CommonKeys.OPENERS_SMARTTV_INDEX || row["category_index"] == CommonKeys.OPENERS_PC_AND_MOBILE_INDEX</expression>
                                            <property name="updateAggregation">true</property>
                                        </structure>
                                        <structure>
                                            <property name="operator">eq</property>
                                            <expression name="expr" type="javascript">row["groupId"]</expression>
                                            <simple-property-list name="value1">
                                                <value>CommonKeys.OPTIMIZATION_WINNER_GROUP_ID</value>
                                            </simple-property-list>
                                            <property name="updateAggregation">true</property>
                                        </structure>
                                    </list-property>
                                    <property name="inheritColumns">false</property>
                                    <property name="height">320px</property>
                                    <property name="width">668px</property>
                                    <property name="dataSet">OptimizationSummaryDataSet</property>
                                    <list-property name="boundDataColumns">
                                        <structure>
                                            <property name="name">category</property>
                                            <text-property name="displayName">category</text-property>
                                            <expression name="expression" type="javascript">dataSetRow["category"]</expression>
                                            <property name="dataType">string</property>
                                        </structure>
                                        <structure>
                                            <property name="name">category_index</property>
                                            <text-property name="displayName">category_index</text-property>
                                            <expression name="expression" type="javascript">dataSetRow["category_index"]</expression>
                                            <property name="dataType">integer</property>
                                        </structure>
                                        <structure>
                                            <property name="name">value</property>
                                            <text-property name="displayName">value</text-property>
                                            <expression name="expression" type="javascript">dataSetRow["value"]</expression>
                                            <property name="dataType">integer</property>
                                        </structure>
                                        <structure>
                                            <property name="name">rate</property>
                                            <text-property name="displayName">rate</text-property>
                                            <expression name="expression" type="javascript">dataSetRow["rate"]</expression>
                                            <property name="dataType">float</property>
                                        </structure>
                                        <structure>
                                            <property name="name">deliveredRate</property>
                                            <text-property name="displayName">deliveredRate</text-property>
                                            <expression name="expression" type="javascript">dataSetRow["deliveredRate"]</expression>
                                            <property name="dataType">float</property>
                                        </structure>
                                        <structure>
                                            <property name="name">mailingId</property>
                                            <text-property name="displayName">mailingId</text-property>
                                            <expression name="expression" type="javascript">dataSetRow["mailingId"]</expression>
                                            <property name="dataType">integer</property>
                                        </structure>
                                        <structure>
                                            <property name="name">groupId</property>
                                            <text-property name="displayName">groupId</text-property>
                                            <expression name="expression" type="javascript">dataSetRow["groupId"]</expression>
                                            <property name="dataType">integer</property>
                                        </structure>
                                        <structure>
                                            <property name="name">categoryKey</property>
                                            <text-property name="displayName">categoryKey</text-property>
                                            <expression name="expression" type="javascript">dataSetRow["categoryKey"]</expression>
                                            <property name="dataType">string</property>
                                        </structure>
                                        <structure>
                                            <property name="name">isWinner</property>
                                            <text-property name="displayName">isWinner</text-property>
                                            <expression name="expression" type="javascript">dataSetRow["isWinner"]</expression>
                                            <property name="dataType">boolean</property>
                                        </structure>
                                        <structure>
                                            <property name="name">baseGroupId</property>
                                            <text-property name="displayName">baseGroupId</text-property>
                                            <expression name="expression" type="javascript">dataSetRow["baseGroupId"]</expression>
                                            <property name="dataType">integer</property>
                                        </structure>
                                    </list-property>
                                </extended-item>
                            </cell>
                        </row>
                    </grid>
                </cell>
                <cell id="1475">
                    <property name="style">half-width</property>
                    <grid id="981">
                        <property name="style">table</property>
                        <column id="982"/>
                        <row id="989">
                            <cell id="990">
                                <property name="style">report-title</property>
                                <text-data id="992">
                                    <expression name="valueExpr">tr("report.mailing.clickersByDevices")  + " - " + getMailingGroupName(CommonKeys.OPTIMIZATION_WINNER_GROUP_ID)</expression>
                                </text-data>
                            </cell>
                        </row>
                        <row id="983">
                            <cell id="984">
                                <property name="textAlign">center</property>
                                <extended-item extensionName="Chart" name="ClickingChart" id="824">
                                    <xml-property name="xmlRepresentation"><![CDATA[<model:ChartWithoutAxes xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:attribute="http://www.birt.eclipse.org/ChartModelAttribute" xmlns:layout="http://www.birt.eclipse.org/ChartModelLayout" xmlns:model="http://www.birt.eclipse.org/ChartModel" xmlns:type="http://www.birt.eclipse.org/ChartModelType">
  <Version>2.6.1</Version>
  <Type>Pie Chart</Type>
  <SubType>Standard</SubType>
  <Description>
    <Value></Value>
    <Font>
      <Alignment/>
    </Font>
  </Description>
  <Block>
    <Children xsi:type="layout:TitleBlock">
      <Bounds>
        <Left>0.0</Left>
        <Top>0.0</Top>
        <Width>0.0</Width>
        <Height>0.0</Height>
      </Bounds>
      <Anchor>South</Anchor>
      <Insets>
        <Top>0.0</Top>
        <Left>0.0</Left>
        <Bottom>0.0</Bottom>
        <Right>0.0</Right>
      </Insets>
      <Row>-1</Row>
      <Column>-1</Column>
      <Rowspan>-1</Rowspan>
      <Columnspan>-1</Columnspan>
      <Outline>
        <Style>Solid</Style>
        <Thickness>1</Thickness>
        <Color>
          <Transparency>255</Transparency>
          <Red>0</Red>
          <Green>0</Green>
          <Blue>0</Blue>
        </Color>
        <Visible>false</Visible>
      </Outline>
      <Visible>false</Visible>
      <Label>
        <Caption>
          <Value>report.clicker=Pie Chart Title</Value>
          <Font>
            <Size>16.0</Size>
            <Bold>true</Bold>
            <Alignment>
              <horizontalAlignment>Center</horizontalAlignment>
              <verticalAlignment>Top</verticalAlignment>
            </Alignment>
          </Font>
        </Caption>
        <Background xsi:type="attribute:ColorDefinition">
          <Transparency>0</Transparency>
          <Red>255</Red>
          <Green>255</Green>
          <Blue>255</Blue>
        </Background>
        <Outline>
          <Style>Solid</Style>
          <Thickness>1</Thickness>
          <Color>
            <Transparency>255</Transparency>
            <Red>0</Red>
            <Green>0</Green>
            <Blue>0</Blue>
          </Color>
        </Outline>
        <Insets>
          <Top>0.0</Top>
          <Left>0.0</Left>
          <Bottom>0.0</Bottom>
          <Right>0.0</Right>
        </Insets>
        <Visible>true</Visible>
      </Label>
    </Children>
    <Children xsi:type="layout:Plot">
      <Bounds>
        <Left>0.0</Left>
        <Top>0.0</Top>
        <Width>0.0</Width>
        <Height>0.0</Height>
      </Bounds>
      <Insets>
        <Top>3.0</Top>
        <Left>3.0</Left>
        <Bottom>3.0</Bottom>
        <Right>3.0</Right>
      </Insets>
      <Row>-1</Row>
      <Column>-1</Column>
      <Rowspan>-1</Rowspan>
      <Columnspan>-1</Columnspan>
      <Outline>
        <Style>Solid</Style>
        <Thickness>1</Thickness>
        <Color>
          <Transparency>255</Transparency>
          <Red>0</Red>
          <Green>0</Green>
          <Blue>0</Blue>
        </Color>
        <Visible>false</Visible>
      </Outline>
      <Visible>true</Visible>
      <HorizontalSpacing>5</HorizontalSpacing>
      <VerticalSpacing>5</VerticalSpacing>
      <ClientArea>
        <Outline>
          <Style>Solid</Style>
          <Thickness>0</Thickness>
          <Color>
            <Transparency>255</Transparency>
            <Red>0</Red>
            <Green>0</Green>
            <Blue>0</Blue>
          </Color>
          <Visible>false</Visible>
        </Outline>
        <Insets>
          <Top>0.0</Top>
          <Left>0.0</Left>
          <Bottom>0.0</Bottom>
          <Right>0.0</Right>
        </Insets>
      </ClientArea>
    </Children>
    <Children xsi:type="layout:Legend">
      <Bounds>
        <Left>0.0</Left>
        <Top>0.0</Top>
        <Width>0.0</Width>
        <Height>0.0</Height>
      </Bounds>
      <Insets>
        <Top>3.0</Top>
        <Left>3.0</Left>
        <Bottom>3.0</Bottom>
        <Right>3.0</Right>
      </Insets>
      <Row>-1</Row>
      <Column>-1</Column>
      <Rowspan>-1</Rowspan>
      <Columnspan>-1</Columnspan>
      <Outline>
        <Style>Solid</Style>
        <Thickness>1</Thickness>
        <Color>
          <Transparency>255</Transparency>
          <Red>0</Red>
          <Green>0</Green>
          <Blue>0</Blue>
        </Color>
        <Visible>false</Visible>
      </Outline>
      <Visible>false</Visible>
      <ClientArea>
        <Outline>
          <Style>Solid</Style>
          <Thickness>0</Thickness>
          <Color>
            <Transparency>255</Transparency>
            <Red>0</Red>
            <Green>0</Green>
            <Blue>0</Blue>
          </Color>
          <Visible>false</Visible>
        </Outline>
        <Insets>
          <Top>2.0</Top>
          <Left>2.0</Left>
          <Bottom>2.0</Bottom>
          <Right>2.0</Right>
        </Insets>
      </ClientArea>
      <Text>
        <Value></Value>
        <Font>
          <Alignment/>
        </Font>
      </Text>
      <Orientation>Vertical</Orientation>
      <Direction>Top_Bottom</Direction>
      <Separator>
        <Style>Solid</Style>
        <Thickness>1</Thickness>
        <Color>
          <Transparency>255</Transparency>
          <Red>0</Red>
          <Green>0</Green>
          <Blue>0</Blue>
        </Color>
        <Visible>true</Visible>
      </Separator>
      <Position>Right</Position>
      <ItemType>Categories</ItemType>
      <Title>
        <Caption>
          <Value></Value>
          <Font>
            <Alignment/>
          </Font>
        </Caption>
        <Background xsi:type="attribute:ColorDefinition">
          <Transparency>0</Transparency>
          <Red>255</Red>
          <Green>255</Green>
          <Blue>255</Blue>
        </Background>
        <Outline>
          <Style>Solid</Style>
          <Thickness>1</Thickness>
          <Color>
            <Transparency>255</Transparency>
            <Red>0</Red>
            <Green>0</Green>
            <Blue>0</Blue>
          </Color>
          <Visible>false</Visible>
        </Outline>
        <Insets>
          <Top>0.0</Top>
          <Left>2.0</Left>
          <Bottom>0.0</Bottom>
          <Right>3.0</Right>
        </Insets>
        <Visible>false</Visible>
      </Title>
      <TitlePosition>Above</TitlePosition>
    </Children>
    <Bounds>
      <Left>0.0</Left>
      <Top>0.0</Top>
      <Width>315.0</Width>
      <Height>150.0</Height>
    </Bounds>
    <Insets>
      <Top>3.0</Top>
      <Left>3.0</Left>
      <Bottom>3.0</Bottom>
      <Right>3.0</Right>
    </Insets>
    <Row>-1</Row>
    <Column>-1</Column>
    <Rowspan>-1</Rowspan>
    <Columnspan>-1</Columnspan>
    <Outline>
      <Style>Solid</Style>
      <Thickness>1</Thickness>
      <Color>
        <Transparency>255</Transparency>
        <Red>0</Red>
        <Green>0</Green>
        <Blue>0</Blue>
      </Color>
      <Visible>false</Visible>
    </Outline>
    <Background xsi:type="attribute:ColorDefinition">
      <Transparency>0</Transparency>
      <Red>255</Red>
      <Green>255</Green>
      <Blue>255</Blue>
    </Background>
    <Visible>true</Visible>
  </Block>
  <Dimension>Two_Dimensional</Dimension>
  <Script>importPackage( Packages.org.eclipse.birt.chart.model.attribute.impl );
importPackage( Packages.org.eclipse.birt.chart.model.attribute );
importPackage( Packages.org.eclipse.birt.report.model.api.util );
importPackage(Packages.java.util);
importPackage(Packages.org.eclipse.birt.chart.model.data.impl);
importPackage( Packages.java.lang );
importPackage( Packages.java.text);



/**
 * Called before rendering Series.
 * 
 * @param series
 *            Series
 * @param isr
 *            ISeriesRenderer
 * @param icsc
 *            IChartScriptContext
 */


function beforeGeneration( chart, icsc )
{
	reportContext = icsc.getExternalContext().getObject();
	
	sd = chart.getSeriesDefinitions( ).get( 0 );
	sd.getSeriesPalette( ).getEntries( ).clear( );	
			
	sd.getSeriesPalette().getEntries().add(getColorDefinition(&quot;color-blue&quot;));		
	sd.getSeriesPalette().getEntries().add(getColorDefinition(&quot;color-petrol&quot;));
	sd.getSeriesPalette().getEntries().add(getColorDefinition(&quot;color-light-green&quot;));
	sd.getSeriesPalette().getEntries().add(getColorDefinition(&quot;color-dark-green&quot;));			
	sd.getSeriesPalette().getEntries().add(getColorDefinition(&quot;color-orange&quot;));
}

function getColorDefinition( styleName ) {
	var color = ColorUtil.format(this.getDesignHandle().findStyle(styleName).getColor().getRGB(),ColorUtil.HTML_FORMAT);
	var red = &quot;0x&quot;+color.substr(1,2);
	var green = &quot;0x&quot;+color.substr(3,2);
	var blue = &quot;0x&quot;+color.substr(5,2);
	return ColorDefinitionImpl.create(red,green,blue);
}

/**
 * Called before rendering the label for each datapoint.
 * 
 * @param dph
 *            DataPointHints
 * @param label
 *            Label
 * @param icsc
 *            IChartScriptContext
 */

function beforeDrawDataPointLabel( dph, label, icsc )
{
    importPackage(Packages.com.agnitas.reporting.birt.external.dataset);
    
    var reportContext = icsc.getExternalContext().getObject();
	
	var labelText = label.getCaption().getValue();
	var cIndex = labelText.subSequence(labelText.lastIndexOf(&quot;%&quot;) + 2, labelText.lastIndexOf(&quot;%&quot;) + 4);
	var messageKey = &quot;&quot;;
	if(cIndex == CommonKeys.CLICKER_PC_INDEX){
		messageKey = &quot;statistic.pc&quot;;
	} else if(cIndex == CommonKeys.CLICKER_MOBILE_INDEX){
		messageKey = &quot;report.opens.mobile.chartLabel&quot;;
	}else if(cIndex == CommonKeys.CLICKER_TABLET_INDEX) {
		messageKey = &quot;report.opens.tablet.chartLabel&quot;;
	}else if(cIndex == CommonKeys.CLICKER_SMARTTV_INDEX) {
		messageKey = &quot;statistic.smarttv&quot;;
	} else {
		messageKey = &quot;report.opens.pc.and.mobile.chartLabel&quot;;
	} 

	var tr = icsc.getExternalContext().getScriptable().getGlobalVariable(&quot;tr&quot;);	
	var message = tr(messageKey);
	
	labelText = labelText.subSequence(0, labelText.lastIndexOf(&quot;%&quot;) + 1) + &quot; &quot; + message;
	//labelText = labelText.subSequence(0, labelText.lastIndexOf(&quot;%&quot;) + 1) + &quot;\n&quot; + message;
	//labelText = labelText.subSequence(0, labelText.lastIndexOf(&quot;%&quot;) + 1) + &quot;\n&quot; + labelText.substring(labelText.lastIndexOf(&quot;(&quot;));
	label.getCaption().setValue(labelText);
	
	preparePointLabelColor(label, icsc);
}

function beforeDrawMarkerLine(axis, line, icsc) {
	var reportContext = icsc.getExternalContext().getObject();
	if(reportContext.getGlobalVariable(&quot;isDarkmode&quot;) == true){
		line.getLabel().getCaption().getColor().set(255, 255, 255);
	}
};

function preparePointLabelColor(label, icsc) {
	var reportContext = icsc.getExternalContext().getObject();
	if(reportContext.getGlobalVariable(&quot;isDarkmode&quot;) == true){
		label.getCaption().getColor().set(255, 255, 255);
	}
};
</Script>
  <Units>Points</Units>
  <SeriesThickness>20.0</SeriesThickness>
  <GridColumnCount>0</GridColumnCount>
  <ExtendedProperties>
    <Name>enable.area.alt</Name>
    <Value>false</Value>
  </ExtendedProperties>
  <SampleData>
    <BaseSampleData>
      <DataSetRepresentation>'A','B','C','D','E'</DataSetRepresentation>
    </BaseSampleData>
    <OrthogonalSampleData>
      <DataSetRepresentation>6,4,12,8,10</DataSetRepresentation>
      <SeriesDefinitionIndex>0</SeriesDefinitionIndex>
    </OrthogonalSampleData>
  </SampleData>
  <Interactivity>
    <Enable>true</Enable>
    <LegendBehavior>None</LegendBehavior>
  </Interactivity>
  <EmptyMessage>
    <Caption>
      <Value>This chart contains no data.</Value>
      <Font>
        <Alignment>
          <horizontalAlignment>Center</horizontalAlignment>
          <verticalAlignment>Center</verticalAlignment>
        </Alignment>
      </Font>
    </Caption>
    <Background xsi:type="attribute:ColorDefinition">
      <Transparency>64</Transparency>
      <Red>127</Red>
      <Green>127</Green>
      <Blue>127</Blue>
    </Background>
    <Outline>
      <Color>
        <Transparency>128</Transparency>
        <Red>127</Red>
        <Green>127</Green>
        <Blue>127</Blue>
      </Color>
      <Visible>true</Visible>
    </Outline>
    <Insets>
      <Top>10.0</Top>
      <Left>10.0</Left>
      <Bottom>10.0</Bottom>
      <Right>10.0</Right>
    </Insets>
    <Visible>false</Visible>
  </EmptyMessage>
  <SeriesDefinitions>
    <Query>
      <Definition></Definition>
    </Query>
    <SeriesPalette>
      <Entries xsi:type="attribute:ColorDefinition">
        <Transparency>255</Transparency>
        <Red>254</Red>
        <Green>204</Green>
        <Blue>153</Blue>
      </Entries>
      <Entries xsi:type="attribute:ColorDefinition">
        <Transparency>255</Transparency>
        <Red>254</Red>
        <Green>254</Green>
        <Blue>153</Blue>
      </Entries>
      <Entries xsi:type="attribute:ColorDefinition">
        <Transparency>255</Transparency>
        <Red>232</Red>
        <Green>172</Green>
        <Blue>57</Blue>
      </Entries>
      <Entries xsi:type="attribute:ColorDefinition">
        <Transparency>255</Transparency>
        <Red>128</Red>
        <Green>255</Green>
        <Blue>128</Blue>
      </Entries>
      <Entries xsi:type="attribute:ColorDefinition">
        <Transparency>255</Transparency>
        <Red>154</Red>
        <Green>204</Green>
        <Blue>0</Blue>
      </Entries>
      <Entries xsi:type="attribute:ColorDefinition">
        <Transparency>255</Transparency>
        <Red>128</Red>
        <Green>128</Green>
        <Blue>192</Blue>
      </Entries>
      <Entries xsi:type="attribute:ColorDefinition">
        <Transparency>255</Transparency>
        <Red>170</Red>
        <Green>85</Green>
        <Blue>85</Blue>
      </Entries>
      <Entries xsi:type="attribute:ColorDefinition">
        <Transparency>255</Transparency>
        <Red>128</Red>
        <Green>128</Green>
        <Blue>0</Blue>
      </Entries>
      <Entries xsi:type="attribute:ColorDefinition">
        <Transparency>255</Transparency>
        <Red>192</Red>
        <Green>192</Green>
        <Blue>192</Blue>
      </Entries>
      <Entries xsi:type="attribute:ColorDefinition">
        <Transparency>255</Transparency>
        <Red>255</Red>
        <Green>255</Green>
        <Blue>128</Blue>
      </Entries>
      <Entries xsi:type="attribute:ColorDefinition">
        <Transparency>255</Transparency>
        <Red>128</Red>
        <Green>192</Green>
        <Blue>128</Blue>
      </Entries>
      <Entries xsi:type="attribute:ColorDefinition">
        <Transparency>255</Transparency>
        <Red>7</Red>
        <Green>146</Green>
        <Blue>94</Blue>
      </Entries>
      <Entries xsi:type="attribute:ColorDefinition">
        <Transparency>255</Transparency>
        <Red>0</Red>
        <Green>128</Green>
        <Blue>255</Blue>
      </Entries>
      <Entries xsi:type="attribute:ColorDefinition">
        <Transparency>255</Transparency>
        <Red>255</Red>
        <Green>128</Green>
        <Blue>192</Blue>
      </Entries>
      <Entries xsi:type="attribute:ColorDefinition">
        <Transparency>255</Transparency>
        <Red>0</Red>
        <Green>255</Green>
        <Blue>255</Blue>
      </Entries>
      <Entries xsi:type="attribute:ColorDefinition">
        <Transparency>255</Transparency>
        <Red>255</Red>
        <Green>128</Green>
        <Blue>128</Blue>
      </Entries>
      <Entries xsi:type="attribute:ColorDefinition">
        <Transparency>255</Transparency>
        <Red>0</Red>
        <Green>128</Green>
        <Blue>192</Blue>
      </Entries>
      <Entries xsi:type="attribute:ColorDefinition">
        <Transparency>255</Transparency>
        <Red>128</Red>
        <Green>128</Green>
        <Blue>192</Blue>
      </Entries>
      <Entries xsi:type="attribute:ColorDefinition">
        <Transparency>255</Transparency>
        <Red>255</Red>
        <Green>0</Green>
        <Blue>255</Blue>
      </Entries>
      <Entries xsi:type="attribute:ColorDefinition">
        <Transparency>255</Transparency>
        <Red>128</Red>
        <Green>64</Green>
        <Blue>64</Blue>
      </Entries>
      <Entries xsi:type="attribute:ColorDefinition">
        <Transparency>255</Transparency>
        <Red>255</Red>
        <Green>128</Green>
        <Blue>64</Blue>
      </Entries>
      <Entries xsi:type="attribute:ColorDefinition">
        <Transparency>255</Transparency>
        <Red>80</Red>
        <Green>240</Green>
        <Blue>120</Blue>
      </Entries>
      <Entries xsi:type="attribute:ColorDefinition">
        <Transparency>255</Transparency>
        <Red>0</Red>
        <Green>64</Green>
        <Blue>128</Blue>
      </Entries>
      <Entries xsi:type="attribute:ColorDefinition">
        <Transparency>255</Transparency>
        <Red>128</Red>
        <Green>0</Green>
        <Blue>64</Blue>
      </Entries>
      <Entries xsi:type="attribute:ColorDefinition">
        <Transparency>255</Transparency>
        <Red>255</Red>
        <Green>0</Green>
        <Blue>128</Blue>
      </Entries>
      <Entries xsi:type="attribute:ColorDefinition">
        <Transparency>255</Transparency>
        <Red>128</Red>
        <Green>128</Green>
        <Blue>64</Blue>
      </Entries>
      <Entries xsi:type="attribute:ColorDefinition">
        <Transparency>255</Transparency>
        <Red>128</Red>
        <Green>128</Green>
        <Blue>128</Blue>
      </Entries>
      <Entries xsi:type="attribute:ColorDefinition">
        <Transparency>255</Transparency>
        <Red>255</Red>
        <Green>128</Green>
        <Blue>255</Blue>
      </Entries>
      <Entries xsi:type="attribute:ColorDefinition">
        <Transparency>255</Transparency>
        <Red>0</Red>
        <Green>64</Green>
        <Blue>0</Blue>
      </Entries>
      <Entries xsi:type="attribute:ColorDefinition">
        <Transparency>255</Transparency>
        <Red>0</Red>
        <Green>0</Green>
        <Blue>0</Blue>
      </Entries>
      <Entries xsi:type="attribute:ColorDefinition">
        <Transparency>255</Transparency>
        <Red>255</Red>
        <Green>255</Green>
        <Blue>255</Blue>
      </Entries>
      <Entries xsi:type="attribute:ColorDefinition">
        <Transparency>255</Transparency>
        <Red>255</Red>
        <Green>128</Green>
        <Blue>0</Blue>
      </Entries>
      <Entries xsi:type="attribute:ColorDefinition">
        <Transparency>255</Transparency>
        <Red>255</Red>
        <Green>255</Green>
        <Blue>255</Blue>
      </Entries>
    </SeriesPalette>
    <SeriesDefinitions>
      <Query>
        <Definition></Definition>
        <Grouping>
          <GroupType>Numeric</GroupType>
        </Grouping>
      </Query>
      <SeriesPalette>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>254</Red>
          <Green>204</Green>
          <Blue>153</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>254</Red>
          <Green>254</Green>
          <Blue>153</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>232</Red>
          <Green>172</Green>
          <Blue>57</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>128</Red>
          <Green>255</Green>
          <Blue>128</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>154</Red>
          <Green>204</Green>
          <Blue>0</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>128</Red>
          <Green>128</Green>
          <Blue>192</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>170</Red>
          <Green>85</Green>
          <Blue>85</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>128</Red>
          <Green>128</Green>
          <Blue>0</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>192</Red>
          <Green>192</Green>
          <Blue>192</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>255</Red>
          <Green>255</Green>
          <Blue>128</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>128</Red>
          <Green>192</Green>
          <Blue>128</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>7</Red>
          <Green>146</Green>
          <Blue>94</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>0</Red>
          <Green>128</Green>
          <Blue>255</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>255</Red>
          <Green>128</Green>
          <Blue>192</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>0</Red>
          <Green>255</Green>
          <Blue>255</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>255</Red>
          <Green>128</Green>
          <Blue>128</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>0</Red>
          <Green>128</Green>
          <Blue>192</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>128</Red>
          <Green>128</Green>
          <Blue>192</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>255</Red>
          <Green>0</Green>
          <Blue>255</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>128</Red>
          <Green>64</Green>
          <Blue>64</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>255</Red>
          <Green>128</Green>
          <Blue>64</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>80</Red>
          <Green>240</Green>
          <Blue>120</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>0</Red>
          <Green>64</Green>
          <Blue>128</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>128</Red>
          <Green>0</Green>
          <Blue>64</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>255</Red>
          <Green>0</Green>
          <Blue>128</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>128</Red>
          <Green>128</Green>
          <Blue>64</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>128</Red>
          <Green>128</Green>
          <Blue>128</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>255</Red>
          <Green>128</Green>
          <Blue>255</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>0</Red>
          <Green>64</Green>
          <Blue>0</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>0</Red>
          <Green>0</Green>
          <Blue>0</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>255</Red>
          <Green>255</Green>
          <Blue>255</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>255</Red>
          <Green>128</Green>
          <Blue>0</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>255</Red>
          <Green>255</Green>
          <Blue>255</Blue>
        </Entries>
      </SeriesPalette>
      <Series xsi:type="type:PieSeries">
        <Visible>true</Visible>
        <Label>
          <Caption>
            <Value></Value>
            <Font>
              <Name>Arial</Name>
              <Size>10.0</Size>
              <Bold>false</Bold>
              <Alignment/>
              <Rotation>0.0</Rotation>
            </Font>
          </Caption>
          <Background xsi:type="attribute:ColorDefinition">
            <Transparency>0</Transparency>
            <Red>255</Red>
            <Green>255</Green>
            <Blue>255</Blue>
          </Background>
          <Outline>
            <Style>Solid</Style>
            <Thickness>1</Thickness>
            <Color>
              <Transparency>255</Transparency>
              <Red>0</Red>
              <Green>0</Green>
              <Blue>0</Blue>
            </Color>
            <Visible>false</Visible>
          </Outline>
          <Insets>
            <Top>5.0</Top>
            <Left>5.0</Left>
            <Bottom>5.0</Bottom>
            <Right>5.0</Right>
          </Insets>
          <Visible>true</Visible>
        </Label>
        <DataDefinition>
          <Definition>row[&quot;rate&quot;]</Definition>
          <Grouping>
            <GroupType>Text</GroupType>
            <AggregateExpression>Sum</AggregateExpression>
          </Grouping>
        </DataDefinition>
        <SeriesIdentifier>Series 1</SeriesIdentifier>
        <DataPoint>
          <Components>
            <Type>Orthogonal_Value</Type>
            <FormatSpecifier xsi:type="attribute:JavaNumberFormatSpecifier">
              <Pattern>##.#%</Pattern>
            </FormatSpecifier>
          </Components>
          <Components>
            <Type>Base_Value</Type>
          </Components>
          <Prefix></Prefix>
          <Suffix></Suffix>
          <Separator> </Separator>
        </DataPoint>
        <LabelPosition>Outside</LabelPosition>
        <Stacked>false</Stacked>
        <Triggers>
          <Condition>onmouseover</Condition>
          <Action>
            <Type>Highlight</Type>
            <Value xsi:type="attribute:SeriesValue">
              <Name></Name>
            </Value>
          </Action>
        </Triggers>
        <Cursor>
          <Type>Auto</Type>
        </Cursor>
        <Explosion>0</Explosion>
        <ExplosionExpression></ExplosionExpression>
        <Title>
          <Caption>
            <Value></Value>
            <Font>
              <Size>16.0</Size>
              <Bold>true</Bold>
              <Alignment/>
            </Font>
          </Caption>
          <Background xsi:type="attribute:ColorDefinition">
            <Transparency>0</Transparency>
            <Red>255</Red>
            <Green>255</Green>
            <Blue>255</Blue>
          </Background>
          <Outline>
            <Style>Solid</Style>
            <Thickness>1</Thickness>
            <Color>
              <Transparency>255</Transparency>
              <Red>0</Red>
              <Green>0</Green>
              <Blue>0</Blue>
            </Color>
          </Outline>
          <Insets>
            <Top>0.0</Top>
            <Left>2.0</Left>
            <Bottom>0.0</Bottom>
            <Right>3.0</Right>
          </Insets>
          <Visible>false</Visible>
        </Title>
        <TitlePosition>Below</TitlePosition>
        <LeaderLineAttributes>
          <Style>Solid</Style>
          <Thickness>1</Thickness>
          <Color>
            <Transparency>255</Transparency>
            <Red>128</Red>
            <Green>128</Green>
            <Blue>128</Blue>
          </Color>
          <Visible>true</Visible>
        </LeaderLineAttributes>
        <LeaderLineStyle>Fixed_Length</LeaderLineStyle>
        <LeaderLineLength>0.0</LeaderLineLength>
        <SliceOutline>
          <Transparency>0</Transparency>
          <Red>255</Red>
          <Green>255</Green>
          <Blue>255</Blue>
        </SliceOutline>
        <Ratio>1.0</Ratio>
        <Rotation>0.0</Rotation>
        <InnerRadius>60.0</InnerRadius>
      </Series>
    </SeriesDefinitions>
    <Series>
      <Visible>true</Visible>
      <Label>
        <Caption>
          <Value></Value>
          <Font>
            <Alignment/>
          </Font>
        </Caption>
        <Background xsi:type="attribute:ColorDefinition">
          <Transparency>0</Transparency>
          <Red>255</Red>
          <Green>255</Green>
          <Blue>255</Blue>
        </Background>
        <Outline>
          <Style>Solid</Style>
          <Thickness>1</Thickness>
          <Color>
            <Transparency>255</Transparency>
            <Red>0</Red>
            <Green>0</Green>
            <Blue>0</Blue>
          </Color>
          <Visible>false</Visible>
        </Outline>
        <Insets>
          <Top>0.0</Top>
          <Left>2.0</Left>
          <Bottom>0.0</Bottom>
          <Right>3.0</Right>
        </Insets>
        <Visible>false</Visible>
      </Label>
      <DataDefinition>
        <Definition>row[&quot;category_index&quot;]</Definition>
      </DataDefinition>
      <SeriesIdentifier></SeriesIdentifier>
      <DataPoint>
        <Components>
          <Type>Orthogonal_Value</Type>
        </Components>
        <Separator>, </Separator>
      </DataPoint>
      <LabelPosition>Outside</LabelPosition>
      <Stacked>false</Stacked>
    </Series>
    <Grouping>
      <Enabled>false</Enabled>
      <GroupType>Numeric</GroupType>
      <AggregateExpression>Sum</AggregateExpression>
    </Grouping>
    <Sorting>Ascending</Sorting>
    <SortKey>
      <Definition>row[&quot;category_index&quot;]</Definition>
    </SortKey>
  </SeriesDefinitions>
  <MinSlicePercent>false</MinSlicePercent>
  <Coverage>0.65</Coverage>
</model:ChartWithoutAxes>
]]></xml-property>
                                    <property name="outputFormat">SVG</property>
                                    <list-property name="filter">
                                        <structure>
                                            <property name="operator">is-true</property>
                                            <expression name="expr" type="javascript">row["category_index"] == CommonKeys.CLICKER_PC_INDEX || row["category_index"] == CommonKeys.CLICKER_TABLET_INDEX || row["category_index"] == CommonKeys.CLICKER_MOBILE_INDEX || row["category_index"] == CommonKeys.CLICKER_SMARTTV_INDEX || row["category_index"] == CommonKeys.CLICKER_PC_AND_MOBILE_INDEX</expression>
                                            <property name="updateAggregation">true</property>
                                        </structure>
                                        <structure>
                                            <property name="operator">eq</property>
                                            <expression name="expr" type="javascript">row["groupId"]</expression>
                                            <simple-property-list name="value1">
                                                <value>CommonKeys.OPTIMIZATION_WINNER_GROUP_ID</value>
                                            </simple-property-list>
                                            <property name="updateAggregation">true</property>
                                        </structure>
                                    </list-property>
                                    <property name="inheritColumns">false</property>
                                    <property name="display">block</property>
                                    <property name="height">320px</property>
                                    <property name="width">668px</property>
                                    <property name="dataSet">OptimizationSummaryDataSet</property>
                                    <list-property name="boundDataColumns">
                                        <structure>
                                            <property name="name">category</property>
                                            <text-property name="displayName">category</text-property>
                                            <expression name="expression" type="javascript">dataSetRow["category"]</expression>
                                            <property name="dataType">string</property>
                                        </structure>
                                        <structure>
                                            <property name="name">category_index</property>
                                            <text-property name="displayName">category_index</text-property>
                                            <expression name="expression" type="javascript">dataSetRow["category_index"]</expression>
                                            <property name="dataType">integer</property>
                                        </structure>
                                        <structure>
                                            <property name="name">value</property>
                                            <text-property name="displayName">value</text-property>
                                            <expression name="expression" type="javascript">dataSetRow["value"]</expression>
                                            <property name="dataType">integer</property>
                                        </structure>
                                        <structure>
                                            <property name="name">rate</property>
                                            <text-property name="displayName">rate</text-property>
                                            <expression name="expression" type="javascript">dataSetRow["rate"]</expression>
                                            <property name="dataType">float</property>
                                        </structure>
                                        <structure>
                                            <property name="name">deliveredRate</property>
                                            <text-property name="displayName">deliveredRate</text-property>
                                            <expression name="expression" type="javascript">dataSetRow["deliveredRate"]</expression>
                                            <property name="dataType">float</property>
                                        </structure>
                                        <structure>
                                            <property name="name">mailingId</property>
                                            <text-property name="displayName">mailingId</text-property>
                                            <expression name="expression" type="javascript">dataSetRow["mailingId"]</expression>
                                            <property name="dataType">integer</property>
                                        </structure>
                                        <structure>
                                            <property name="name">groupId</property>
                                            <text-property name="displayName">groupId</text-property>
                                            <expression name="expression" type="javascript">dataSetRow["groupId"]</expression>
                                            <property name="dataType">integer</property>
                                        </structure>
                                        <structure>
                                            <property name="name">categoryKey</property>
                                            <text-property name="displayName">categoryKey</text-property>
                                            <expression name="expression" type="javascript">dataSetRow["categoryKey"]</expression>
                                            <property name="dataType">string</property>
                                        </structure>
                                        <structure>
                                            <property name="name">isWinner</property>
                                            <text-property name="displayName">isWinner</text-property>
                                            <expression name="expression" type="javascript">dataSetRow["isWinner"]</expression>
                                            <property name="dataType">boolean</property>
                                        </structure>
                                        <structure>
                                            <property name="name">baseGroupId</property>
                                            <text-property name="displayName">baseGroupId</text-property>
                                            <expression name="expression" type="javascript">dataSetRow["baseGroupId"]</expression>
                                            <property name="dataType">integer</property>
                                        </structure>
                                    </list-property>
                                </extended-item>
                            </cell>
                        </row>
                    </grid>
                </cell>
            </row>
            <row id="1476">
                <cell id="1477">
                    <property name="colSpan">2</property>
                    <property name="rowSpan">1</property>
                    <property name="style">full-width</property>
                    <extended-item extensionName="Crosstab" extensionVersion="3.7.0" name="openersClickersData"
 id="1479">
                        <property name="cube">SummaryOptimizationDataCube</property>
                        <property name="measures">
                            <extended-item extensionName="MeasureView" id="1480">
                                <property name="measure">value</property>
                                <property name="detail">
                                    <extended-item extensionName="AggregationCell" id="1481">
                                        <property name="aggregationOnRow">categoryGroup/category_index</property>
                                        <property name="aggregationOnColumn">optimizationGroup/optimizationGroupId</property>
                                        <property name="content">
                                            <data id="1504">
                                                <structure name="numberFormat">
                                                    <property name="category">Currency</property>
                                                    <property name="pattern">#,##0{RoundingMode=HALF_UP}</property>
                                                </structure>
                                                <list-property name="visibility">
                                                    <structure>
                                                        <property name="format">all</property>
                                                        <expression name="valueExpr" type="javascript">data["value"] &lt; 0 ||
data["value"] == null</expression>
                                                    </structure>
                                                </list-property>
                                                <property name="resultSetColumn">value</property>
                                            </data>
                                            <text-data id="1891">
                                                <list-property name="visibility">
                                                    <structure>
                                                        <property name="format">all</property>
                                                        <expression name="valueExpr" type="javascript">data["value"] >= 0 &amp;&amp;
data["value"] != null</expression>
                                                    </structure>
                                                </list-property>
                                                <expression name="valueExpr">tr("NotAvailableShort")</expression>
                                            </text-data>
                                        </property>
                                        <property name="style">crosstab-value</property>
                                    </extended-item>
                                </property>
                                <property name="header">
                                    <extended-item extensionName="CrosstabCell" id="1485">
                                        <property name="style">to-hide</property>
                                    </extended-item>
                                </property>
                            </extended-item>
                            <extended-item extensionName="MeasureView" id="1486">
                                <property name="measure">rate</property>
                                <property name="detail">
                                    <extended-item extensionName="AggregationCell" id="1487">
                                        <property name="aggregationOnRow">categoryGroup/category_index</property>
                                        <property name="aggregationOnColumn">optimizationGroup/optimizationGroupId</property>
                                        <property name="content">
                                            <data id="1503">
                                                <structure name="numberFormat">
                                                    <property name="category">Custom</property>
                                                    <property name="pattern">(0.0%)</property>
                                                </structure>
                                                <list-property name="visibility">
                                                    <structure>
                                                        <property name="format">all</property>
                                                        <expression name="valueExpr" type="javascript">data["rate"] &lt; 0 ||
data["rate"] == null</expression>
                                                    </structure>
                                                </list-property>
                                                <property name="resultSetColumn">rate</property>
                                            </data>
                                            <text-data id="1890">
                                                <list-property name="visibility">
                                                    <structure>
                                                        <property name="format">all</property>
                                                        <expression name="valueExpr" type="javascript">data["rate"] >= 0 &amp;&amp;
data["rate"] != null</expression>
                                                    </structure>
                                                </list-property>
                                                <expression name="valueExpr">tr("NotAvailableShort")</expression>
                                            </text-data>
                                        </property>
                                        <property name="style">crosstab-value</property>
                                    </extended-item>
                                </property>
                                <property name="header">
                                    <extended-item extensionName="CrosstabCell" id="1490">
                                        <property name="style">to-hide</property>
                                    </extended-item>
                                </property>
                            </extended-item>
                        </property>
                        <property name="rows">
                            <extended-item extensionName="CrosstabView" id="1491">
                                <property name="views">
                                    <extended-item extensionName="DimensionView" id="1492">
                                        <property name="dimension">categoryGroup</property>
                                        <property name="levels">
                                            <extended-item extensionName="LevelView" name="NewLevel View21" id="1493">
                                                <property name="level">categoryGroup/category_index</property>
                                                <property name="filter">
                                                    <filter-condition-element>
                                                        <expression name="expr" type="javascript">data["category_index"]</expression>
                                                        <property name="operator">in</property>
                                                        <simple-property-list name="value1">
                                                            <value type="javascript">CommonKeys.OPENERS_TRACKED_INDEX</value>
                                                            <value type="javascript">CommonKeys.OPENERS_PC_INDEX</value>
                                                            <value type="javascript">CommonKeys.OPENERS_TABLET_INDEX</value>
                                                            <value type="javascript">CommonKeys.OPENERS_MOBILE_INDEX</value>
                                                            <value type="javascript">CommonKeys.OPENERS_SMARTTV_INDEX</value>
                                                            <value type="javascript">CommonKeys.OPENERS_PC_AND_MOBILE_INDEX</value>
                                                            <value type="javascript">CommonKeys.CLICKER_TRACKED_INDEX</value>
                                                            <value type="javascript">CommonKeys.CLICKER_PC_INDEX</value>
                                                            <value type="javascript">CommonKeys.CLICKER_TABLET_INDEX</value>
                                                            <value type="javascript">CommonKeys.CLICKER_MOBILE_INDEX</value>
                                                            <value type="javascript">CommonKeys.CLICKER_SMARTTV_INDEX</value>
                                                            <value type="javascript">CommonKeys.CLICKER_PC_AND_MOBILE_INDEX</value>
                                                        </simple-property-list>
                                                        <property name="updateAggregation">true</property>
                                                    </filter-condition-element>
                                                </property>
                                                <property name="sort">
                                                    <sort-element>
                                                        <expression name="key" type="javascript">dimension["categoryGroup"]["category_index"]</expression>
                                                        <property name="direction">asc</property>
                                                        <property name="strength">-1</property>
                                                    </sort-element>
                                                </property>
                                                <property name="member">
                                                    <extended-item extensionName="CrosstabCell" id="1494">
                                                        <property name="content">
                                                            <data name="category_index11" id="1495">
                                                                <property name="resultSetColumn">category</property>
                                                            </data>
                                                        </property>
                                                        <property name="textAlign">left</property>
                                                    </extended-item>
                                                </property>
                                            </extended-item>
                                        </property>
                                    </extended-item>
                                </property>
                            </extended-item>
                        </property>
                        <property name="columns">
                            <extended-item extensionName="CrosstabView" id="1496">
                                <property name="views">
                                    <extended-item extensionName="DimensionView" id="1497">
                                        <property name="dimension">optimizationGroup</property>
                                        <property name="levels">
                                            <extended-item extensionName="LevelView" name="NewLevel View111" id="1498">
                                                <property name="level">optimizationGroup/optimizationGroupId</property>
                                                <property name="sort">
                                                    <sort-element>
                                                        <expression name="key" type="javascript">getCrossTableColumnPosition(dimension["optimizationGroup"]["optimizationGroupId"])</expression>
                                                        <property name="direction">asc</property>
                                                        <property name="strength">-1</property>
                                                    </sort-element>
                                                </property>
                                                <property name="member">
                                                    <extended-item extensionName="CrosstabCell" id="1499">
                                                        <property name="content">
                                                            <data name="optimizationGroup11" id="1500">
                                                                <property name="display">inline</property>
                                                                <property name="resultSetColumn">groupTitle</property>
                                                            </data>
                                                            <image id="1877">
                                                                <property name="display">inline</property>
                                                                <property name="height">16px</property>
                                                                <property name="width">16px</property>
                                                                <list-property name="visibility">
                                                                    <structure>
                                                                        <property name="format">all</property>
                                                                        <expression name="valueExpr" type="javascript">!isWinnerMailing(data["optimizationGroupId"])</expression>
                                                                    </structure>
                                                                </list-property>
                                                                <property name="source">embed</property>
                                                                <property name="imageName">ok_icon.png</property>
                                                            </image>
                                                        </property>
                                                        <property name="style">table-head crosstab-header</property>
                                                    </extended-item>
                                                </property>
                                            </extended-item>
                                        </property>
                                    </extended-item>
                                </property>
                            </extended-item>
                        </property>
                        <property name="header">
                            <extended-item extensionName="CrosstabCell" id="1501">
                                <property name="content">
                                    <text-data id="1502">
                                        <expression name="valueExpr">tr("KeydataPCMobile")</expression>
                                        <property name="contentType">html</property>
                                    </text-data>
                                </property>
                                <property name="style">table-head</property>
                            </extended-item>
                        </property>
                        <list-property name="boundDataColumns">
                            <structure>
                                <property name="name">category_index</property>
                                <expression name="expression">dimension["categoryGroup"]["category_index"]</expression>
                                <property name="dataType">integer</property>
                            </structure>
                            <structure>
                                <property name="name">optimizationGroup</property>
                                <expression name="expression" type="javascript">dimension["optimizationGroup"]["optimizationGroupId"]</expression>
                                <property name="dataType">integer</property>
                            </structure>
                            <structure>
                                <property name="name">category</property>
                                <expression name="expression" type="javascript">dimension["categoryGroup"]["category_index"]["category"]</expression>
                                <property name="dataType">string</property>
                            </structure>
                            <structure>
                                <property name="name">optimizationGroupId</property>
                                <expression name="expression">dimension["optimizationGroup"]["optimizationGroupId"]</expression>
                                <property name="dataType">integer</property>
                            </structure>
                            <structure>
                                <property name="name">groupTitle</property>
                                <expression name="expression" type="javascript">getMailingGroupNameTitle(data["optimizationGroupId"], dimension["optimizationGroup"]["optimizationGroupId"]["baseGroupId"])</expression>
                                <property name="dataType">string</property>
                            </structure>
                            <structure>
                                <property name="name">value</property>
                                <property name="dataType">float</property>
                                <simple-property-list name="aggregateOn">
                                    <value>categoryGroup/category_index</value>
                                    <value>optimizationGroup/optimizationGroupId</value>
                                </simple-property-list>
                                <property name="aggregateFunction">SUM</property>
                                <list-property name="arguments">
                                    <structure>
                                        <property name="name">Expression</property>
                                        <expression name="value" type="javascript">measure["value"]</expression>
                                    </structure>
                                </list-property>
                            </structure>
                            <structure>
                                <property name="name">value_groupOptimization</property>
                                <property name="dataType">float</property>
                                <simple-property-list name="aggregateOn">
                                    <value>categoryGroup/category_index</value>
                                    <value>optimizationGroup/optimizationGroupId</value>
                                </simple-property-list>
                                <property name="aggregateFunction">SUM</property>
                                <list-property name="arguments">
                                    <structure>
                                        <property name="name">Expression</property>
                                        <expression name="value" type="javascript">measure["value"]</expression>
                                    </structure>
                                </list-property>
                            </structure>
                            <structure>
                                <property name="name">rate_optimizationGroup</property>
                                <property name="dataType">float</property>
                                <simple-property-list name="aggregateOn">
                                    <value>categoryGroup/category_index</value>
                                    <value>optimizationGroup/optimizationGroupId</value>
                                </simple-property-list>
                                <property name="aggregateFunction">SUM</property>
                                <list-property name="arguments">
                                    <structure>
                                        <property name="name">Expression</property>
                                        <expression name="value" type="javascript">measure["rate"]</expression>
                                    </structure>
                                </list-property>
                            </structure>
                            <structure>
                                <property name="name">rate</property>
                                <expression name="expression" type="javascript">if (data["category_index"] == CommonKeys.OPENERS_TRACKED_INDEX || 
data["category_index"] == CommonKeys.CLICKER_TRACKED_INDEX) {
  //data["value_CategoryGroup/category_TargetgroupGroup/targetgroup"] / data["total_sent"]
  if (data["value_groupOptimization"] > 0) {1} else {0}
} else {
   data["rate_optimizationGroup"]
}</expression>
                                <property name="dataType">float</property>
                            </structure>
                        </list-property>
                        <property name="style">table table-striped</property>
                    </extended-item>
                </cell>
            </row>
            <row id="1505">
                <cell id="1506">
                    <property name="colSpan">2</property>
                    <property name="rowSpan">1</property>
                    <property name="style">full-width</property>
                    <extended-item extensionName="Crosstab" extensionVersion="3.7.0" name="activityRateTable"
 id="1508">
                        <property name="cube">SummaryOptimizationDataCube</property>
                        <property name="measures">
                            <extended-item extensionName="MeasureView" id="1509">
                                <property name="measure">value</property>
                                <property name="detail">
                                    <extended-item extensionName="AggregationCell" id="1510">
                                        <property name="aggregationOnRow">categoryGroup/category_index</property>
                                        <property name="aggregationOnColumn">optimizationGroup/optimizationGroupId</property>
                                        <property name="content">
                                            <data id="1511">
                                                <structure name="numberFormat">
                                                    <property name="category">Currency</property>
                                                    <property name="pattern">#,##0{RoundingMode=HALF_UP}</property>
                                                </structure>
                                                <property name="resultSetColumn">formattedValue</property>
                                            </data>
                                        </property>
                                        <property name="style">crosstab-value</property>
                                    </extended-item>
                                </property>
                                <property name="header">
                                    <extended-item extensionName="CrosstabCell" id="1512">
                                        <property name="style">to-hide</property>
                                    </extended-item>
                                </property>
                            </extended-item>
                        </property>
                        <property name="rows">
                            <extended-item extensionName="CrosstabView" id="1517">
                                <property name="views">
                                    <extended-item extensionName="DimensionView" id="1518">
                                        <property name="dimension">categoryGroup</property>
                                        <property name="levels">
                                            <extended-item extensionName="LevelView" name="NewLevel View211" id="1519">
                                                <property name="level">categoryGroup/category_index</property>
                                                <property name="filter">
                                                    <filter-condition-element>
                                                        <expression name="expr" type="javascript">(dimension["categoryGroup"]["category_index"] >= CommonKeys.OPENINGS_GROSS_MEASURED_INDEX ||
dimension["categoryGroup"]["category_index"] >= CommonKeys.CLICKS_GROSS_INDEX) &amp;&amp;
dimension["categoryGroup"]["category_index"] &lt;= CommonKeys.ACTIVITY_RATE_INDEX</expression>
                                                        <property name="operator">is-true</property>
                                                        <property name="updateAggregation">true</property>
                                                    </filter-condition-element>
                                                </property>
                                                <property name="sort">
                                                    <sort-element>
                                                        <expression name="key" type="javascript">dimension["categoryGroup"]["category_index"]</expression>
                                                        <property name="direction">asc</property>
                                                        <property name="strength">-1</property>
                                                    </sort-element>
                                                </property>
                                                <property name="member">
                                                    <extended-item extensionName="CrosstabCell" id="1520">
                                                        <property name="content">
                                                            <data name="category_index111" id="1521">
                                                                <property name="resultSetColumn">category</property>
                                                            </data>
                                                        </property>
                                                        <property name="textAlign">left</property>
                                                    </extended-item>
                                                </property>
                                            </extended-item>
                                        </property>
                                    </extended-item>
                                </property>
                            </extended-item>
                        </property>
                        <property name="columns">
                            <extended-item extensionName="CrosstabView" id="1522">
                                <property name="views">
                                    <extended-item extensionName="DimensionView" id="1523">
                                        <property name="dimension">optimizationGroup</property>
                                        <property name="levels">
                                            <extended-item extensionName="LevelView" name="NewLevel View1111" id="1524">
                                                <property name="level">optimizationGroup/optimizationGroupId</property>
                                                <property name="sort">
                                                    <sort-element>
                                                        <expression name="key" type="javascript">getCrossTableColumnPosition(dimension["optimizationGroup"]["optimizationGroupId"])</expression>
                                                        <property name="direction">asc</property>
                                                        <property name="strength">-1</property>
                                                    </sort-element>
                                                </property>
                                                <property name="member">
                                                    <extended-item extensionName="CrosstabCell" id="1525">
                                                        <property name="content">
                                                            <data name="optimizationGroup111" id="1526">
                                                                <property name="display">inline</property>
                                                                <property name="resultSetColumn">groupTitle</property>
                                                            </data>
                                                            <image id="1878">
                                                                <property name="display">inline</property>
                                                                <property name="height">16px</property>
                                                                <property name="width">16px</property>
                                                                <list-property name="visibility">
                                                                    <structure>
                                                                        <property name="format">all</property>
                                                                        <expression name="valueExpr" type="javascript">!isWinnerMailing(data["optimizationGroupId"])</expression>
                                                                    </structure>
                                                                </list-property>
                                                                <property name="source">embed</property>
                                                                <property name="imageName">ok_icon.png</property>
                                                            </image>
                                                        </property>
                                                        <property name="style">table-head crosstab-header</property>
                                                    </extended-item>
                                                </property>
                                            </extended-item>
                                        </property>
                                    </extended-item>
                                </property>
                            </extended-item>
                        </property>
                        <property name="header">
                            <extended-item extensionName="CrosstabCell" id="1529">
                                <property name="content">
                                    <text-data id="1530">
                                        <expression name="valueExpr">tr("statistic.Response")</expression>
                                        <property name="contentType">html</property>
                                    </text-data>
                                </property>
                                <property name="style">table-head</property>
                            </extended-item>
                        </property>
                        <list-property name="boundDataColumns">
                            <structure>
                                <property name="name">category_index</property>
                                <expression name="expression">dimension["categoryGroup"]["category_index"]</expression>
                                <property name="dataType">integer</property>
                            </structure>
                            <structure>
                                <property name="name">optimizationGroup</property>
                                <expression name="expression" type="javascript">dimension["optimizationGroup"]["optimizationGroupId"]</expression>
                                <property name="dataType">integer</property>
                            </structure>
                            <structure>
                                <property name="name">category</property>
                                <expression name="expression" type="javascript">dimension["categoryGroup"]["category_index"]["category"]</expression>
                                <property name="dataType">string</property>
                            </structure>
                            <structure>
                                <property name="name">optimizationGroupId</property>
                                <expression name="expression">dimension["optimizationGroup"]["optimizationGroupId"]</expression>
                                <property name="dataType">integer</property>
                            </structure>
                            <structure>
                                <property name="name">groupTitle</property>
                                <expression name="expression" type="javascript">getMailingGroupNameTitle(data["optimizationGroupId"], dimension["optimizationGroup"]["optimizationGroupId"]["baseGroupId"])</expression>
                                <property name="dataType">string</property>
                            </structure>
                            <structure>
                                <property name="name">cubeValue</property>
                                <property name="dataType">integer</property>
                                <simple-property-list name="aggregateOn">
                                    <value>categoryGroup/category_index</value>
                                    <value>optimizationGroup/optimizationGroupId</value>
                                </simple-property-list>
                                <property name="aggregateFunction">SUM</property>
                                <list-property name="arguments">
                                    <structure>
                                        <property name="name">Expression</property>
                                        <expression name="value" type="javascript">measure["value"]</expression>
                                    </structure>
                                </list-property>
                            </structure>
                            <structure>
                                <property name="name">cubeRate</property>
                                <property name="dataType">float</property>
                                <simple-property-list name="aggregateOn">
                                    <value>categoryGroup/category_index</value>
                                    <value>optimizationGroup/optimizationGroupId</value>
                                </simple-property-list>
                                <property name="aggregateFunction">SUM</property>
                                <list-property name="arguments">
                                    <structure>
                                        <property name="name">Expression</property>
                                        <expression name="value" type="javascript">measure["rate"]</expression>
                                    </structure>
                                </list-property>
                            </structure>
                            <structure>
                                <property name="name">formattedValue</property>
                                <expression name="expression" type="javascript">if(data["category_index"] == CommonKeys.OPENINGS_GROSS_MEASURED_INDEX || data["category_index"] == CommonKeys.CLICKS_GROSS_INDEX) {
	"" + Formatter.format(data["cubeValue"], "#,##0")
} else if(data["category_index"] == CommonKeys.ACTIVITY_RATE_INDEX) {
	"" + Formatter.format(data["cubeRate"], "0.0%")
} else {""}</expression>
                                <property name="dataType">string</property>
                            </structure>
                        </list-property>
                        <property name="style">table table-striped</property>
                    </extended-item>
                </cell>
            </row>
            <row id="1531">
                <cell id="1532">
                    <property name="colSpan">2</property>
                    <property name="rowSpan">1</property>
                    <property name="style">full-width</property>
                    <text-data id="756">
                        <property name="style">footnote</property>
                        <property name="marginTop">0pt</property>
                        <expression name="valueExpr">tr("report.mailsize.explanation")</expression>
                    </text-data>
                    <text-data id="1904">
                        <property name="style">footnote</property>
                        <property name="marginTop">0pt</property>
                        <expression name="valueExpr">tr("report.opens.measured.explanation")</expression>
                    </text-data>
                    <text-data id="1039">
                        <property name="style">footnote</property>
                        <expression name="valueExpr">tr("report.opens.invisible.explanation")</expression>
                    </text-data>
                    <text-data id="1038">
                        <property name="style">footnote</property>
                        <expression name="valueExpr">tr("report.opens.pc.and.mobile.explanation")</expression>
                    </text-data>
                    <text-data id="834">
                        <property name="style">footnote</property>
                        <expression name="valueExpr">tr("statistic.MeasuredOpeningsGross.explanation")</expression>
                    </text-data>
                    <text-data id="757">
                        <property name="style">footnote</property>
                        <property name="marginTop">0pt</property>
                        <expression name="valueExpr">tr("statistic.ActivityRate.explanation")</expression>
                    </text-data>
                    <text-data id="754">
                        <property name="style">footnote</property>
                        <property name="marginTop">0pt</property>
                        <expression name="valueExpr">tr("statistic.withoutConfirmation.explanation")</expression>
                    </text-data>
                    <text-data id="755">
                        <property name="style">footnote</property>
                        <property name="marginTop">0pt</property>
                        <list-property name="visibility">
                            <structure>
                                <property name="format">all</property>
                                <expression name="valueExpr" type="javascript">reportContext.getPersistentGlobalVariable("trackingExists") == true</expression>
                            </structure>
                        </list-property>
                        <expression name="valueExpr">tr("noTrackingData")</expression>
                    </text-data>
                </cell>
            </row>
        </grid>
        <grid id="1533">
            <property name="fontFamily">"Arial"</property>
            <list-property name="visibility">
                <structure>
                    <property name="format">all</property>
                    <expression name="valueExpr" type="javascript">reportContext.getOutputFormat() != "csv"</expression>
                </structure>
            </list-property>
            <column id="1534"/>
            <row id="1535">
                <cell id="1536">
                    <table id="1583">
                        <property name="dataSet">OptimizationSummaryDataSet</property>
                        <list-property name="boundDataColumns">
                            <structure>
                                <property name="name">category</property>
                                <text-property name="displayName">category</text-property>
                                <expression name="expression" type="javascript">dataSetRow["category"]</expression>
                                <property name="dataType">string</property>
                            </structure>
                            <structure>
                                <property name="name">category_index</property>
                                <text-property name="displayName">category_index</text-property>
                                <expression name="expression" type="javascript">dataSetRow["category_index"]</expression>
                                <property name="dataType">integer</property>
                            </structure>
                            <structure>
                                <property name="name">targetgroup</property>
                                <text-property name="displayName">targetgroup</text-property>
                                <expression name="expression" type="javascript">dataSetRow["targetgroup"]</expression>
                                <property name="dataType">string</property>
                            </structure>
                            <structure>
                                <property name="name">targetgroupId</property>
                                <text-property name="displayName">targetgroupId</text-property>
                                <expression name="expression" type="javascript">dataSetRow["targetgroupId"]</expression>
                                <property name="dataType">integer</property>
                            </structure>
                            <structure>
                                <property name="name">value</property>
                                <text-property name="displayName">value</text-property>
                                <expression name="expression" type="javascript">dataSetRow["value"]</expression>
                                <property name="dataType">integer</property>
                            </structure>
                            <structure>
                                <property name="name">rate</property>
                                <text-property name="displayName">rate</text-property>
                                <expression name="expression" type="javascript">dataSetRow["rate"]</expression>
                                <property name="dataType">float</property>
                            </structure>
                            <structure>
                                <property name="name">deliveredRate</property>
                                <text-property name="displayName">deliveredRate</text-property>
                                <expression name="expression" type="javascript">dataSetRow["deliveredRate"]</expression>
                                <property name="dataType">float</property>
                            </structure>
                            <structure>
                                <property name="name">mailingId</property>
                                <text-property name="displayName">mailingId</text-property>
                                <expression name="expression" type="javascript">dataSetRow["mailingId"]</expression>
                                <property name="dataType">integer</property>
                            </structure>
                            <structure>
                                <property name="name">mailingName</property>
                                <text-property name="displayName">mailingName</text-property>
                                <expression name="expression" type="javascript">dataSetRow["mailingName"]</expression>
                                <property name="dataType">string</property>
                            </structure>
                            <structure>
                                <property name="name">groupId</property>
                                <text-property name="displayName">groupId</text-property>
                                <expression name="expression" type="javascript">dataSetRow["groupId"]</expression>
                                <property name="dataType">integer</property>
                            </structure>
                            <structure>
                                <property name="name">categoryKey</property>
                                <text-property name="displayName">categoryKey</text-property>
                                <expression name="expression" type="javascript">dataSetRow["categoryKey"]</expression>
                                <property name="dataType">string</property>
                            </structure>
                            <structure>
                                <property name="name">baseMailingName</property>
                                <text-property name="displayName">baseMailingName</text-property>
                                <expression name="expression" type="javascript">dataSetRow["baseMailingName"]</expression>
                                <property name="dataType">string</property>
                            </structure>
                            <structure>
                                <property name="name">isWinner</property>
                                <text-property name="displayName">isWinner</text-property>
                                <expression name="expression" type="javascript">dataSetRow["isWinner"]</expression>
                                <property name="dataType">boolean</property>
                            </structure>
                            <structure>
                                <property name="name">baseGroupId</property>
                                <text-property name="displayName">baseGroupId</text-property>
                                <expression name="expression" type="javascript">dataSetRow["baseGroupId"]</expression>
                                <property name="dataType">integer</property>
                            </structure>
                            <structure>
                                <property name="name">groupId_agr</property>
                                <property name="dataType">integer</property>
                                <simple-property-list name="aggregateOn">
                                    <value>OptGroup</value>
                                </simple-property-list>
                                <property name="aggregateFunction">FIRST</property>
                                <list-property name="arguments">
                                    <structure>
                                        <property name="name">Expression</property>
                                        <expression name="value" type="javascript">row["groupId"]</expression>
                                    </structure>
                                </list-property>
                                <property name="allowExport">true</property>
                            </structure>
                            <structure>
                                <property name="name">value_agr</property>
                                <property name="dataType">float</property>
                                <simple-property-list name="aggregateOn">
                                    <value>OptGroup</value>
                                </simple-property-list>
                                <property name="aggregateFunction">MAX</property>
                                <list-property name="arguments">
                                    <structure>
                                        <property name="name">Expression</property>
                                        <expression name="value" type="javascript">if (row["value"] &lt; 0) {0}else {row["value"]}</expression>
                                    </structure>
                                </list-property>
                                <property name="allowExport">true</property>
                            </structure>
                            <structure>
                                <property name="name">rate_agr</property>
                                <property name="dataType">float</property>
                                <simple-property-list name="aggregateOn">
                                    <value>OptGroup</value>
                                </simple-property-list>
                                <property name="aggregateFunction">MAX</property>
                                <list-property name="arguments">
                                    <structure>
                                        <property name="name">Expression</property>
                                        <expression name="value" type="javascript">if (row["rate"] &lt; 0) {0}else {row["rate"]}</expression>
                                    </structure>
                                </list-property>
                                <property name="allowExport">true</property>
                            </structure>
                            <structure>
                                <property name="name">delivered_rate_agr</property>
                                <property name="dataType">float</property>
                                <simple-property-list name="aggregateOn">
                                    <value>OptGroup</value>
                                </simple-property-list>
                                <property name="aggregateFunction">MAX</property>
                                <list-property name="arguments">
                                    <structure>
                                        <property name="name">Expression</property>
                                        <expression name="value" type="javascript">if (row["deliveredRate"] &lt; 0) {0}else {row["deliveredRate"]}</expression>
                                    </structure>
                                </list-property>
                                <property name="allowExport">true</property>
                            </structure>
                            <structure>
                                <property name="name">optGroupName</property>
                                <expression name="expression" type="javascript">getMailingGroupNameTitle(row["groupId_agr"], row["baseGroupId"])</expression>
                                <property name="dataType">string</property>
                                <property name="allowExport">true</property>
                            </structure>
                            <structure>
                                <property name="name">categoryHeader</property>
                                <expression name="expression" type="javascript">tr("grid.mediapool.category")</expression>
                                <property name="dataType">string</property>
                                <property name="allowExport">true</property>
                            </structure>
                            <structure>
                                <property name="name">mailingHeader</property>
                                <expression name="expression" type="javascript">tr("Mailings")</expression>
                                <property name="dataType">string</property>
                                <property name="allowExport">true</property>
                            </structure>
                            <structure>
                                <property name="name">targetsHeader</property>
                                <expression name="expression" type="javascript">tr("birt.Target")</expression>
                                <property name="dataType">string</property>
                                <property name="allowExport">true</property>
                            </structure>
                            <structure>
                                <property name="name">valueHeader</property>
                                <expression name="expression" type="javascript">tr("value")</expression>
                                <property name="dataType">string</property>
                                <property name="allowExport">true</property>
                            </structure>
                            <structure>
                                <property name="name">rateHeader</property>
                                <expression name="expression" type="javascript">tr("Brutto")</expression>
                                <property name="dataType">string</property>
                                <property name="allowExport">true</property>
                            </structure>
                            <structure>
                                <property name="name">deliveredHeader</property>
                                <expression name="expression" type="javascript">tr("Netto")</expression>
                                <property name="dataType">string</property>
                                <property name="allowExport">true</property>
                            </structure>
                        </list-property>
                        <column id="1657">
                            <property name="width">0.6875in</property>
                        </column>
                        <column id="1666">
                            <property name="repeat">1</property>
                        </column>
                        <column id="1659"/>
                        <column id="1661"/>
                        <column id="1662"/>
                        <column id="1663"/>
                        <header>
                            <row id="1584">
                                <cell id="1585">
                                    <data id="1866">
                                        <property name="resultSetColumn">categoryHeader</property>
                                    </data>
                                </cell>
                                <cell id="1603">
                                    <data id="1867">
                                        <property name="resultSetColumn">mailingHeader</property>
                                    </data>
                                </cell>
                                <cell id="1589">
                                    <data id="1868">
                                        <property name="resultSetColumn">targetsHeader</property>
                                    </data>
                                </cell>
                                <cell id="1593">
                                    <data id="1869">
                                        <property name="resultSetColumn">valueHeader</property>
                                    </data>
                                </cell>
                                <cell id="1595">
                                    <data id="1870">
                                        <property name="resultSetColumn">rateHeader</property>
                                    </data>
                                </cell>
                                <cell id="1597">
                                    <data id="1871">
                                        <property name="resultSetColumn">deliveredHeader</property>
                                    </data>
                                </cell>
                            </row>
                        </header>
                        <group id="1767">
                            <property name="groupName">CategoryGroup</property>
                            <expression name="keyExpr" type="javascript">row["category_index"]</expression>
                            <structure name="toc">
                                <expression name="expressionValue" type="javascript">row["category"]</expression>
                            </structure>
                            <property name="hideDetail">false</property>
                            <list-property name="sort">
                                <structure>
                                    <expression name="key" type="javascript">getKeyFiguresRowPosition(row["categoryKey"], row["category_index"])</expression>
                                    <property name="direction">asc</property>
                                    <property name="strength">-1</property>
                                </structure>
                            </list-property>
                        </group>
                        <group id="1799">
                            <property name="groupName">OptGroup</property>
                            <expression name="keyExpr" type="javascript">row["groupId"]</expression>
                            <structure name="toc">
                                <expression name="expressionValue" type="javascript">row["groupId"]</expression>
                            </structure>
                            <property name="hideDetail">true</property>
                            <list-property name="sort">
                                <structure>
                                    <expression name="key" type="javascript">getCrossTableColumnPosition(row["groupId"])</expression>
                                    <property name="direction">asc</property>
                                    <property name="strength">-1</property>
                                </structure>
                            </list-property>
                            <header>
                                <row id="1831">
                                    <cell id="1832">
                                        <data id="1847">
                                            <property name="resultSetColumn">category</property>
                                        </data>
                                    </cell>
                                    <cell id="1841">
                                        <data id="1848">
                                            <property name="resultSetColumn">optGroupName</property>
                                        </data>
                                    </cell>
                                    <cell id="1834">
                                        <data id="1849">
                                            <property name="resultSetColumn">targetgroup</property>
                                        </data>
                                    </cell>
                                    <cell id="1836">
                                        <data id="1850">
                                            <list-property name="visibility">
                                                <structure>
                                                    <property name="format">all</property>
                                                    <expression name="valueExpr" type="javascript">row["value_agr"] &lt; 0</expression>
                                                </structure>
                                            </list-property>
                                            <property name="resultSetColumn">value_agr</property>
                                        </data>
                                    </cell>
                                    <cell id="1837">
                                        <text-data id="1858">
                                            <list-property name="visibility">
                                                <structure>
                                                    <property name="format">all</property>
                                                    <expression name="valueExpr" type="javascript">row["value_agr"] >= 0</expression>
                                                </structure>
                                            </list-property>
                                            <expression name="valueExpr">tr("NotAvailableShort")</expression>
                                            <property name="contentType">html</property>
                                        </text-data>
                                        <data id="1851">
                                            <structure name="numberFormat">
                                                <property name="category">Custom</property>
                                                <property name="pattern">(0.0%)</property>
                                            </structure>
                                            <list-property name="visibility">
                                                <structure>
                                                    <property name="format">all</property>
                                                    <expression name="valueExpr" type="javascript">row["value_agr"] &lt; 0</expression>
                                                </structure>
                                            </list-property>
                                            <property name="resultSetColumn">rate_agr</property>
                                        </data>
                                    </cell>
                                    <cell id="1838">
                                        <text-data id="1859">
                                            <list-property name="visibility">
                                                <structure>
                                                    <property name="format">all</property>
                                                    <expression name="valueExpr" type="javascript">row["delivered_rate_agr"] >= 0</expression>
                                                </structure>
                                            </list-property>
                                            <expression name="valueExpr">tr("NotAvailableShort")</expression>
                                            <property name="contentType">html</property>
                                        </text-data>
                                        <data id="1852">
                                            <structure name="numberFormat">
                                                <property name="category">Custom</property>
                                                <property name="pattern">0.00%</property>
                                            </structure>
                                            <list-property name="visibility">
                                                <structure>
                                                    <property name="format">all</property>
                                                    <expression name="valueExpr" type="javascript">row["delivered_rate_agr"] &lt; 0</expression>
                                                </structure>
                                            </list-property>
                                            <property name="resultSetColumn">delivered_rate_agr</property>
                                        </data>
                                    </cell>
                                </row>
                            </header>
                        </group>
                        <footer>
                            <row id="1642">
                                <cell id="1643"/>
                                <cell id="1652"/>
                                <cell id="1645"/>
                                <cell id="1647"/>
                                <cell id="1648"/>
                                <cell id="1649"/>
                            </row>
                        </footer>
                    </table>
                </cell>
            </row>
        </grid>
    </body>
    <list-property name="images">
        <structure>
            <property name="name">ok_icon.png</property>
            <property name="type">image/png</property>
            <property name="data">
                iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAAXNSR0IArs4c6QAAAAZiS0dEAP8A/wD/
                oL2nkwAAAAlwSFlzAAALEwAACxMBAJqcGAAAAZBJREFUOMutk7FLAlEcxz+mbZZ0YOGNQtThIujiKU1x
                JI0GB44R/QNCBM2BCA2tIY6Cg63G0ajeJLiIhdCoUHB46ZZ2LXdypTaUv+XBe7/v5/d7v/d9Hsuy+E/4
                fm4k6lkvoACnwAkwBB6BEqDpqfLUne9xd5CoZ/eApuQPC5mQwvHOAcOPdxpGm+pAozt+MQBZT5Wf5wCJ
                enbPy9rT5e4ZsUCESr9Gpf/A1vomSlBGFdO0zA75XpEpn/sOxGNZltP269XuuRDwbXDRvVl434KUw5yM
                uO7dGcC2nipP1+wzRfKHhVggslQMcNG9IRaIIPnDgj0nHMBpJqRQ6deWivVUGYBKv0YmpGAPeQY4TApR
                tLfmr2IA7a1JUogCHLoBcwJH5KyJenYh3AE8Now2SlD+lrxIrARlGkYb2xszQKk60FDFtNsTCyurYprq
                QMM21gygdccvRsvsUJBycxD3M7bMjmMobQaw7Snne0XMyYj7+C2qeATA1vomqnjEffwWczIi3ytiu3G6
                Wiuv5DP9Jb4A3I7DAQFff4QAAAAASUVORK5CYII=
</property>
        </structure>
    </list-property>
</report>
