question

yxzhou624 avatar image
yxzhou624 asked

How to group time into a range like 9:00- 9:30 AM,9:30-10:00 AM etc in SSRS charts???

Hi All, I have a trend chart showing total services per 30 mins time slot across a time range I have to group the DATETIME axis in the below way : Time Range (needed to show in the chart as one column) ....... 8:00 -8:30 8:30 -9:00 9:00-9:30 ......... how to group the time range by 30 mins time slot in ssrs Any help on this?? Thanks
ssrs-2008sql 2008
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Jon Crawford avatar image
Jon Crawford answered
I'm sure there are others, but I use Jeremiah Peschka's Minutes table solution: [here][1] [1]: https://facility9.com/2010/02/rounding-to-the-nearest-x-minutes-the-lazy-way/
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.