Croosstab - Row Grouping by time

The actual description of my problem is here <a class='bbc_url' href='http://www.birt-exchange.org/forum/practice-area/15411-croosstab-row-grouping-time.html'>http://www.birt-exchange.org/forum/practice-area/15411-croosstab-row-grouping-time.html</a> 
 
I created the thread in the wrong section. 
 
Thanks.

Find more posts tagged with

Comments

mwilliams

Hi Jose,

I don't think that BIRT does grouping on 30 minutes on its own. You'll probably have to create a computed column in your dataSet that figures the half hour intervals, then use that value as the row dimension. I haven't tried this, but I would assume that it would work.

Jose

<blockquote class='ipsBlockquote' data-author="mwilliams">Hi Jose, 
 
I don't think that BIRT does grouping on 30 minutes on its own. You'll probably have to create a computed column in your dataSet that figures the half hour intervals, then use that value as the row dimension. I haven't tried this, but I would assume that it would work.</blockquote>
 
Thank you for the quick reply. 
 
Any recommendations on the details to create the computed column you speak of?

mwilliams

Jose,

You'd just have to pull the hour and minute from the time and create a value based on those that would sort in the correct order. This would be done in the dataSet editor. Then in the script for the dimension item in your crosstab, you could replace that value with whatever string representation you wanted. i.e. if you had 12 for times between 12 and 12:30, you'd replace it with 12:00pm - 12:30pm or something like that. Let me know if you have any more questions.

Jose

<blockquote class='ipsBlockquote' data-author="mwilliams">Jose, 
 
You'd just have to pull the hour and minute from the time and create a value based on those that would sort in the correct order. This would be done in the dataSet editor. Then in the script for the dimension item in your crosstab, you could replace that value with whatever string representation you wanted. i.e. if you had 12 for times between 12 and 12:30, you'd replace it with 12:00pm - 12:30pm or something like that. Let me know if you have any more questions.</blockquote>
 
Success, just what I needed. 
 
Thanks a lot!

mwilliams

No problem, glad I could help. Let us know whenever you have questions.