Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
PUBLIC CLOUD
PRIVATE CLOUD
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (Analytics)
Bar chart drill through issue.
kukkri
Hi,
I looked through the forum but did not find any solution that answers my question entirely.
My issue is 2-fold. I have a bar chart that needs to do the following:
1)Click on the series(x-axis = year ex: 2002, 2003 etc), it should launch another report(ex MONTHLY) and pass the year clicked from the bar.This MONTHLY is another bar chart with data for the months of the year clicked. It probably needs some code in the Y-Series INTERACTIVITY for this.
2) From the above MONTHLY Clicking on any other part of the chart other than the bars, should launch a detailed tabular report ( I already have a details table in the report) listing activities for the year.
Hope this makes sense.
I tried attaching one of my reports but there was an issue with the site...will try again later.
Find more posts tagged with
Comments
kukkri
//attachment failed...so here is the xml<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>
<?xml version="1.0" encoding="UTF-8"?>
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.17" id="1">
<property name="createdBy">Eclipse BIRT Designer Version 2.3.2.v20090331-1440 Build <2.3.2.v20090331-1200></property>
<property name="units">in</property>
<html-property name="description">This report has a Chart-Table Interactivity feature in that when a particular bar on the chart is selected it will filter the table with the appropriate data.
Dataset is filtering out data prior to 2002.
Code:
1. Find the code in Format Chart--> Y series-->Interactivity-->Mouse Click-->Invoke Script.
2.In the above script make sure to add the column name
3. Make sure to add the particular column to the table so it can filter...else this code will not work. In this case...added a computed column called Incident_year.
4. Do not page break after chart since the getTableByBookmark() code is not yet working.
Couple of caveats:
1. Since the getTableByBookmark() code is not yet working keep chart and data on the same page.
2.The column that you are filtering by in the script needs to be in the table else the filter will not work. (Make it hidden if not needed).
Script:
// "Invoke Script" of a BIRT chart contains the following variables:
// evt - browser event object
// categoryData - value of the Category that was clicked
// valueData - numeric value of the item clicked in the chart
// valueSeriesName - name of the series that was clicked
// Get a handle on the Actuate JSAPI Viewer for this chart
// browsers implement the event object differently
// evt.srcElement is for IE, evt.target is for Firefox
// getTableBookmark() can optionally take the name of a BIRT bookmark
var table = actuate.getViewer(evt.srcElement || evt.target).getCurrentPageContent().getTableByBookmark("Incidents Over Time - Table");
// create a new Filter object and apply it to the table
table.setFilters(new actuate.data.Filter("Incident_year", "eq", categoryData));
table.submit();</html-property>
<text-property name="displayName">EL_RiskBased_Portrait</text-property>
<property name="bidiLayoutOrientation">ltr</property>
<parameters>
<scalar-parameter name="prmYrTimeFrame" id="537">
<text-property name="helpText">Select a value from list to modify the dashboard.</text-property>
<property name="valueType">static</property>
<property name="dataType">string</property>
<property name="paramType">simple</property>
<text-property name="promptText">Select Timeframe</text-property>
<property name="isRequired">false</property>
<property name="controlType">list-box</property>
<property name="mustMatch">true</property>
<property name="fixedOrder">true</property>
<property name="defaultValue">AT</property>
<property name="distinct">true</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
<list-property name="selectionList">
<structure>
<property name="value">AT</property>
<property name="label">All Time</property>
</structure>
<structure>
<property name="value">TM</property>
<property name="label">This Month</property>
</structure>
<structure>
<property name="value">LM</property>
<property name="label">Last Month</property>
</structure>
<structure>
<property name="value">YTD</property>
<property name="label">Year to Date</property>
</structure>
<structure>
<property name="value">LY</property>
<property name="label">Last Year</property>
</structure>
</list-property>
</scalar-parameter>
</parameters>
<data-sources>
<oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc" name="EL_RBS_datasource" id="533">
<property name="odaDriverClass">com.mysql.jdbc.Driver</property>
<property name="odaURL">jdbc:mysql://db.birtondemand.com:3306/riskbas4V1LOzs62</property>
<property name="odaUser">riskbas4V1LOzs62</property>
<encrypted-property name="odaPassword" encryptionID="jce">477fe7e95b9317aef972495209bae5df</encrypted-property>
</oda-data-source>
</data-sources>
<data-sets>
<oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="tblIncidents_over_time" id="535">
<list-property name="computedColumns">
<structure>
<property name="name">Incident_year</property>
<expression name="expression">BirtDateTime.year(row["Incident_Date"]).toFixed()</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<list-property name="columnHints">
<structure>
<property name="columnName">Incident_Date</property>
<property name="displayName">Incident_Date</property>
</structure>
<structure>
<property name="columnName">Name</property>
<property name="displayName">Name</property>
</structure>
<structure>
<property name="columnName">Country</property>
<property name="displayName">Country</property>
</structure>
<structure>
<property name="columnName">BusinessType</property>
<property name="displayName">BusinessType</property>
</structure>
<structure>
<property name="columnName">BusinessSubType</property>
<property name="displayName">BusinessSubType</property>
</structure>
<structure>
<property name="columnName">BreachType</property>
<property name="displayName">BreachType</property>
</structure>
<structure>
<property name="columnName">DataType</property>
<property name="displayName">DataType</property>
</structure>
<structure>
<property name="columnName">InsideOutside</property>
<property name="displayName">InsideOutside</property>
</structure>
<structure>
<property name="columnName">ThirdParty</property>
<property name="displayName">ThirdParty</property>
</structure>
<structure>
<property name="columnName">ThirdPartyName</property>
<property name="displayName">ThirdPartyName</property>
</structure>
<structure>
<property name="columnName">TotalAffected</property>
<property name="displayName">TotalAffected</property>
</structure>
<structure>
<property name="columnName">RefPage</property>
<property name="displayName">RefPage</property>
</structure>
<structure>
<property name="columnName">UID</property>
<property name="displayName">UID</property>
</structure>
<structure>
<property name="columnName">XREF1</property>
<property name="displayName">XREF1</property>
</structure>
<structure>
<property name="columnName">StockSymbol</property>
<property name="displayName">StockSymbol</property>
</structure>
<structure>
<property name="columnName">DataRecovered</property>
<property name="displayName">DataRecovered</property>
</structure>
<structure>
<property name="columnName">ConsumerLawsuit</property>
<property name="displayName">ConsumerLawsuit</property>
</structure>
<structure>
<property name="columnName">ArrestProsecution</property>
<property name="displayName">ArrestProsecution</property>
</structure>
</list-property>
<list-property name="filter">
<structure>
<property name="operator">ge</property>
<expression name="expr">row["Incident_Date"]</expression>
<simple-property-list name="value1">
<value>"2002-02-01"</value>
</simple-property-list>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">Incident_Date</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">Name</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">Country</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">BusinessType</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">BusinessSubType</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">BreachType</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">DataType</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">InsideOutside</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">ThirdParty</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">10</property>
<property name="name">ThirdPartyName</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">11</property>
<property name="name">TotalAffected</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">12</property>
<property name="name">RefPage</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">13</property>
<property name="name">UID</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">14</property>
<property name="name">XREF1</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">15</property>
<property name="name">StockSymbol</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">16</property>
<property name="name">DataRecovered</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">17</property>
<property name="name">ConsumerLawsuit</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">18</property>
<property name="name">ArrestProsecution</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">19</property>
<property name="name">Incident_year</property>
<property name="dataType">string</property>
</structure>
</list-property>
</structure>
<property name="dataSource">EL_RBS_datasource</property>
<method name="beforeOpen"><![CDATA[
//if (params["prmYrTimeFrame"].value == 'AT' )
//{
// this.queryText = this.queryText + " where year(tblDatalossdb.Incident_Date) IN (2002,2003,2004,2005,2006,2007,2008,2009,2010,2011,2012,2013,2014,2015)"
//}
//else if (params["prmYrTimeFrame"].value == 'TM' )
//{
// this.queryText = this.queryText + " where tblDatalossdb.Incident_Date between '2011-03-01' and '2011-03-31'"
//}
//else if (params["prmYrTimeFrame"].value == 'LM' )
//{
//this.queryText = this.queryText + " where tblDatalossdb.Incident_Date between '2011-03-01' and '2011-12-31'"
//}
//else if (params["prmYrTimeFrame"].value == 'YTD' )
//{
//this.queryText = this.queryText + " where tblDatalossdb.Incident_Date between '2011-01-01' and '2011-12-31'"
//}
//else if (params["prmYrTimeFrame"].value == 'LY' )
//{
//this.queryText = this.queryText + " where tblDatalossdb.Incident_Date between '2010-01-01' and '2010-12-31'"
//}
//else
{
//this.queryText = this.queryText + "tblDatalossdb.Incident_Date = 2002-01-01"
}]]></method>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">Incident_Date</property>
<property name="nativeName">Incident_Date</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">Name</property>
<property name="nativeName">Name</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">Country</property>
<property name="nativeName">Country</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">BusinessType</property>
<property name="nativeName">BusinessType</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">BusinessSubType</property>
<property name="nativeName">BusinessSubType</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">BreachType</property>
<property name="nativeName">BreachType</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">DataType</property>
<property name="nativeName">DataType</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">InsideOutside</property>
<property name="nativeName">InsideOutside</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">ThirdParty</property>
<property name="nativeName">ThirdParty</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">10</property>
<property name="name">ThirdPartyName</property>
<property name="nativeName">ThirdPartyName</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">11</property>
<property name="name">TotalAffected</property>
<property name="nativeName">TotalAffected</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">12</property>
<property name="name">RefPage</property>
<property name="nativeName">RefPage</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">13</property>
<property name="name">UID</property>
<property name="nativeName">UID</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">14</property>
<property name="name">XREF1</property>
<property name="nativeName">XREF1</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">15</property>
<property name="name">StockSymbol</property>
<property name="nativeName">StockSymbol</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">16</property>
<property name="name">DataRecovered</property>
<property name="nativeName">DataRecovered</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">17</property>
<property name="name">ConsumerLawsuit</property>
<property name="nativeName">ConsumerLawsuit</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">18</property>
<property name="name">ArrestProsecution</property>
<property name="nativeName">ArrestProsecution</property>
<property name="dataType">string</property>
</structure>
</list-property>
<property name="queryText">select tblDatalossdb.Incident_Date,
tblDatalossdb.Name,
tblDatalossdb.Country,
tblDatalossdb.BusinessType,
tblDatalossdb.BusinessSubType,
tblDatalossdb.BreachType,
tblDatalossdb.DataType,
tblDatalossdb.InsideOutside,
tblDatalossdb.ThirdParty,
tblDatalossdb.ThirdPartyName,
tblDatalossdb.TotalAffected,
tblDatalossdb.RefPage,
tblDatalossdb.UID,
tblDatalossdb.XREF1,
tblDatalossdb.StockSymbol,
tblDatalossdb.DataRecovered,
tblDatalossdb.ConsumerLawsuit,
tblDatalossdb.ArrestProsecution
from tblDatalossdb
</property>
<xml-property name="designerValues"><![CDATA[<?xml version="1.0" encoding="UTF-8"?>
<model:DesignValues xmlns:design="http://www.eclipse.org/datatools/connectivity/oda/design" xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaModel">
<Version>1.0</Version>
<design:ResultSets derivedMetaData="true">
<design:resultSetDefinitions>
<design:resultSetColumns>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>Incident_Date</design:name>
<design:position>1</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>10</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>Incident_Date</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>Incident_Date</design:label>
<design:formattingHints>
<design:displaySize>10</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>Name</design:name>
<design:position>2</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>114</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>Name</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>Name</design:label>
<design:formattingHints>
<design:displaySize>114</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>BreachType</design:name>
<design:position>3</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>39</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>BreachType</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>BreachType</design:label>
<design:formattingHints>
<design:displaySize>39</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
</design:resultSetColumns>
</design:resultSetDefinitions>
</design:ResultSets>
</model:DesignValues>]]></xml-property>
</oda-data-set>
</data-sets>
<styles>
<style name="report" id="4">
<property name="fontFamily">"Verdana"</property>
<property name="fontSize">10pt</property>
</style>
<style name="crosstab-cell" id="5">
<property name="borderBottomColor">#CCCCCC</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">1pt</property>
<property name="borderLeftColor">#CCCCCC</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">1pt</property>
<property name="borderRightColor">#CCCCCC</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">1pt</property>
<property name="borderTopColor">#CCCCCC</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">1pt</property>
</style>
<style name="crosstab" id="6">
<property name="borderBottomColor">#CCCCCC</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">1pt</property>
<property name="borderLeftColor">#CCCCCC</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">1pt</property>
<property name="borderRightColor">#CCCCCC</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">1pt</property>
<property name="borderTopColor">#CCCCCC</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">1pt</property>
</style>
</styles>
<page-setup>
<simple-master-page name="Simple MasterPage" id="2">
<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>
<page-header>
<grid name="MasterPageLandscape_Header" id="524">
<property name="marginTop">0pt</property>
<property name="verticalAlign">top</property>
<property name="height">1.125in</property>
<property name="width">100%</property>
<method name="onRender"><![CDATA[if(pageNumber>1){
this.height = "0.5in"
}]]></method>
<column id="609">
<property name="width">2.1666666666666665in</property>
</column>
<column id="526"/>
<row id="527">
<method name="onRender"><![CDATA[if(pageNumber>1){
this.getStyle().display ="none"
}]]></method>
<cell id="608">
<image name="imgProgramLogoLandscape" id="529">
<property name="height">71px</property>
<property name="width">219px</property>
<property name="source">embed</property>
<property name="imageName">Mod Risk_Based_Sec_for_white_bg.png</property>
<structure name="action">
<property name="linkType">hyperlink</property>
<property name="toolTip">Click on image to visit site for latest news.</property>
<expression name="uri">"http://riskbasedsecurity.com/news/"</expression>
<property name="targetWindow">_blank</property>
</structure>
</image>
</cell>
<cell id="528">
<property name="colSpan">1</property>
<property name="rowSpan">1</property>
</cell>
</row>
<row id="610">
<method name="onRender"><![CDATA[if(pageNumber>1){
this.getStyle().display ="none"
}]]></method>
<cell id="611"/>
<cell id="612">
<label id="607">
<property name="fontSize">14pt</property>
<property name="fontWeight">bold</property>
<property name="marginTop">0pt</property>
<property name="textAlign">center</property>
<text-property name="text">Total Reported Incidents</text-property>
</label>
</cell>
</row>
</grid>
</page-header>
<page-footer>
<grid name="PageFooter111" id="471">
<property name="borderTopColor">#000000</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">medium</property>
<property name="marginTop">15pt</property>
<property name="marginLeft">10pt</property>
<property name="height">0.6979166666666666in</property>
<property name="width">100%</property>
<column id="472">
<property name="width">0.20833333333333334in</property>
</column>
<column id="473">
<property name="width">2.2395833333333335in</property>
</column>
<column id="474">
<property name="width">7.020833333333333in</property>
</column>
<column id="475">
<property name="width">1.09375in</property>
</column>
<row id="476">
<property name="height">0.6979166666666666in</property>
<cell id="477">
<property name="paddingLeft">10pt</property>
</cell>
<cell id="479">
<grid id="480">
<property name="marginTop">0pt</property>
<property name="canShrink">true</property>
<property name="height">0.5729166666666666in</property>
<property name="width">2.1770833333333335in</property>
<column id="482">
<property name="width">0.625in</property>
</column>
<column id="483">
<property name="width">0.3541666666666667in</property>
</column>
<column id="484">
<property name="width">0.46875in</property>
</column>
<row id="485">
<property name="height">0.5729166666666666in</property>
<cell id="488">
<auto-text name="a111" id="489">
<property name="fontFamily">"Arial"</property>
<property name="fontWeight">bold</property>
<property name="paddingTop">10pt</property>
<property name="textAlign">right</property>
<property name="display">block</property>
<property name="canShrink">true</property>
<property name="type">page-number</property>
</auto-text>
</cell>
<cell id="490">
<text id="491">
<property name="fontFamily">"Arial"</property>
<property name="fontWeight">bold</property>
<property name="paddingTop">10pt</property>
<property name="paddingLeft">0pt</property>
<property name="paddingRight">0pt</property>
<property name="textAlign">center</property>
<property name="canShrink">true</property>
<property name="contentType">plain</property>
<text-property name="content"><![CDATA[of]]></text-property>
</text>
</cell>
<cell id="492">
<auto-text id="493">
<property name="fontFamily">"Arial"</property>
<property name="fontWeight">bold</property>
<property name="paddingTop">10pt</property>
<property name="canShrink">true</property>
<property name="type">total-page</property>
</auto-text>
</cell>
</row>
</grid>
</cell>
<cell id="494">
<text id="495">
<property name="fontFamily">"Arial"</property>
<property name="fontWeight">bold</property>
<property name="paddingTop">10pt</property>
<property name="textAlign">right</property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[Report Run: <value-of format="MM/dd/yyyy hh:mm:ss a">new Date()</value-of>]]></text-property>
</text>
</cell>
<cell id="496"/>
</row>
</grid>
</page-footer>
</simple-master-page>
</page-setup>
<body>
<grid id="613">
<property name="height">0.3125in</property>
<property name="width">10.489583333333334in</property>
<column id="614"/>
<row id="615">
<property name="height">0.3125in</property>
<cell id="616"/>
</row>
</grid>
<extended-item extensionName="Chart" name="NewChart" id="536">
<xml-property name="xmlRepresentation"><
