nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Weeks in dates

khorsi

Hi everyone,

I am a little confused with the way weeks numbers are generated in crosstabs and charts.

In a cross tab I have a date group with the levels years>Months>WeekOfMonth>WeekOfYear...

29th,30th,31st of December 2012 is displayed as the week number 1 of 2012. Shouldn't it be the 53rd week of 2012?

am I missing something

Find more posts tagged with

Comments

kclark

Can you recreate this with the sample DB and post the rptdesign please?

khorsi

<blockquote class='ipsBlockquote' data-author="'kclark'" data-cid="113113" data-time="1357752298" data-date="09 January 2013 - 10:24 AM">
Can you recreate this with the sample DB and post the rptdesign please? </blockquote>
 
Hi kclark, 
 
to reproduce it I had to add a table ints just to generate the date sequence 
 
CREATE TABLE IF NOT EXISTS `ints` ( 
`i` int(11) DEFAULT NULL 
) ENGINE=MyISAM DEFAULT CHARSET=latin1; 
 
 
 
INSERT INTO `ints` (`i`) VALUES 
(0), 
(1), 
(2), 
(3), 
(4), 
(5), 
(6), 
(7), 
(8), 
(9); 
 
here is the report attached

kclark

I created a report with the classic models DB and the weeks showed correctly in my crosstab. I wasn't able to run your sample report.

khorsi

<blockquote class='ipsBlockquote' data-author="'kclark'" data-cid="113154" data-time="1357857210" data-date="10 January 2013 - 03:33 PM">
I created a report with the classic models DB and the weeks showed correctly in my crosstab. I wasn't able to run your sample report. </blockquote>
 
thanks kclark for the reply 
 
I used mysql version of the classic models DB and added a table to be able to write a query which generates sequences of dates. 
 
I attach here what I get in the preview

kclark

It looks like it's correct you'd need to change the week in the crosstab by checking if the week equals 1 and the month is December then you could change it to week 53. You could open the expression editor for Week of Year and do something like this. 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>if(data["Month"] == "December" && dimension["Group"]["Week Of Year"] == "1") {
this.value = "53"
}</pre>

khorsi

<blockquote class='ipsBlockquote' data-author="'kclark'" data-cid="113158" data-time="1357878776" data-date="10 January 2013 - 09:32 PM">
It looks like it's correct you'd need to change the week in the crosstab by checking if the week equals 1 and the month is December then you could change it to week 53. You could open the expression editor for Week of Year and do something like this. 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>if(data["Month"] == "December" && dimension["Group"]["Week Of Year"] == "1") {
this.value = "53"
}</pre></blockquote>
 
Thanks kclark.

kclark

You're welcome, let me know if you have anymore questions.

arish

What about a Chart? It seems that with this issue of changing data value in crosstab the Chart doesnt work

.
 
Is this a bug?
 
Thanks!

JFreeman

Could you be more specific about how the Chart does not work?
Could you provide a sample report we can run that demonstrates the issue?

arish

Yes, I've attached a sample report I did.
 
I've manipulated the data binding of Week of Year and after I've sorted the crosstab by week of year.
 
Until there I have no problems.
 
But if I want a Chart with the Crosstab data i have a error and the Chart is not rendered.
 
Thanks!

JFreeman

I believe the issue you are facing is due to performing your calculations on the data binding which means the values are not available to the chart in time for its rendering.
 
Instead, you can create a computed column for year and another for week of year. Then create the crosstab based on these versus the date column.
 
Take a look at the attached modified version of your example for reference.

arish

Thanks JFreeman!,
 
I didnt think in this posible solution.
 
you are very kind

JFreeman

I'm glad I could be of assistance.
Let us know if you have any additional questions.