<?xml version="1.0" encoding="UTF-8"?>
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.24" id="1">
    <property name="createdBy">Eclipse BIRT Designer Version 4.13.0.v202303021806</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">MailingComparisionDataCube.CompanyDescriptionDataSet.x</property>
            <property name="type">integer</property>
            <property name="isVisible">false</property>
        </structure>
        <structure>
            <property name="name">MailingComparisionDataCube.CompanyDescriptionDataSet.y</property>
            <property name="type">integer</property>
            <property name="isVisible">false</property>
        </structure>
        <structure>
            <property name="name">MailingComparisionDataCube.categoryGroup.NewTabularHierarchy.x</property>
            <property name="type">integer</property>
            <property name="isVisible">false</property>
        </structure>
        <structure>
            <property name="name">MailingComparisionDataCube.categoryGroup.NewTabularHierarchy.y</property>
            <property name="type">integer</property>
            <property name="isVisible">false</property>
        </structure>
        <structure>
            <property name="name">MailingComparisionDataCube.CompanyDescriptionDataSet.width</property>
            <property name="type">integer</property>
            <property name="isVisible">false</property>
        </structure>
        <structure>
            <property name="name">MailingComparisionDataCube.CompanyDescriptionDataSet.height</property>
            <property name="type">integer</property>
            <property name="isVisible">false</property>
        </structure>
        <structure>
            <property name="name">MailingComparisionDataCube.categoryGroup.NewTabularHierarchy.width</property>
            <property name="type">integer</property>
            <property name="isVisible">false</property>
        </structure>
        <structure>
            <property name="name">MailingComparisionDataCube.categoryGroup.NewTabularHierarchy.height</property>
            <property name="type">integer</property>
            <property name="isVisible">false</property>
        </structure>
        <structure>
            <property name="name">MailingComparisionDataCube.mailingGroup.NewTabularHierarchy1.x</property>
            <property name="type">integer</property>
            <property name="isVisible">false</property>
        </structure>
        <structure>
            <property name="name">MailingComparisionDataCube.mailingGroup.NewTabularHierarchy1.y</property>
            <property name="type">integer</property>
            <property name="isVisible">false</property>
        </structure>
        <structure>
            <property name="name">MailingComparisionDataCube.MailingCompareDataSet.x</property>
            <property name="type">integer</property>
            <property name="isVisible">false</property>
        </structure>
        <structure>
            <property name="name">MailingComparisionDataCube.MailingCompareDataSet.y</property>
            <property name="type">integer</property>
            <property name="isVisible">false</property>
        </structure>
        <structure>
            <property name="name">Data Cube.MailingCompareDataSet.x</property>
            <property name="type">integer</property>
            <property name="isVisible">false</property>
        </structure>
        <structure>
            <property name="name">Data Cube.MailingCompareDataSet.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="MailingComparisionDataCube.CompanyDescriptionDataSet.x">168</property>
    <property name="MailingComparisionDataCube.CompanyDescriptionDataSet.y">31</property>
    <property name="MailingComparisionDataCube.categoryGroup.NewTabularHierarchy.x">318</property>
    <property name="MailingComparisionDataCube.categoryGroup.NewTabularHierarchy.y">123</property>
    <property name="MailingComparisionDataCube.CompanyDescriptionDataSet.width">150</property>
    <property name="MailingComparisionDataCube.CompanyDescriptionDataSet.height">200</property>
    <property name="MailingComparisionDataCube.categoryGroup.NewTabularHierarchy.width">150</property>
    <property name="MailingComparisionDataCube.categoryGroup.NewTabularHierarchy.height">200</property>
    <property name="MailingComparisionDataCube.mailingGroup.NewTabularHierarchy1.x">7</property>
    <property name="MailingComparisionDataCube.mailingGroup.NewTabularHierarchy1.y">117</property>
    <property name="MailingComparisionDataCube.MailingCompareDataSet.x">135</property>
    <property name="MailingComparisionDataCube.MailingCompareDataSet.y">80</property>
    <property name="Data Cube.MailingCompareDataSet.x">135</property>
    <property name="Data Cube.MailingCompareDataSet.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.java.lang);

selectedMailings = null;
selectedTargets = null;

if (params["selectedMailings"] != null ) {
	selectedMailings = params["selectedMailings"].value;
}

if (params["selectedTargets"] != null ) {
	selectedTargets = params["selectedTargets"].value;
}

mailingCompareDataSet = new Packages.com.agnitas.reporting.birt.external.dataset.MailingCompareDataSet();
tempTableIds = mailingCompareDataSet.prepareReport(selectedMailings, params["companyID"]);
reportContext.setPersistentGlobalVariable("tempTableIds", tempTableIds);

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

heightPerTG = 24;
baseHeight = 27;
if(reportContext.getOutputFormat() == "pdf") {
	heightPerTG = 29;
} 

if(reportContext.getOutputFormat() != "pdf") {
	reportContext.getReportRunnable().designHandle.getDesignHandle().findElement("reportParameters").drop();
}

if(reportContext.getOutputFormat() != "csv" ) {
	reportContext.getReportRunnable().designHandle.getDesignHandle().findElement("csvData").drop();
}

if(reportContext.getOutputFormat() == "csv" ) {
	reportContext.getReportRunnable().designHandle.getDesignHandle().findElement("charts").drop();
}     	

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 mailingInfo = {}; // populated in MailingBaseInfoDataSet open

var chartPalette = [
    "#0071B9",
    "#009BFF",
    "#64C3FF",
    "#00558A",
    "#92D050",
    "#69A129",
    "#41641A",
    "#009999",
    "#006464",
    "#7C00A8"
];

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

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

// 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 formatPercent(percent) {
	return new Packages.java.text.DecimalFormat("##0.0").format(percent);
}

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

function getColor(index) {
	return translateColor(new String(getPaletteColor(index)));
}

function translateColor(colorRgb) {
	var red = "0x" + colorRgb.substring(1, 3);
	var green = "0x" + colorRgb.substring(3, 5);
	var blue = "0x" + colorRgb.substring(5);
	return ColorDefinitionImpl.create(red, green, blue);
}

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);
	}
}

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

function getCategoryNameByKey(categoryKey) {
	switch (categoryKey) {
		case CommonKeys.CLICKER_PC_AND_MOBILE:
			return tr("statistic.clicker.multiple");
		case CommonKeys.OPENERS_PC_AND_MOBILE:
			return tr("report.opens.pc.and.mobileWithNote");
		case CommonKeys.OPENERS_INVISIBLE:
			return  tr("statistic.opener.invisible") + "²";
		case CommonKeys.OPENERS_MEASURED:
			return tr("statistic.opener.measure") + "¹";
	    case CommonKeys.OPENERS_PROXY:
			return tr("statistic.opener.proxy");
	    case CommonKeys.SOFT_BOUNCES_UNDELIVERABLE:
	        return tr("report.softbounces.undeliverable").replace("⁷", "³");
		default:
			return tr(categoryKey);
	}
}

reportContext.setGlobalVariable("mailingSummaryDataDefinition", mailingSummaryDataDefinition);
reportContext.setGlobalVariable("hasPercentageRepresentationFunction", hasPercentageRepresentation);
reportContext.setGlobalVariable("getKeyFiguresRowPositionFunction", getKeyFiguresRowPosition);
reportContext.setGlobalVariable("getColorFunction", getColor);
reportContext.setGlobalVariable("tr", tr);
reportContext.setGlobalVariable("getCategoryNameByKeyFunction", getCategoryNameByKey);
reportContext.setGlobalVariable("formatPercentFunction", formatPercent);
reportContext.setGlobalVariable("mailingInfo", mailingInfo);]]></method>
    <method name="afterRender"><![CDATA[mailingCompareDataSet.dropTempTables(reportContext.getPersistentGlobalVariable("tempTableIds"));
]]></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="selectedMailings" id="417">
            <property name="valueType">static</property>
            <property name="isRequired">false</property>
            <property name="dataType">string</property>
            <property name="distinct">true</property>
            <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="targetID" id="773">
            <property name="valueType">static</property>
            <property name="dataType">integer</property>
            <property name="distinct">true</property>
            <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="selectedTargets" id="1144">
            <property name="valueType">static</property>
            <property name="isRequired">false</property>
            <property name="dataType">string</property>
            <property name="distinct">true</property>
            <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="recipientsType" id="1145">
            <property name="valueType">static</property>
            <property name="dataType">string</property>
            <property name="distinct">true</property>
            <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="darkmode" id="2832">
            <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="CompanyDescriptionDataSet" id="248">
            <list-property name="resultSetHints">
                <structure>
                    <property name="position">1</property>
                    <property name="name">name</property>
                    <property name="dataType">string</property>
                </structure>
            </list-property>
            <list-property name="columnHints">
                <structure>
                    <property name="columnName">name</property>
                </structure>
            </list-property>
            <structure name="cachedMetaData">
                <list-property name="resultSet">
                    <structure>
                        <property name="position">1</property>
                        <property name="name">name</property>
                        <property name="dataType">string</property>
                    </structure>
                </list-property>
            </structure>
            <property name="dataSource">DummyDataSource</property>
            <method name="open"><![CDATA[companyDescriptionDataSet = new Packages.com.agnitas.reporting.birt.external.dataset.CompanyDescriptionDataSet();
valueList = companyDescriptionDataSet.getCompanyDescription (params["companyID"]);
currentrow = 0;]]></method>
            <method name="fetch"><![CDATA[if( currentrow < valueList.size() ) {
	row["name"] = valueList.get(currentrow);
	currentrow++;
	return true;
}
return false;]]></method>
        </script-data-set>
        <script-data-set name="MailingCompareCsvDataSet" id="2624">
            <list-property name="resultSetHints">
                <structure>
                    <property name="position">1</property>
                    <property name="name">mailing_id</property>
                    <property name="dataType">integer</property>
                </structure>
                <structure>
                    <property name="position">2</property>
                    <property name="name">mailing_name</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">3</property>
                    <property name="name">target_id</property>
                    <property name="dataType">integer</property>
                </structure>
                <structure>
                    <property name="position">4</property>
                    <property name="name">target_name</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">5</property>
                    <property name="name">sent_value</property>
                    <property name="dataType">integer</property>
                </structure>
                <structure>
                    <property name="position">6</property>
                    <property name="name">delivered_value</property>
                    <property name="dataType">integer</property>
                </structure>
                <structure>
                    <property name="position">7</property>
                    <property name="name">openers_value</property>
                    <property name="dataType">integer</property>
                </structure>
                <structure>
                    <property name="position">8</property>
                    <property name="name">openers_rate</property>
                    <property name="dataType">float</property>
                </structure>
                <structure>
                    <property name="position">9</property>
                    <property name="name">clicking_value</property>
                    <property name="dataType">integer</property>
                </structure>
                <structure>
                    <property name="position">10</property>
                    <property name="name">clicking_rate</property>
                    <property name="dataType">float</property>
                </structure>
                <structure>
                    <property name="position">11</property>
                    <property name="name">signedoff_value</property>
                    <property name="dataType">integer</property>
                </structure>
                <structure>
                    <property name="position">12</property>
                    <property name="name">signedoff_rate</property>
                    <property name="dataType">float</property>
                </structure>
                <structure>
                    <property name="position">13</property>
                    <property name="name">bounces_value</property>
                    <property name="dataType">integer</property>
                </structure>
                <structure>
                    <property name="position">14</property>
                    <property name="name">bounces_rate</property>
                    <property name="dataType">float</property>
                </structure>
                <structure>
                    <property name="position">15</property>
                    <property name="name">revenue_value</property>
                    <property name="dataType">integer</property>
                </structure>
            </list-property>
            <list-property name="columnHints">
                <structure>
                    <property name="columnName">mailing_id</property>
                </structure>
                <structure>
                    <property name="columnName">mailing_name</property>
                </structure>
                <structure>
                    <property name="columnName">target_id</property>
                </structure>
                <structure>
                    <property name="columnName">target_name</property>
                </structure>
                <structure>
                    <property name="columnName">sent_value</property>
                </structure>
                <structure>
                    <property name="columnName">delivered_value</property>
                </structure>
                <structure>
                    <property name="columnName">openers_value</property>
                </structure>
                <structure>
                    <property name="columnName">openers_rate</property>
                </structure>
                <structure>
                    <property name="columnName">clicking_value</property>
                </structure>
                <structure>
                    <property name="columnName">clicking_rate</property>
                </structure>
                <structure>
                    <property name="columnName">signedoff_value</property>
                </structure>
                <structure>
                    <property name="columnName">signedoff_rate</property>
                </structure>
                <structure>
                    <property name="columnName">bounces_value</property>
                </structure>
                <structure>
                    <property name="columnName">bounces_rate</property>
                </structure>
                <structure>
                    <property name="columnName">revenue_value</property>
                </structure>
            </list-property>
            <structure name="cachedMetaData">
                <list-property name="resultSet">
                    <structure>
                        <property name="position">1</property>
                        <property name="name">mailing_id</property>
                        <property name="dataType">integer</property>
                    </structure>
                    <structure>
                        <property name="position">2</property>
                        <property name="name">mailing_name</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">3</property>
                        <property name="name">target_id</property>
                        <property name="dataType">integer</property>
                    </structure>
                    <structure>
                        <property name="position">4</property>
                        <property name="name">target_name</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">5</property>
                        <property name="name">sent_value</property>
                        <property name="dataType">integer</property>
                    </structure>
                    <structure>
                        <property name="position">6</property>
                        <property name="name">delivered_value</property>
                        <property name="dataType">integer</property>
                    </structure>
                    <structure>
                        <property name="position">7</property>
                        <property name="name">openers_value</property>
                        <property name="dataType">integer</property>
                    </structure>
                    <structure>
                        <property name="position">8</property>
                        <property name="name">openers_rate</property>
                        <property name="dataType">float</property>
                    </structure>
                    <structure>
                        <property name="position">9</property>
                        <property name="name">clicking_value</property>
                        <property name="dataType">integer</property>
                    </structure>
                    <structure>
                        <property name="position">10</property>
                        <property name="name">clicking_rate</property>
                        <property name="dataType">float</property>
                    </structure>
                    <structure>
                        <property name="position">11</property>
                        <property name="name">signedoff_value</property>
                        <property name="dataType">integer</property>
                    </structure>
                    <structure>
                        <property name="position">12</property>
                        <property name="name">signedoff_rate</property>
                        <property name="dataType">float</property>
                    </structure>
                    <structure>
                        <property name="position">13</property>
                        <property name="name">bounces_value</property>
                        <property name="dataType">integer</property>
                    </structure>
                    <structure>
                        <property name="position">14</property>
                        <property name="name">bounces_rate</property>
                        <property name="dataType">float</property>
                    </structure>
                    <structure>
                        <property name="position">15</property>
                        <property name="name">revenue_value</property>
                        <property name="dataType">integer</property>
                    </structure>
                </list-property>
            </structure>
            <property name="dataSource">DummyDataSource</property>
            <method name="open"><![CDATA[if(reportContext.getOutputFormat() == "csv" ) {
	mailingCompareCsvDataSet = new Packages.com.agnitas.reporting.birt.external.dataset.MailingCompareDataSet();
	mailingCompareCsvData = mailingCompareCsvDataSet.getCsvSummaryData(reportContext.getPersistentGlobalVariable("tempTableIds"));
	currentrow = 0;
}
]]></method>
            <method name="fetch"><![CDATA[if(reportContext.getOutputFormat() == "csv" ) {
	if(currentrow >= mailingCompareCsvData.size()) {
		return false;
	}
	
	row["mailing_id"] = mailingCompareCsvData.get(currentrow).getMailingId();
	row["mailing_name"] = mailingCompareCsvData.get(currentrow).getMailingNameFull();
	row["target_id"] = mailingCompareCsvData.get(currentrow).getTargetGroupId();
	if (mailingCompareCsvData.get(currentrow).getTargetGroupIndex() == 1 || mailingCompareCsvData.get(currentrow).getTargetGroupName() == "statistic.all_subscribers") {
		row["target_name"] = Packages.com.agnitas.messages.I18nString.getLocaleString("statistic.all_subscribers", reportContext.getLocale());
	} else {
		row["target_name"] = mailingCompareCsvData.get(currentrow).getTargetGroupName();
	}
	row["sent_value"] = mailingCompareCsvData.get(currentrow).getEmailsSentCount();
	row["delivered_value"] = mailingCompareCsvData.get(currentrow).getEmailsDeliveredCount();
	row["openers_value"] = mailingCompareCsvData.get(currentrow).getOpenersCount();
	row["openers_rate"] = mailingCompareCsvData.get(currentrow).getOpenersRate();
	row["clicking_value"] = mailingCompareCsvData.get(currentrow).getClickingCount();
	row["clicking_rate"] = mailingCompareCsvData.get(currentrow).getClickingRate();
	row["signedoff_value"] = mailingCompareCsvData.get(currentrow).getSignedoffCount();
	row["signedoff_rate"] = mailingCompareCsvData.get(currentrow).getSignedoffRate();
	row["bounces_value"] = mailingCompareCsvData.get(currentrow).getBouncesCount();
	row["bounces_rate"] = mailingCompareCsvData.get(currentrow).getBouncesRate();
	row["revenue_value"] = mailingCompareCsvData.get(currentrow).getRevenueCount();
	
	currentrow++;
	return true;
}
return false;]]></method>
        </script-data-set>
        <script-data-set name="MailingsBaseInfoDataSet" id="8647">
            <list-property name="resultSetHints">
                <structure>
                    <property name="position">1</property>
                    <property name="name">mailing_info_name</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">2</property>
                    <property name="name">mailing_info_description</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">3</property>
                    <property name="name">mailing_info_send_date</property>
                    <property name="dataType">string</property>
                </structure>
            </list-property>
            <list-property name="columnHints">
                <structure>
                    <property name="columnName">mailing_info_name</property>
                </structure>
                <structure>
                    <property name="columnName">mailing_info_description</property>
                </structure>
                <structure>
                    <property name="columnName">mailing_info_send_date</property>
                </structure>
            </list-property>
            <structure name="cachedMetaData">
                <list-property name="resultSet">
                    <structure>
                        <property name="position">1</property>
                        <property name="name">mailing_info_name</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">2</property>
                        <property name="name">mailing_info_description</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">3</property>
                        <property name="name">mailing_info_send_date</property>
                        <property name="dataType">string</property>
                    </structure>
                </list-property>
            </structure>
            <property name="dataSource">DummyDataSource</property>
            <method name="open"><![CDATA[importPackage(Packages.com.agnitas.reporting.birt.external.dataset);
mailingCompareDataSet = new Packages.com.agnitas.reporting.birt.external.dataset.MailingCompareDataSet();
mailingsBaseInfo = mailingCompareDataSet.getMailingsBaseInfo(params["selectedMailings"].value);

for (i = 0; i < mailingsBaseInfo.size(); i++) {
	mailingInfo[mailingsBaseInfo.get(i).getId()] = {
		"order": i,
		"name": mailingsBaseInfo.get(i).getShortname()
	};
}

currentrow = 0;
]]></method>
            <method name="fetch"><![CDATA[if(currentrow >= mailingsBaseInfo.size()) {
	return false;
}

row["mailing_info_name"] = mailingsBaseInfo.get(currentrow).getShortname();
row["mailing_info_description"] = mailingsBaseInfo.get(currentrow).getDescription();
row["mailing_info_send_date"] = formatDate(mailingsBaseInfo.get(currentrow).getSenddate());

currentrow++;
return true;
]]></method>
        </script-data-set>
        <script-data-set name="MailingsSummaryDataSet" id="644">
            <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">targetgroup_index</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">value_string</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">8</property>
                    <property name="name">deliveredRate</property>
                    <property name="dataType">float</property>
                </structure>
                <structure>
                    <property name="position">9</property>
                    <property name="name">categoryKey</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">10</property>
                    <property name="name">partial_value</property>
                    <property name="dataType">integer</property>
                </structure>
                <structure>
                    <property name="position">11</property>
                    <property name="name">mailingId</property>
                    <property name="dataType">integer</property>
                </structure>
                <structure>
                    <property name="position">12</property>
                    <property name="name">mailing_name</property>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="position">13</property>
                    <property name="name">send_date</property>
                    <property name="dataType">date</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">targetgroup_index</property>
                </structure>
                <structure>
                    <property name="columnName">value</property>
                </structure>
                <structure>
                    <property name="columnName">rate</property>
                </structure>
                <structure>
                    <property name="columnName">value_string</property>
                </structure>
                <structure>
                    <property name="columnName">deliveredRate</property>
                </structure>
                <structure>
                    <property name="columnName">categoryKey</property>
                </structure>
                <structure>
                    <property name="columnName">partial_value</property>
                </structure>
                <structure>
                    <property name="columnName">mailingId</property>
                </structure>
                <structure>
                    <property name="columnName">mailing_name</property>
                </structure>
                <structure>
                    <property name="columnName">send_date</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">targetgroup_index</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">value_string</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">8</property>
                        <property name="name">deliveredRate</property>
                        <property name="dataType">float</property>
                    </structure>
                    <structure>
                        <property name="position">9</property>
                        <property name="name">categoryKey</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">10</property>
                        <property name="name">partial_value</property>
                        <property name="dataType">integer</property>
                    </structure>
                    <structure>
                        <property name="position">11</property>
                        <property name="name">mailingId</property>
                        <property name="dataType">integer</property>
                    </structure>
                    <structure>
                        <property name="position">12</property>
                        <property name="name">mailing_name</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">13</property>
                        <property name="name">send_date</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);
mailingsSummaryData = mailingCompareDataSet.getData(reportContext.getPersistentGlobalVariable("tempTableIds"));
currentrow = 0;

max = 0;
for (i = 0; i < mailingsSummaryData.size(); i++) {
	categoryIndex = mailingsSummaryData.get(i).getCategoryindex();
	value = mailingsSummaryData.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("totalSents", {}); // mailing id to sent number
]]></method>
            <method name="fetch"><![CDATA[importPackage(Packages.com.agnitas.messages);
importPackage(Packages.com.agnitas.reporting.birt.external.dataset);

if( currentrow >= mailingsSummaryData.size() ) {
	return false;
}
currentRowData = mailingsSummaryData.get(currentrow);

row["categoryKey"] = currentRowData.getCategory();
row["category"] = getCategoryNameByKey(currentRowData.getCategory());
row["category_index"] = currentRowData.getCategoryindex();

// do some i18n stuff
//if( currentRowData.getTargetGroupIndex() == 1) {
	if (currentRowData.getCategoryindex() == CommonKeys.DELIVERED_EMAILS_INDEX) {
		totalSents = reportContext.getGlobalVariable("totalSents")
		totalSents[currentRowData.getMailingId()] = parseInt(currentRowData.getCount());
	}
//}

reportContext.setGlobalVariable("totalSents", totalSents);

row["mailingId"] = currentRowData.getMailingId();
row["mailing_name"] = currentRowData.getMailingName();
row["send_date"] = currentRowData.getSendDate();
row["targetgroup_index"] = currentRowData.getTargetGroupIndex();
row["value"] = currentRowData.getCount();
row["rate"] = currentRowData.getRate();
if (row["rate"] == -1) {
    row["rate"] = 0;
}

currentrow++;
return true;
]]></method>
            <method name="close"><![CDATA[mailingSummaryClass = null;
mailingSummaryData = null;]]></method>
        </script-data-set>
    </data-sets>
    <cubes>
        <tabular-cube name="MailingsSummaryDataCube" id="8693">
            <property name="dimensions">
                <tabular-dimension name="CGroup" id="8694">
                    <property name="defaultHierarchy">NewTabularHierarchy3</property>
                    <property name="hierarchies">
                        <tabular-hierarchy name="NewTabularHierarchy3" id="8695">
                            <property name="levels">
                                <tabular-level name="category_index" id="8696">
                                    <property name="dataType">integer</property>
                                    <property name="levelType">dynamic</property>
                                    <list-property name="attributes">
                                        <structure>
                                            <property name="name">category</property>
                                            <property name="dataType">string</property>
                                        </structure>
                                        <structure>
                                            <property name="name">categoryKey</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="MGroup" id="8697">
                    <property name="defaultHierarchy">NewTabularHierarchy4</property>
                    <property name="hierarchies">
                        <tabular-hierarchy name="NewTabularHierarchy4" id="8698">
                            <property name="levels">
                                <tabular-level name="mailingId" id="8699">
                                    <property name="dataType">integer</property>
                                    <property name="levelType">dynamic</property>
                                    <list-property name="attributes">
                                        <structure>
                                            <property name="name">mailing_name</property>
                                            <property name="dataType">string</property>
                                        </structure>
                                        <structure>
                                            <property name="name">send_date</property>
                                            <property name="dataType">date</property>
                                        </structure>
                                    </list-property>
                                    <property name="columnName">mailingId</property>
                                </tabular-level>
                            </property>
                        </tabular-hierarchy>
                    </property>
                </tabular-dimension>
            </property>
            <property name="measureGroups">
                <tabular-measure-group name="Summary Field1" id="8700">
                    <property name="measures">
                        <tabular-measure name="value1" id="8701">
                            <property name="function">first</property>
                            <property name="isCalculated">false</property>
                            <expression name="measureExpression" type="javascript">dataSetRow["value"]</expression>
                            <property name="dataType">integer</property>
                            <property name="isVisible">true</property>
                        </tabular-measure>
                        <tabular-measure name="rate1" id="8702">
                            <property name="function">first</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>
                    </property>
                </tabular-measure-group>
            </property>
            <property name="dataSet">MailingsSummaryDataSet</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="charts" id="2833">
            <property name="style">block-table</property>
            <property name="width">100%</property>
            <column id="2834"/>
            <row id="8650">
                <cell id="8651">
                    <property name="style">full-width</property>
                    <grid id="8674">
                        <property name="style">block-table</property>
                        <column id="8675"/>
                        <column id="8676"/>
                        <row id="8677">
                            <cell id="8678">
                                <property name="style">half-width</property>
                                <table id="8652">
                                    <property name="style">table table-striped</property>
                                    <property name="dataSet">MailingsBaseInfoDataSet</property>
                                    <list-property name="boundDataColumns">
                                        <structure>
                                            <property name="name">mailing_info_name</property>
                                            <text-property name="displayName">mailing_info_name</text-property>
                                            <expression name="expression" type="javascript">dataSetRow["mailing_info_name"]</expression>
                                            <property name="dataType">string</property>
                                        </structure>
                                        <structure>
                                            <property name="name">mailing_info_description</property>
                                            <text-property name="displayName">mailing_info_description</text-property>
                                            <expression name="expression" type="javascript">dataSetRow["mailing_info_description"]</expression>
                                            <property name="dataType">string</property>
                                        </structure>
                                        <structure>
                                            <property name="name">mailing_info_send_date</property>
                                            <text-property name="displayName">mailing_info_send_date</text-property>
                                            <expression name="expression" type="javascript">dataSetRow["mailing_info_send_date"]</expression>
                                            <property name="dataType">string</property>
                                        </structure>
                                    </list-property>
                                    <list-property name="sort">
                                        <structure>
                                            <expression name="key" type="javascript">row["mailing_info_send_date"]</expression>
                                            <property name="direction">desc</property>
                                            <property name="strength">-1</property>
                                        </structure>
                                    </list-property>
                                    <column id="8671"/>
                                    <column id="8672"/>
                                    <column id="8673"/>
                                    <header>
                                        <row id="8653">
                                            <property name="style">table-head</property>
                                            <cell id="8654">
                                                <text-data id="8680">
                                                    <expression name="valueExpr">tr("Mailing")</expression>
                                                    <property name="contentType">html</property>
                                                </text-data>
                                            </cell>
                                            <cell id="8656">
                                                <text-data id="8681">
                                                    <expression name="valueExpr">tr("Description")</expression>
                                                    <property name="contentType">html</property>
                                                </text-data>
                                            </cell>
                                            <cell id="8658">
                                                <text-data id="8682">
                                                    <expression name="valueExpr">tr("mailing.senddate")</expression>
                                                    <property name="contentType">html</property>
                                                </text-data>
                                            </cell>
                                        </row>
                                    </header>
                                    <detail>
                                        <row id="8660">
                                            <cell id="8661">
                                                <data id="8662">
                                                    <property name="resultSetColumn">mailing_info_name</property>
                                                </data>
                                            </cell>
                                            <cell id="8663">
                                                <data id="8664">
                                                    <property name="resultSetColumn">mailing_info_description</property>
                                                </data>
                                            </cell>
                                            <cell id="8665">
                                                <data id="8666">
                                                    <property name="resultSetColumn">mailing_info_send_date</property>
                                                </data>
                                            </cell>
                                        </row>
                                    </detail>
                                </table>
                            </cell>
                            <cell id="8679"/>
                        </row>
                    </grid>
                </cell>
            </row>
            <row id="8683">
                <cell id="8684">
                    <property name="style">full-width</property>
                    <grid id="8685">
                        <property name="style">block-table</property>
                        <column id="8686"/>
                        <column id="8687"/>
                        <row id="8771">
                            <cell id="8772">
                                <property name="style">half-width</property>
                                <text-data id="8767">
                                    <property name="style">headline</property>
                                    <expression name="valueExpr">tr("target.Target") + ": " + tr("statistic.all_subscribers")</expression>
                                    <property name="contentType">html</property>
                                </text-data>
                            </cell>
                            <cell id="8773">
                                <property name="style">half-width</property>
                            </cell>
                        </row>
                        <row id="8688">
                            <cell id="8689">
                                <property name="style">half-width</property>
                                <grid id="8761">
                                    <property name="style">table</property>
                                    <column id="8762"/>
                                    <row id="8763">
                                        <cell id="8764">
                                            <extended-item extensionName="Chart" name="comparisonChart" id="8774">
                                                <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>
      <Triggers>
        <Condition>onmouseover</Condition>
        <Action>
          <Type>Highlight</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;);

	// 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 currentValue = values[0]; // series value
	var mailingId = new Number(values[1]); // series value
	
	if (!(dph.getIndex() in ignoredBarIndexes)) {
		// code to display the value with percent
		var totalSent = parseInt(reportContext.getGlobalVariable(&quot;totalSents&quot;)[mailingId]);
		totalSentNumber = new Number(totalSent);
		
		curValue = Packages.java.text.NumberFormat.getNumberInstance(getLocale()).parse(currentValue);
		if (totalSentNumber > 0) {
			percent = (curValue / totalSentNumber) * 100;
		} else {
			percent = 0;
		}
		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 getColor = icsc.getExternalContext().getScriptable().getGlobalVariable(&quot;getColorFunction&quot;);
	var mailingInfo = icsc.getExternalContext().getScriptable().getGlobalVariable(&quot;mailingInfo&quot;);
	var color = getColor(mailingInfo[dph.getSeriesValue()][&quot;order&quot;]);
	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 getCategoryNameByKey = icsc.getExternalContext().getScriptable().getGlobalVariable(&quot;getCategoryNameByKeyFunction&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(getCategoryNameByKey(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 getColor = icsc.getExternalContext().getScriptable().getGlobalVariable(&quot;getColorFunction&quot;);

	var curr = lerh.getLabel().getCaption();
		
	var mailingId = curr.getValue();
	var mailingInfo = icsc.getExternalContext().getScriptable().getGlobalVariable(&quot;mailingInfo&quot;);
	var color = getColor(mailingInfo[mailingId][&quot;order&quot;]);
	lerh.getLabel().getCaption().setValue(StringUtils.abbreviate(mailingInfo[mailingId][&quot;name&quot;], 35));
	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);
}

function afterDataSetFilled(series, dataSet, icsc) {
	// Adjust chart heigth
	var mailingInfo = icsc.getExternalContext().getScriptable().getGlobalVariable(&quot;mailingInfo&quot;);
	var mailingsCount =	Object.keys(mailingInfo).length
	var categoriesCount = 12;
	var xAxisHeight = 15;
	var padding = 10 * 2;
	var spaceBetweenCategories = 5 * mailingsCount; // for unit-spacing = 20
	
	var seriesHeight = 17 * Math.ceil(mailingsCount/2);
	var barsHeight = categoriesCount * ((15 * mailingsCount) + spaceBetweenCategories);
	
	icsc.getChartInstance().getBlock().getBounds().setHeight(seriesHeight + barsHeight + xAxisHeight + padding);
}
</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;mailingId&quot;]</Definition>
          <Grouping>
            <GroupingUnit>String</GroupingUnit>
            <GroupingInterval>1.0</GroupingInterval>
            <GroupType>Numeric</GroupType>
          </Grouping>
        </Query>
        <SeriesPalette>
          <Entries xsi:type="attribute:ColorDefinition">
            <Transparency>255</Transparency>
            <Red>124</Red>
            <Green>0</Green>
            <Blue>168</Blue>
          </Entries>
          <Entries xsi:type="attribute:ColorDefinition">
            <Transparency>255</Transparency>
            <Red>0</Red>
            <Green>100</Green>
            <Blue>100</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>105</Red>
            <Green>161</Green>
            <Blue>41</Blue>
          </Entries>
          <Entries xsi:type="attribute:ColorDefinition">
            <Transparency>255</Transparency>
            <Red>146</Red>
            <Green>208</Green>
            <Blue>80</Blue>
          </Entries>
          <Entries xsi:type="attribute:ColorDefinition">
            <Transparency>255</Transparency>
            <Red>0</Red>
            <Green>85</Green>
            <Blue>138</Blue>
          </Entries>
          <Entries xsi:type="attribute:ColorDefinition">
            <Transparency>255</Transparency>
            <Red>100</Red>
            <Green>195</Green>
            <Blue>255</Blue>
          </Entries>
          <Entries xsi:type="attribute:ColorDefinition">
            <Transparency>255</Transparency>
            <Red>0</Red>
            <Green>155</Green>
            <Blue>255</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>9.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;category_index&quot;] != CommonKeys.REVENUE_INDEX ? row[&quot;value&quot;] : row[&quot;value&quot;]/100</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>
              <FormatSpecifier xsi:type="attribute:JavaNumberFormatSpecifier">
                <Pattern></Pattern>
              </FormatSpecifier>
            </Components>
            <Prefix></Prefix>
            <Suffix></Suffix>
            <Separator>;</Separator>
          </DataPoint>
          <LabelPosition>Outside</LabelPosition>
          <Stacked>false</Stacked>
          <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>Ascending</Sorting>
        <SortKey>
          <Definition>row[&quot;send_date&quot;]</Definition>
        </SortKey>
        <SortStrength>-1</SortStrength>
      </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>false</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>true</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>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>
        <Min xsi:type="data:NumberDataElement">
          <Value>0.0</Value>
        </Min>
        <MinorGridsPerUnit>5</MinorGridsPerUnit>
        <ShowOutside>true</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>First</AggregateExpression>
      </Grouping>
      <Sorting>Descending</Sorting>
      <SortKey>
        <Definition>getKeyFiguresRowPosition(row[&quot;categoryKey&quot;], row[&quot;category_index&quot;])</Definition>
      </SortKey>
      <SortStrength>-1</SortStrength>
    </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>20.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="cubeFilter">
                                                    <filter-condition-element>
                                                        <expression name="expr" type="javascript">data["CGroup/category_index"] &lt;= CommonKeys.REVENUE_INDEX ||
data["CGroup/category_index"] == CommonKeys.OPENINGS_ANONYMOUS_INDEX ||
data["CGroup/category_index"] == CommonKeys.CLICKS_ANONYMOUS_INDEX</expression>
                                                        <property name="operator">is-true</property>
                                                    </filter-condition-element>
                                                </property>
                                                <property name="inheritColumns">true</property>
                                                <property name="marginTop">0px</property>
                                                <property name="marginBottom">0px</property>
                                                <property name="height">270pt</property>
                                                <property name="width">747px</property>
                                                <property name="dataSet">MailingsSummaryDataSet</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</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">targetgroup_index</property>
                                                        <text-property name="displayName">targetgroup_index</text-property>
                                                        <expression name="expression" type="javascript">dataSetRow["targetgroup_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">value_string</property>
                                                        <text-property name="displayName">value_string</text-property>
                                                        <expression name="expression" type="javascript">dataSetRow["value_string"]</expression>
                                                        <property name="dataType">string</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">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">partial_value</property>
                                                        <text-property name="displayName">partial_value</text-property>
                                                        <expression name="expression" type="javascript">dataSetRow["partial_value"]</expression>
                                                        <property name="dataType">integer</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">mailing_name</property>
                                                        <text-property name="displayName">mailing_name</text-property>
                                                        <expression name="expression" type="javascript">dataSetRow["mailing_name"]</expression>
                                                        <property name="dataType">string</property>
                                                    </structure>
                                                    <structure>
                                                        <property name="name">send_date</property>
                                                        <text-property name="displayName">send_date</text-property>
                                                        <expression name="expression" type="javascript">dataSetRow["send_date"]</expression>
                                                        <property name="dataType">date</property>
                                                    </structure>
                                                </list-property>
                                            </extended-item>
                                        </cell>
                                    </row>
                                </grid>
                            </cell>
                            <cell id="8690">
                                <property name="style">half-width</property>
                                <extended-item extensionName="Crosstab" extensionVersion="3.7.0" id="8691">
                                    <property name="cube">MailingsSummaryDataCube</property>
                                    <property name="measures">
                                        <extended-item extensionName="MeasureView" id="8714">
                                            <property name="measure">value1</property>
                                            <property name="detail">
                                                <extended-item extensionName="AggregationCell" id="8715">
                                                    <property name="aggregationOnRow">CGroup/category_index</property>
                                                    <property name="aggregationOnColumn">MGroup/mailingId</property>
                                                    <property name="textAlign">right</property>
                                                    <property name="content">
                                                        <data id="8716">
                                                            <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">dimension["CGroup"]["category_index"] == CommonKeys.REVENUE_INDEX</expression>
                                                                </structure>
                                                            </list-property>
                                                            <property name="resultSetColumn">value1_CGroup/category_index_MGroup/mailingId</property>
                                                        </data>
                                                        <data id="8733">
                                                            <structure name="numberFormat">
                                                                <property name="category">Fixed</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">dimension["CGroup"]["category_index"] != CommonKeys.REVENUE_INDEX</expression>
                                                                </structure>
                                                            </list-property>
                                                            <property name="resultSetColumn">Column Binding</property>
                                                        </data>
                                                    </property>
                                                </extended-item>
                                            </property>
                                            <property name="header">
                                                <extended-item extensionName="CrosstabCell" id="8717">
                                                    <property name="style">to-hide</property>
                                                </extended-item>
                                            </property>
                                        </extended-item>
                                        <extended-item extensionName="MeasureView" id="8721">
                                            <property name="measure">rate1</property>
                                            <property name="detail">
                                                <extended-item extensionName="AggregationCell" id="8722">
                                                    <property name="aggregationOnRow">CGroup/category_index</property>
                                                    <property name="aggregationOnColumn">MGroup/mailingId</property>
                                                    <property name="textAlign">right</property>
                                                    <property name="content">
                                                        <data id="8723">
                                                            <structure name="numberFormat">
                                                                <property name="category">Custom</property>
                                                                <property name="pattern">0.0%</property>
                                                            </structure>
                                                            <property name="resultSetColumn">rate1_CGroup/category_index_MGroup/mailingId</property>
                                                        </data>
                                                    </property>
                                                </extended-item>
                                            </property>
                                            <property name="header">
                                                <extended-item extensionName="CrosstabCell" id="8724">
                                                    <property name="style">to-hide</property>
                                                </extended-item>
                                            </property>
                                        </extended-item>
                                    </property>
                                    <property name="rows">
                                        <extended-item extensionName="CrosstabView" id="8703">
                                            <property name="views">
                                                <extended-item extensionName="DimensionView" id="8704">
                                                    <property name="dimension">CGroup</property>
                                                    <property name="levels">
                                                        <extended-item extensionName="LevelView" name="NewLevel View2" id="8705">
                                                            <property name="level">CGroup/category_index</property>
                                                            <property name="sort">
                                                                <sort-element>
                                                                    <expression name="key" type="javascript">getKeyFiguresRowPosition(dimension["CGroup"]["category_index"]["categoryKey"], dimension["CGroup"]["category_index"])</expression>
                                                                    <property name="direction">asc</property>
                                                                </sort-element>
                                                            </property>
                                                            <property name="member">
                                                                <extended-item extensionName="CrosstabCell" id="8706">
                                                                    <property name="content">
                                                                        <data name="category_index1" id="8707">
                                                                            <property name="textAlign">left</property>
                                                                            <property name="resultSetColumn">category_index</property>
                                                                        </data>
                                                                    </property>
                                                                </extended-item>
                                                            </property>
                                                        </extended-item>
                                                    </property>
                                                </extended-item>
                                            </property>
                                        </extended-item>
                                    </property>
                                    <property name="columns">
                                        <extended-item extensionName="CrosstabView" id="8709">
                                            <property name="views">
                                                <extended-item extensionName="DimensionView" id="8710">
                                                    <property name="dimension">MGroup</property>
                                                    <property name="levels">
                                                        <extended-item extensionName="LevelView" name="NewLevel View3" id="8711">
                                                            <property name="level">MGroup/mailingId</property>
                                                            <property name="sort">
                                                                <sort-element>
                                                                    <expression name="key" type="javascript">dimension["MGroup"]["mailingId"]["send_date"]</expression>
                                                                    <property name="direction">desc</property>
                                                                    <property name="strength">-1</property>
                                                                </sort-element>
                                                            </property>
                                                            <property name="member">
                                                                <extended-item extensionName="CrosstabCell" id="8712">
                                                                    <property name="content">
                                                                        <data name="mailingId" id="8713">
                                                                            <property name="resultSetColumn">mailingId</property>
                                                                        </data>
                                                                    </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="8719">
                                            <property name="content">
                                                <text-data id="8734">
                                                    <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">dimension["CGroup"]["category_index"] &lt;= CommonKeys.REVENUE_INDEX
|| dimension["CGroup"]["category_index"] == CommonKeys.OPENINGS_ANONYMOUS_INDEX
|| dimension["CGroup"]["category_index"] == CommonKeys.CLICKS_ANONYMOUS_INDEX</expression>
                                            <property name="operator">is-true</property>
                                        </filter-condition-element>
                                    </property>
                                    <list-property name="boundDataColumns">
                                        <structure>
                                            <property name="name">category_index</property>
                                            <expression name="expression" type="javascript">dimension["CGroup"]["category_index"]["category"]</expression>
                                            <property name="dataType">string</property>
                                        </structure>
                                        <structure>
                                            <property name="name">mailingId</property>
                                            <expression name="expression" type="javascript">dimension["MGroup"]["mailingId"]["mailing_name"]</expression>
                                            <property name="dataType">string</property>
                                        </structure>
                                        <structure>
                                            <property name="name">value1_CGroup/category_index_MGroup/mailingId</property>
                                            <property name="dataType">integer</property>
                                            <simple-property-list name="aggregateOn">
                                                <value>CGroup/category_index</value>
                                                <value>MGroup/mailingId</value>
                                            </simple-property-list>
                                            <property name="aggregateFunction">FIRST</property>
                                            <list-property name="arguments">
                                                <structure>
                                                    <property name="name">Expression</property>
                                                    <expression name="value" type="javascript">measure["value1"]</expression>
                                                </structure>
                                            </list-property>
                                        </structure>
                                        <structure>
                                            <property name="name">rate1_CGroup/category_index_MGroup/mailingId</property>
                                            <property name="dataType">float</property>
                                            <simple-property-list name="aggregateOn">
                                                <value>CGroup/category_index</value>
                                                <value>MGroup/mailingId</value>
                                            </simple-property-list>
                                            <property name="aggregateFunction">FIRST</property>
                                            <list-property name="arguments">
                                                <structure>
                                                    <property name="name">Expression</property>
                                                    <expression name="value" type="javascript">measure["rate1"]</expression>
                                                </structure>
                                            </list-property>
                                            <expression name="filterExpr" type="javascript">dimension["CGroup"]["category_index"] &lt; CommonKeys.REVENUE_INDEX
  &amp;&amp; hasPercentageRepresentation(dimension["CGroup"]["category_index"]["categoryKey"])</expression>
                                        </structure>
                                        <structure>
                                            <property name="name">Column Binding</property>
                                            <text-property name="displayName">revenue</text-property>
                                            <expression name="expression" type="javascript">data["value1_CGroup/category_index_MGroup/mailingId"] / 100</expression>
                                            <property name="dataType">float</property>
                                        </structure>
                                    </list-property>
                                    <property name="style">table table-striped</property>
                                </extended-item>
                            </cell>
                        </row>
                    </grid>
                </cell>
            </row>
            <row id="2835">
                <cell id="2836">
                    <property name="style">full-width</property>
                    <text-data id="1904">
                        <property name="style">footnote</property>
                        <property name="marginTop">0pt</property>
                        <expression name="valueExpr">tr("report.opens.measured.explanation").replace('[2]', '[1]')</expression>
                    </text-data>
                    <text-data id="1039">
                        <property name="style">footnote</property>
                        <expression name="valueExpr">tr("report.opens.invisible.explanation").replace("[3]", "[2]")</expression>
                    </text-data>
                    <text-data id="8776">
                        <property name="style">footnote</property>
                        <property name="marginTop">0pt</property>
                        <expression name="valueExpr">tr("statistic.withoutConfirmation.explanation").replace("[7]", "[3]")</expression>
                    </text-data>
                </cell>
            </row>
        </grid>
        <grid name="reportParameters" id="145">
            <property name="height">3.1354166666666665in</property>
            <property name="width">5.145833333333333in</property>
            <column id="146">
                <property name="width">2.1666666666666665in</property>
            </column>
            <column id="147">
                <property name="width">2.9791666666666665in</property>
            </column>
            <column id="2824">
                <property name="width">2pt</property>
            </column>
            <row id="148">
                <cell id="149">
                    <text-data id="163">
                        <expression name="valueExpr">Packages.com.agnitas.messages.I18nString.getLocaleString("report.parameters", reportContext.getLocale())</expression>
                    </text-data>
                </cell>
                <cell id="150"/>
                <cell id="2821"/>
            </row>
            <row id="244">
                <cell id="245">
                    <text-data id="253">
                        <expression name="valueExpr">Packages.com.agnitas.messages.I18nString.getLocaleString("settings.Company", reportContext.getLocale())</expression>
                    </text-data>
                </cell>
                <cell id="246">
                    <data id="249">
                        <property name="dataSet">CompanyDescriptionDataSet</property>
                        <list-property name="boundDataColumns">
                            <structure>
                                <property name="name">name</property>
                                <text-property name="displayName">name</text-property>
                                <expression name="expression">dataSetRow["name"]</expression>
                                <property name="dataType">string</property>
                            </structure>
                        </list-property>
                        <property name="resultSetColumn">name</property>
                    </data>
                </cell>
                <cell id="2822"/>
            </row>
            <row id="687">
                <cell id="688">
                    <text-data id="690">
                        <expression name="valueExpr">Packages.com.agnitas.messages.I18nString.getLocaleString("Date", reportContext.getLocale())</expression>
                    </text-data>
                </cell>
                <cell id="689">
                    <text-data id="697">
                        <expression name="valueExpr" type="javascript">new Date()</expression>
                        <property name="contentType">html</property>
                    </text-data>
                </cell>
                <cell id="2823"/>
            </row>
        </grid>
        <table name="csvData" id="2558">
            <property name="dataSet">MailingCompareCsvDataSet</property>
            <list-property name="boundDataColumns">
                <structure>
                    <property name="name">mailing_id</property>
                    <expression name="expression" type="javascript">dataSetRow["mailing_id"]</expression>
                    <property name="dataType">integer</property>
                </structure>
                <structure>
                    <property name="name">mailing_name</property>
                    <expression name="expression" type="javascript">dataSetRow["mailing_name"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">target_id</property>
                    <expression name="expression" type="javascript">dataSetRow["target_id"]</expression>
                    <property name="dataType">integer</property>
                </structure>
                <structure>
                    <property name="name">target_name</property>
                    <expression name="expression" type="javascript">dataSetRow["target_name"]</expression>
                    <property name="dataType">string</property>
                    <property name="allowExport">true</property>
                </structure>
                <structure>
                    <property name="name">sent_value</property>
                    <expression name="expression" type="javascript">dataSetRow["sent_value"]</expression>
                    <property name="dataType">integer</property>
                </structure>
                <structure>
                    <property name="name">openers_value</property>
                    <expression name="expression" type="javascript">dataSetRow["openers_value"]</expression>
                    <property name="dataType">integer</property>
                </structure>
                <structure>
                    <property name="name">openers_rate</property>
                    <expression name="expression" type="javascript">dataSetRow["openers_rate"]</expression>
                    <property name="dataType">float</property>
                </structure>
                <structure>
                    <property name="name">clicking_value</property>
                    <expression name="expression" type="javascript">dataSetRow["clicking_value"]</expression>
                    <property name="dataType">integer</property>
                </structure>
                <structure>
                    <property name="name">clicking_rate</property>
                    <expression name="expression" type="javascript">dataSetRow["clicking_rate"]</expression>
                    <property name="dataType">float</property>
                </structure>
                <structure>
                    <property name="name">signedoff_rate</property>
                    <expression name="expression" type="javascript">dataSetRow["signedoff_rate"]</expression>
                    <property name="dataType">float</property>
                </structure>
                <structure>
                    <property name="name">bounces_value</property>
                    <expression name="expression" type="javascript">dataSetRow["bounces_value"]</expression>
                    <property name="dataType">integer</property>
                </structure>
                <structure>
                    <property name="name">bounces_rate</property>
                    <expression name="expression" type="javascript">dataSetRow["bounces_rate"]</expression>
                    <property name="dataType">float</property>
                </structure>
                <structure>
                    <property name="name">revenue_value</property>
                    <expression name="expression" type="javascript">dataSetRow["revenue_value"]</expression>
                    <property name="dataType">integer</property>
                </structure>
                <structure>
                    <property name="name">signedoff_value</property>
                    <expression name="expression" type="javascript">dataSetRow["signedoff_value"]</expression>
                    <property name="dataType">integer</property>
                </structure>
                <structure>
                    <property name="name">delivered_value</property>
                    <expression name="expression" type="javascript">dataSetRow["delivered_value"]</expression>
                    <property name="dataType">float</property>
                    <property name="allowExport">true</property>
                </structure>
            </list-property>
            <list-property name="sort">
                <structure>
                    <expression name="key" type="javascript">row["mailing_id"]</expression>
                    <property name="direction">asc</property>
                    <property name="strength">0</property>
                </structure>
                <structure>
                    <expression name="key" type="javascript">row["target_id"]</expression>
                    <property name="direction">asc</property>
                    <property name="strength">1</property>
                </structure>
            </list-property>
            <column id="2585"/>
            <column id="2586"/>
            <column id="2587"/>
            <column id="2827"/>
            <column id="2588"/>
            <column id="2589"/>
            <column id="2590"/>
            <column id="2591"/>
            <column id="2592"/>
            <column id="2593"/>
            <column id="2594"/>
            <column id="2595"/>
            <column id="2596"/>
            <header>
                <row id="2659">
                    <cell id="2660">
                        <text-data id="8793">
                            <expression name="valueExpr">tr("Mailing")</expression>
                            <property name="contentType">auto</property>
                        </text-data>
                    </cell>
                    <cell id="2661">
                        <text-data id="8792">
                            <expression name="valueExpr">tr("birt.Target")</expression>
                            <property name="contentType">auto</property>
                        </text-data>
                    </cell>
                    <cell id="2662">
                        <text-data id="8788">
                            <expression name="valueExpr">tr("report.deliveredMails")</expression>
                            <property name="contentType">auto</property>
                        </text-data>
                    </cell>
                    <cell id="2825">
                        <text-data id="8787">
                            <expression name="valueExpr">tr("statistic.mails.delivered")</expression>
                            <property name="contentType">auto</property>
                        </text-data>
                    </cell>
                    <cell id="2663">
                        <text-data id="8785">
                            <expression name="valueExpr">tr("birt.report.opens")</expression>
                            <property name="contentType">auto</property>
                        </text-data>
                    </cell>
                    <cell id="2664">
                        <text-data id="8786">
                            <expression name="valueExpr">tr("birt.report.opens") + ' %'</expression>
                            <property name="contentType">auto</property>
                        </text-data>
                    </cell>
                    <cell id="2665">
                        <text-data id="8783">
                            <expression name="valueExpr">tr("statistic.clicker")</expression>
                            <property name="contentType">auto</property>
                        </text-data>
                    </cell>
                    <cell id="2666">
                        <text-data id="8784">
                            <expression name="valueExpr">tr("statistic.clicker") + ' %'</expression>
                            <property name="contentType">auto</property>
                        </text-data>
                    </cell>
                    <cell id="2667">
                        <text-data id="8782">
                            <expression name="valueExpr">tr("statistic.Opt_Outs")</expression>
                            <property name="contentType">auto</property>
                        </text-data>
                    </cell>
                    <cell id="2668">
                        <text-data id="8781">
                            <expression name="valueExpr">tr("statistic.Opt_Outs") + ' %'</expression>
                            <property name="contentType">auto</property>
                        </text-data>
                    </cell>
                    <cell id="2669">
                        <text-data id="8779">
                            <expression name="valueExpr">tr("statistic.Bounces")</expression>
                            <property name="contentType">auto</property>
                        </text-data>
                    </cell>
                    <cell id="2670">
                        <text-data id="8780">
                            <expression name="valueExpr">tr("statistic.Bounces") + ' %'</expression>
                            <property name="contentType">auto</property>
                        </text-data>
                    </cell>
                    <cell id="2671">
                        <text-data id="8778">
                            <expression name="valueExpr">tr("Revenue")</expression>
                            <property name="contentType">auto</property>
                        </text-data>
                    </cell>
                </row>
            </header>
            <detail>
                <row id="2599">
                    <cell id="2600">
                        <data id="2647">
                            <property name="resultSetColumn">mailing_name</property>
                        </data>
                    </cell>
                    <cell id="2601">
                        <data id="2648">
                            <property name="resultSetColumn">target_name</property>
                        </data>
                    </cell>
                    <cell id="2602">
                        <data id="2649">
                            <property name="resultSetColumn">sent_value</property>
                        </data>
                    </cell>
                    <cell id="2826">
                        <data id="2830">
                            <property name="resultSetColumn">delivered_value</property>
                        </data>
                    </cell>
                    <cell id="2603">
                        <data id="2650">
                            <property name="resultSetColumn">openers_value</property>
                        </data>
                    </cell>
                    <cell id="2604">
                        <data id="2651">
                            <structure name="numberFormat">
                                <property name="category">Percent</property>
                                <property name="pattern">###0.0%</property>
                            </structure>
                            <property name="resultSetColumn">openers_rate</property>
                        </data>
                    </cell>
                    <cell id="2605">
                        <data id="2652">
                            <property name="resultSetColumn">clicking_value</property>
                        </data>
                    </cell>
                    <cell id="2606">
                        <data id="2653">
                            <structure name="numberFormat">
                                <property name="category">Percent</property>
                                <property name="pattern">###0.0%</property>
                            </structure>
                            <property name="resultSetColumn">clicking_rate</property>
                        </data>
                    </cell>
                    <cell id="2607">
                        <data id="2654">
                            <property name="resultSetColumn">signedoff_value</property>
                        </data>
                    </cell>
                    <cell id="2608">
                        <data id="2655">
                            <structure name="numberFormat">
                                <property name="category">Percent</property>
                                <property name="pattern">###0.0%</property>
                            </structure>
                            <property name="resultSetColumn">signedoff_rate</property>
                        </data>
                    </cell>
                    <cell id="2609">
                        <data id="2656">
                            <property name="resultSetColumn">bounces_value</property>
                        </data>
                    </cell>
                    <cell id="2610">
                        <data id="2657">
                            <structure name="numberFormat">
                                <property name="category">Percent</property>
                                <property name="pattern">###0.0%</property>
                            </structure>
                            <property name="resultSetColumn">bounces_rate</property>
                        </data>
                    </cell>
                    <cell id="2611">
                        <data id="2658">
                            <property name="resultSetColumn">revenue_value</property>
                        </data>
                    </cell>
                </row>
            </detail>
        </table>
    </body>
</report>
