| how to create datewise table? [message #1100778] |
Tue, 03 September 2013 15:22  |
 4040 4040
Messages: 78
Registered: February 2013 |
Member |
|
|
Hi,am having two requirement..first thing is i had created a date of month as parameter (1-8-2013 to 31-8-2013)...if i have select a date it have to display table like below
6am-7am 8am-9am 9am-10am 10am-11am
classic car 10 20 30 40
train 12 40 50 90
second thing is already i create a date of month(Aug 2013)..but it have to automatically update in listbox.to.next month of dates(sep 2013)
how to achieve two requirement.........
thank in advance...
[Updated on: Tue, 03 September 2013 15:23] Report message to a moderator |
|
|
| Re: how to create datewise table? [message #1100958 is a reply to message #1100778] |
Tue, 03 September 2013 21:05  |
|
This looks like a crosstab to me grouped by hour. For your second question, I'm not sure I'm totally understanding your question. If you can explain more, that would be great. Thanks!
Michael
Developer Evangelist, Silanis
|
|
|
| Re: how to create datewise table? [message #1102278 is a reply to message #1100958] |
Thu, 05 September 2013 15:36 |
4040 4040
Messages: 78
Registered: February 2013 |
Member |
|
|
thank for reply..this is the urgent needed report then i will work on hour report..this report is for mainly to find variance of week
for example let u consider example the date like 08/14/2003
so if u select a date it have to compare last week (08/7/2003)for sale ....if u look at a report they are two table so first table contain a productline with hyperlink so if we click a hyperlink it have to drill through a table country..so country contain a VARIANCE of sale ..according to variance only the top Table contain value Ranges..of product-line of (0-5%),(6-10%)like this...
0-5% 6-10% 10-15% 15-20% country
classic car 10 20 30 40 100
train 20 40 60 90 210
country sale lastweeksale variance%
india 6613 6287 5
spain 13036 12424 5
usa 8632 8337 4
how to achive this report...i have attached a sampledb..kindly provide a solution
thank u...
[Updated on: Thu, 05 September 2013 15:39] Report message to a moderator |
|
|
| Re: how to create datewise table? [message #1102748 is a reply to message #1102278] |
Fri, 06 September 2013 03:24 |
|
I'm not sure I'm understanding what happens when you click on a hyperlink in the top table. You want the bottom table to be filled with countries for that product line? And how are you determining the values that go in the top column? Let me know. If you can show a sample set of data and what it should look like in the report, it might help. Thanks.
Michael
Developer Evangelist, Silanis
|
|
|
| Re: how to create datewise table? [message #1103134 is a reply to message #1102748] |
Fri, 06 September 2013 12:12 |
4040 4040
Messages: 78
Registered: February 2013 |
Member |
|
|
thank for reply....report is mainly for compare a Weeks of the day..
for example:
According to my calculations, the percentage difference between 6613(sale) and 6287 last week(sale) is 5% of the day..
so from the variance we fill value in top table...
and we create a hyperlink for each variance..(i.e)if we click a 5(0-5) in top table it have drill-down a value between how many country are in the range of 5%....like wise it..go
i have attached a sample db with label value...kindly provide sample db..
thank in advance..
[Updated on: Fri, 06 September 2013 12:14] Report message to a moderator |
|
|
| Re: how to create datewise table? [message #1103396 is a reply to message #1103134] |
Fri, 06 September 2013 18:21 |
|
I don't know that the sample database has enough data to do this by week. I'll change it to be set up by month. If you want it to be done for week, please provide me with some sample data to use. Thanks!
Michael
Developer Evangelist, Silanis
|
|
|
|
|
|
| Re: how to create datewise table? [message #1106751 is a reply to message #1106412] |
Wed, 11 September 2013 13:56 |
|
Sorry for the delay. With the data you gave, I don't know how to associate the Outlets with a Zone. Can you please update the data in a way that I can do that? Or give me the list of outlets for each zone. Thanks.
Michael
Developer Evangelist, Silanis
|
|
|
|
|
|
|
|
|
| Re: how to create datewise table? [message #1111256 is a reply to message #1100778] |
Wed, 18 September 2013 01:43 |
|
Here is what I've got for you so far. I just did positive and negative difference to simplify it. I had to create two scripted data sources out of the original data to get what you were wanting. I might be able to simplify this later. This will work for now. All you need to do after this is to add your hyperlinks and pass a parameter through to limit the data and the rest should take care of itself.
Michael
Developer Evangelist, Silanis
|
|
|
| Re: how to create datewise table? [message #1111659 is a reply to message #1111256] |
Wed, 18 September 2013 14:45 |
4040 4040
Messages: 78
Registered: February 2013 |
Member |
|
|
first of all thank for u r effort and reply...which u gave is work as far good...and my question.. example which u provide is created by scripted data-set to fetch value for positive and negative value..so if i want more column means to create as like (positive and negative value).is the only way by scripted data set...or else we can do to by any other way like compute columns or by initialize method...i am not well in script am just asking idea from u concern ....
thank u....
[Updated on: Wed, 18 September 2013 15:04] Report message to a moderator |
|
|
| Re: how to create datewise table? [message #1111682 is a reply to message #1111659] |
Wed, 18 September 2013 15:17 |
|
There's likely going to have to be some script to make this work as you're wanting. I guess you wouldn't necessarily have to use a scripted dataset, but you'd still have to calculate the values for each variance group from the dataSet that splits the columns for this week and last week. I was going to use a crosstab for the bottom table and let it do the grouping and calculate the variance, but since the values in the top table depend on the second table, I had to do the calculations at a dataset level, which is why I used the scripted dataSets. The top table could probably be a crosstab instead, which would maybe make things easier for you on the variance columns.
Michael
Developer Evangelist, Silanis
|
|
|
|
|
| Re: how to create datewise table? [message #1116174 is a reply to message #1114990] |
Wed, 25 September 2013 04:03 |
|
The csv likely has nothing to do with it. The issue is that a field where we're checking its "length" has null values in it. You'll either need to filter out the rows with null values or modify the code to check for null values and assign a length of 0 to the variable, or something.
Michael
Developer Evangelist, Silanis
|
|
|
| Re: how to create datewise table? [message #1129250 is a reply to message #1116174] |
Tue, 08 October 2013 12:54 |
4040 4040
Messages: 78
Registered: February 2013 |
Member |
|
|
sry to open this topic again ..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....(csv is in top of thread..)
and then 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..
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 [Updated on: Tue, 15 October 2013 04:25] Report message to a moderator |
|
|
|
|
| Re: how to create datewise table? [message #1149434 is a reply to message #1148610] |
Tue, 22 October 2013 05:03 |
4040 4040
Messages: 78
Registered: February 2013 |
Member |
|
|
thank for u r reply....Mr.GLO_FR has solve the Report ......the one thing is to filter by drill down...(i.e).in the upper table the value are shown like this means
Count of Cafes 0-5% 6-10% 11-15% 16-25% 26-50% >50% Cafes
EAST 23 25 21 21 30 6 137
NORTH 49 36 19 26 19 8 184
SOUTH 41 32 19 26 17 5 157
WEST 57 32 17 25 12 8 164
so now if i click of any link for instance 23 so in below table have to show how many value are present in 23 ..like wise it go for all
if u look at this thread u will understand here it navigate to particular value ...but for me to drill down by hyperlink
http://www.birt-exchange.org/forum/index.php?/topic/30392-filter-table-by-scripted-data-set/
[Updated on: Tue, 22 October 2013 07:21] Report message to a moderator |
|
|
|
Powered by
FUDForum. Page generated in 0.05052 seconds
] 
Search
Help
Register
Login
Home
