Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
aswindba1
Yak Posting Veteran
62 Posts |
 Posted - 2013-12-11 : 18:39:06
|
| How to change the axis intervals dynamically based on the range of dates.Ex: date column has follwojg values01/01/201302/04/2013--------------------------------------------------------01/06/2014so the axis interval shoud be 01/2013 to 01/2014if it is february axis interval should show 02/2013 to 02/2014Olease advise andlet meknow if you need additonal information.ThanksAswin |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-12-12 : 12:24:44
|
| You just need to use the calendar table as your base table and then left join your other tables to that for the query behind. This will make sure it will show you the interval based on date range selected irrespective of whether its missing data or not.if you dont have calendar table use this udf insteadhttp://visakhm.blogspot.in/2010/02/generating-calendar-table.html------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
|
|
|
Re: Axis Interval