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)
Filter table by scripted data set
404040
<p>For past two day am working in this report..am struggling a lot..if i fill value in array it will fill all Zero value.....in top table..its not bothered below table to count and increment.and how to give hyperlink to each column to drill down...the value..i know am only doing a mistake..but am not well in script...so kindly go through it report..just correct and provide solution for this...report</p><div><div> </div><div><a data-ipb='nomediaparse' href='
https://www.dropbox.com/s/aqxark77nn2ko83/new_report_13.csv'>https://www.dropbox.com/s/aqxark77nn2ko83/new_report_13.csv</a></div><div><a
data-ipb='nomediaparse' href='
https://www.dropbox.com/s/9i1tp3kq65b365x/Copy of week.rptdesign'>https://www.dropbox.com/s/9i1tp3kq65b365x/Copy of week.rptdesign</a></div></div>
;
Find more posts tagged with
Comments
404040
<p>kindly reply for this post.....</p>
404040
<p>kindly reply for this post...........its urgent needed</p>
kclark
<p>Looking at your script it looks like dataset1 and dataset11 are making calls to an array temp that's being populated in another dataset, but you never set it as a PGV. I think if you tried to set it as a PGV before dataset 1 and 11 are executed then your script should work.</p>
404040
<p>thank for u r reply.......i dono where it has been put...its possible to correct the report.....</p><p> </p><p> </p><p>thank in advance....</p>
404040
<p>sir am not well in script just learning on the way could u please check the report and share to me...</p>
404040
<p>kindly reply for this post...</p><p> </p><p>thank in advance</p>
kclark
<p>
404040
<p>thank for u r reply..yes exactly but..in screen shoot if u look at the Below table ZONE NAME and VARIANCE column (i.e) east -->one zero,west-->one zero,south->one zero,but north --> two zero..so in top table in north--> one(1) is present according to screenshot..but ..my calculation is NORTH--->must be two(2)....and then again (6-10) column i think there is no variance but in top table is filling value...like 5,5,6,5....if there is no value it must be ZERO VALUE HAVE TO FILL.....<span style="font-size:14px;">and i will explain about whole report.......Report is mainly to compare by week..in the sense if click one date it have to compare same day of last week ...and VARIANCE calculation is like below but its not assigning a correct value...in the column i dono where i done mistake......just correct that too..</span></p><pre class="_prettyXprint"> percentage difference row["This Week ASPD"] = 867900 and row["This Week ASPD"] = 411381 ( | row["This Week ASPD"] - row["This Week ASPD"] | / ((row["This Week ASPD"] + row["This Week ASPD"])/2) ) * 100 = ( | 867900 - 411381 | / ((867900 + 411381)/2) ) * 100 = ( | 456519 | / (1279281/2) ) * 100 = ( 456519 / 639640.5 ) * 100 = 0.713712 * 100 = 71.3712% difference</pre><p><span style="font-size:12.800000190734863px;">i have a attached a report which tried ..for u r reference...</span></p>
404040
<p>kindly reply for this post ..........</p>
gargsa12
<p>Please check this link:</p><p><a data-ipb='nomediaparse' href='
http://www.birt-exchange.org/forum/index.php?/topic/30217-building-dataset-based-on-another-dataset/'>http://www.birt-exchange.org/forum/index.php?/topic/30217-building-dataset-based-on-another-dataset/</a></p>
;
404040
<p>kindly reply for this topic.... kclark!</p>
404040
<p>To be Honest seriously am not having single idea to go further ...kindly help on this report.... </p><p> </p><p> </p><p> </p><p>thank in advance..</p>
gargsa12
<p>can u explain this report a little more as there are some inconsistencies around ???? Is there any need of 2 datasets named date and main. Couldn't it be possible with 1 dataset only.</p>
GLO_FR
<p>is it this what you want to do ?</p><p>Maybe you will have to adjust the variance <span style="font-size:14px;">calculation because I've use your first rptdesign</span></p>
GLO_FR
<p>I don't think you can do a dynamic filter with hyperlink.</p><p>You can either create a detail report and use the drill-down function with hyperlink (passing ZONE_NAME and variance in parameters) or you can create bookmarks and naviguate in your design with hyperlink</p><p> </p><p>example joined</p>
404040
<p>Sorry to open again this topic.... before it had done by only Positive and negative for Date comparison now it have to be add do by month comparison of same month of last year like Positive, negative, Last year positive and Last year negative Same as like above....??how to achieve this...</p>
