reporting services - SSRS 2016 - data bar chart with repeating color states over time -


i use ms ssrs 2016 enterprise.

i have measured values on time want show on 1 bar chart. values consists of time , status measured in time, e.g.:

time  | status 05:01 | g (green) 05:15 | r (red) 06:08 | g 11:41 | y (yellow) 11:43 | r 11:59 | y 13:00 | g

all need show 1 colored bar day 00:00 23:59 colored according actual status. time on x axis , in case above 05:01 05:15 green, 05:15 06:08 red, 06:08 11:41 green, 2 minutes yellow, red etc.

is there ssrs object, able this? calculation of status each time not optimal, show periods instead can't find appropriate chart type.

any help? in advance!

edit: these real data being load dataset.

time                status 2016-10-30 10:56:00 0 2016-10-30 10:26:00 3 2016-10-30 07:56:00 0 2016-10-30 06:56:00 3 2016-10-25 17:50:00 0 2016-10-22 08:09:00 0 2016-10-22 07:09:00 3 2016-10-21 13:36:00 0 2016-10-21 08:57:00 0 2016-10-20 15:21:00 0 2016-10-20 15:07:00 0 2016-10-18 19:13:00 0 2016-10-18 15:43:00 3 2016-10-18 03:13:00 0 2016-10-18 02:43:00 3 2016-10-17 14:04:00 0 2016-10-17 14:03:00 0 2016-10-17 12:53:00 0 2016-10-07 17:46:00 0 2016-10-07 17:26:00 0 2016-10-07 17:20:00 0 2016-09-17 19:05:00 0 2016-09-17 18:35:00 3 2016-09-14 09:33:00 0

in case, there should long green horizontal bar (because of status 0) few red spaces (because of status 3) between 2016-09-17 18:35 - 19:05, 2016-10-18 02:43 - 3:13, 2016-10-18 15:43 - 19:13, 2016-10-22 07:09 - 8:09, 2016-10-30 06:56 - 7:56 , 2016-10-30 10:26 end of graph.

finally, found out wanted. i'm posting here answer question future readers. found blog:

http://pnarayanaswamy.blogspot.sk/2010/09/range-bar-chart-gantt-chart-using-ssrs.html

the object best task range bar chart. first needed precalculate "status", "from time" , "to time". put time on x axis , status serie, range top , bottom value , times. made kind of gant chart rearranged needed setting drawsidebyside option. colors made setting expression serie filling.


Comments

Post a Comment

Popular posts from this blog

php - How to add and update images or image url in Volusion using Volusion API -

actually have store importing products store product data insert , update image or image url not insert , update. this xml code name datapro.txt. <products_joined> <productcode>3710_012t</productcode> <vendor_partno>eah5450silent/di/1gd3(lp)</vendor_partno> <productname>test product ta</productname> <hideproduct>n</hideproduct> <stockstatus>20</stockstatus> <lastmodified>1/5/2016 10:25:00 am</lastmodified> <lastmodby>2</lastmodby> <productweight>0.9</productweight> <productprice>100</productprice> <productmanufacturer>asus tek</productmanufacturer> <vendor_price>32.69</vendor_price> <numproductssharingstock>0</numproductssharingstock> <categoryids>107</categoryids> <producturl>http://tebkq.mvlce.servertrust.com/productdetails.asp?productcode=3710_012t</producturl>
Read more

javascript - jQuery UI Splitter/Resizable for unlimited amount of columns -

using jqueryui splitter or resizable functions want create layout allows unlimited amount of columns added , columns need resizable. so fiddle: https://jsfiddle.net/f3glh3mw/ but in fiddle html contains out of nested sets instead of inline. limits possibilities above fiddle can have equal widths 2,4,8,16,32 etc columns. in between shows crooked can see in fiddle. when researching came on question: jquery ui , splitter if @ top answer shows structure like: <div class="wrap"> <div class="resizable resizable1"></div> <div class="resizable resizable2"></div> </div> full fiddle: http://jsfiddle.net/8qztj/86/ which structure want javascript hardcoded 2 resizable items. so here question: how modify last fiddle works amount of .resizable divs. or know of plugin can this. thanks helping! so far found plugin: http://www.bacubacu.com/colresizable/ which says , close functionality want. in
Read more

javascript - IE9 error '$'is not defined -

Image
<!--[if lte ie 9]><html class="lte9"><![endif]--><!--[if gt ie 9]><html><![endif]--> <!--[if !ie]><!--> <html> <!--<![endif]--> blah blah <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.12.1/jquery.min.js"></script> <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script> <script src="{{ asset('js/mypage.js') }}" type="text/javascript"></script> </body> </html> when load page, ie9 brings error '$' not defined . how can solve error? +++ mypage.js $(function(){ //when load page, //ie9 tag not moving. $(window).load(function() { $('div.mask').hide(); }); // when click , willshow show. //for not ie 9 if (!$('html').hasclass('lte9')) { var = $('ul.about > li > span.activebtn');
Read more