What's New in v19.1 – Dashboards, Reporting & Data Analytics

hey everybody i'm amanda with DevExpress and welcome to 19.1 launch week and today's webinar what's new in dashboards reporting and analytics presented by DevExpress Technical Evangelist Paul uh sure and DevExpress CTO julien Bucknell in this session we'll learn how we're reshaping our data analytics product line and see how you can deliver more in less time with version 19.1 this session is being recorded and it will be made available on our DevExpress youtube channel later today and we will send the link to the recording in a follow-up email we will also do a live Q&A at the end of this presentation just type your questions in the GoToWebinar control panel at any time throughout the broadcast we do have members of the dev team online with us so they will try and get to all of your questions as best they can all right thank you so much for joining us I will now hand things over to Paul and Julian Thank You Amanda and good morning everyone now before I introduce Julian I want to let everybody know that nineteen point 1.3 is released good morning Julian hey I was supposed to do that bit and good morning Paul a good morning everybody yes we released this morning or if you're in Australia late last night and please do go and download but preferably after this webinar because we've got a lot to talk about yes we do dashboards reporting and data analytics which is going to encompass charting as well now one of the biggest challenges when we start looking at what's new across this range is the fact that it touches just about every platform so I'm gonna take you through reporting this morning and I'll take you through dashboards and then Julian you can finish up with the charting at the end it is going to be fast paced there's going to be a lot of switching between the different demos so we will just jump straight in and start having a look at what's new as I mentioned we're going to be starting out with the WinForms or sorry the reporting demos and I'm going to be running that from the demo Center moving over to reports now the first thing we're going to look at is a hierarchical reports and that's a word that's been coming up a lot throughout these last few days isn't that right Julian absolutely hierarchical certainly seems to be the term of the day we got hierarchical this that and the other so obviously our data is becoming more organized perhaps certainly is we can see from this demo report here I'm gonna use the wind forms reports demos for probably most of what we're doing until I get out of the all platforms area but we can see that we've got the region being the parent in this report and then the countries sitting inside each region so that's the the tree style element that's being represented from the report perspective I can collapse and expand and I'm going to take you through the designer aspects of that in a second as well but now basically using the detail band you can specify that you want to have this hierarchy style report and there's two different types of data structures that we can work with traditionally you'd have a parent-child relationship so you can use a key field name and a parent field name or you may have a self reference structure where you only need the child list field name in there so imagine the likes of an employee list where you want a management hierarchy but it's still just a flat list when you're inside the report designer you can actually come in to the detail band and as we move through the properties panel you'll see that I've got this hierarchy options group across here and in this instance we're using a key field name and the parent field name and then you've got the ability of setting the indent level of course if I was using the self-referencing you'd have the entry inside the child this field you'll notice as well then we've got this checkbox which is drill down expanded so when the report renders it's going to show all the details automatically expanded and it's saying that we want to drill down to be controlled by this checkbox which is sitting over here in the design surface a couple of things that I want to draw your attention to if you're going to be using this style of report and that is related to the anchor properties on the elements because of the indent if you don't actually set the anchors then you'll end up with the column shifting slightly and it will make for a bit of a mismatch on your report so you can see in this example for the numeric columns I've got the anchor horizontal set to right and the anchor vertical to both whereas for the region I'm simply anchoring on both and it will just help step into that nice display so if we preview that again we can see that everything is aligned regardless of the level that is sitting at so next we'll take a look at the merge reports now prior to version 19 point one when you were doing report merging you'd have to utilize some code behind if you wanted to achieve some very special circumstances so what we have now is the insider designer we've got a new property on the sub report element again I'm just using a standard one of the demo templates I'm gonna scroll down and find this chart sub report now there's a property sitting over here and it's or the only important one called generate own pages when I disable that you'll see that I can position my sub report as I would normally to be incorporated into the main report when I turn that parameter on it automatically takes up the whole width of my report and that's because the resub report is now in charge or responsible for creating its own report pages if we look at the preview on that we can see exactly what I mean scroll down actually I'll do the many pages and take a look thank you Malwarebytes for your little pop-up there free advertising no so we've got we've got the individual pages which is generated from the data we can see our table of contents but then you can also see I'll zoom in a little that we've got our chart rendering as a landscape page so from that perspective you no longer have to add code behind or do complex code document merging approaches and there's some major advantages for that such as you can export the document now in a continuous single file you can also use the interactive features that require rebuilding the document such as the drill down or sorting or report parameter input that's all encompassed in that new feature and that you're also open able to open the page setup window for a merge report and change the margins in the Print Preview window and then finally watermarks are also preserved upon document creation well it's really cool about using this particular feature is at the table of contents and the document map can be automatically created for a report merge from a parent and sub reports so it's going to take care of making sure that all that is in place and we can see here just from this document map produce has multi pages as children yet the produce chart as a single element at the end is also incorporated next I want to talk about the JSON data source in this version at weaving added the ability to do authentication so what I'm going to do is very quickly create a new report we're gonna add my data source to this report and I'm gonna choose a JSON data source but before that I need to make sure that in my clipboard I have a correct URL I'm just using the north wind demo and as I step through the datasource this next screen allows me to provide some valuable details if I'm wanting to implement that authentication so we've added support for basic HTTP we've added support for token-based authentication and you can see here we've also got query string parameters now the intricacy is particularly surrounding token taste style authentication you can get information from the documentation on how to best apply that but certainly a welcome addition to that data source a non-visible item for a second is the sequel data source now will only execute required queries so in other words if you've got your data source in there and there's a number of queries that aren't being utilized by either the report or a control a calculated feel or a parameter it's not going to actually get executed which is going to reduce the traffic to and from your application and the database server which of course is going to give you a performance improvement whilst I've got this report open I'm going to show you a couple of things with the checkbox the humble check box if I look over into the parameters windows over here we can see that it's now got full support for SVG icons and you can see in the list here there are some standards standard I entries in there you know some nice layouts I particularly like things like the smiley one but you've also got full support for doing custom glyphs so as I expand this property I can assign an image to each and every one of those as an SVG image now one example of using the check box with those SVG elements and again I think a really good example of using check boxes in a report is this vehicle inspection report well you can see they've been used pretty heavily all the way through but in different ways as I scroll through we've got all the different styles we've got those smiley faces smiley faces in in full way it's easy to see what's been represented and the ticks and crosses across that all the way through to a traditional tick an empty box with that as well so personally I think that's a great use of the SVG you know that's going to render properly and also just the different ways that you can use the check box throughout that and I'd have to say I wish my dealer would have this application because the way they do their inspection reports it's like scribbled out the wazoo well you could always ask them to to maybe start using our products Julian I'll try that yes next is the XR label control we've added the ability to use HTML inspired text formatting now it's a an interesting phrase but it's a subset of pseudo HTML tags that are currently supported by our winform controls and on this slide here I've just got an example of some of the markup that you can use and what that would actually render like inside the report or the report designer so again that can be quite useful and then about what you're seeing but I'm getting a lot of flicker happening with GoToWebinar at the moment so I apologize for that sorry it's looking alright from here so don't worry we'll take a look inside the designer and at the next element I want to show which is the summary editor using the smart tag here I've got the ability of actually getting to a summary and this has been around for a while where you can select what you want happening to a particular field but now if I choose this ellipsis I can actually invoke the summary editor I can select very easily what I want my summary running from say group and then I've got this list of summary functions one of the things that's also available as a new feature for the summaries is the ability to calculate weighted average so not only you have we've got this nice summary editor the team have also added in a new function for that calculation and of course here just to get rid of that error I should pick up doesn't really matter and I'm now gonna be calculating my weight based on another value the weighted average calculation is also available inside your expression editor using some W AVG for average but leave that on screen just for a second as I talk about another non visual element and that is some new security settings applied to resource access on your reports so inside the DevExpress security namespace we've added an access settings class which allows you to define some different access rules for those resources for example you might want to alter the way that people can access the report specific style sheets or layout serialization files you might want to lock down the static resources such as the images or the data resources being the JSON or Excel files you can now use the URL access rule and the directory access rule to specify what resources can be loaded from either all or specific URLs or all or specific file directories you can provide some custom logic and define custom rules to give you that granular control over what's going on there and then finally in this general overview we've got the X our pivot grid is now set to use the in-memory data processing engine as a default so again an improvement in performance what I want to do now is jump over to visual studio and invoke the visual studio report designer so at the moment I've got a basic project I'm going to right-click inside the project and say add a DevExpress item from the context menu and add a report just hit OK of a dialog and I'll just create a blank report for now couple of properties I want to highlight here the first one is the image picker so I'm going to drag a XR picture box over here and what we'll see now when we invoke the lookup for the image source it's actually going to use the DX image picker control giving access to any of the resources inside your project our collection of raster images or of course our ever-increasing collection of vector images and you can just quickly choose from there now whilst I'm in here one thing that applies to both the in the visual studio designer and also your end-user report designer for WinForms and I'm going to be going through more of the individual platforms in a second has some really nice new functionalities for example I have a file explorer open somewhere down here and in this file explorer I've got some SVG's what I can now do is literally copy and paste and the designer will determine that hey this is an image and therefore draw an extra picture control or an X our picture and paste that information in at the same time I could literally drag and drop an SVG file onto there as well that in itself is a for me a very welcomed feature because you might be working in say Photoshop or your favorite graphics program and actually be thinking it would be really nice to be able to just say I know paster a signature in there that you've worked on and literally this came straight out of Photoshop signing checks as Delina oh right okay yeah yeah yeah not only have we added support for doing that with images you can also do it for text rich text Docs HTML whether that's copy and paste or drag and drop it will create the necessary component on this design surface so the XR picture box and the X I'll label or the XR rich text and you can also drag another report definition into that design surface and it will replace what's going on with the active report as well so that's really quite nice I'll come back to looking at wind forms in a second but right now we're going to jump back to a browser and take a look at the asp net core products now Julie and one of the questions that I get asked a fair bit and I'm just gonna hand out to you for one second less what's the difference between when somebody mentions asp net core versus dotnet core fairly simple really dotnet core is just your I was going to say basic framework but we can't call it framework anymore so because it gets confusing with the.net framework so it's it's a collection of assemblies that can be you know used as part of your local support for your applications and all that kind of stuff face be done net core is built on top of that for your rendering of your applications over the web that's basically it excellent so the reporting engine has been ported to use the asp net core framework again use of that word and in version 19.1 we've added the support for the XR rich text control so that can now be used inside your SP net core reporting libraries we've also added support or JSON localization files using a localization service now some people may not be aware of the fact that we offer a localization service so once you log into your DevExpress account and you go to localization DevExpress comm you can actually come in and request translations for very quite a large range of different libraries and have them included inside your projects and one of the things that we've seen in this release is the JSON support for those like localization languages another thing for SP net core reporting is the inclusion of typescript definitions so as a result you can now get better support or code completion inside whichever development environment you're using with those TS extension files and finally for a spinet core we've added the ability for you to include custom configuration providers to the web report designer let's take a jump now directly over to wind forms itself and I'll switch back to the wind forms demo and start talking about some of the things that have been included across the board here first of all let's talk data Federation and I'm not talking Star Wars no Star Trek Star Trek Federation hey I'm old enough to remember okay the the whole reason behind data Federation is the ability to bring in multiple data sources and have them combined in a single set of queries that you can join data together now the question would be will why might I want to do that why is that useful where's the data can I come from so it could just be that using a legacy system or a large enterprise system one of the comments that we've passed on is that we're dealing with a post gdpr world where certain sensitive parts of data might be in a well-protected database somewhere else and you still got to join certain elements together in version 19.1 the data federation datasource supports the joint operation now we've already had people asking if we're going to satisfy things like Union and the answer is yes but that's going to be later on down the track so let's take a look at what's actually involved in creating a set of federated data I've got a blank report I'm going to come straight to data source and add a new data source I'll choose my data base for that and it's my Northland connection and just throw in the customers table now in this particular example I'm just going to be adding data sources I'm not too worried about the fact that then don't really mesh I'll be showing you a much cleaner example when I get to dashboards so going to add another data source this time we'll go with the JSON elements again I'll just grab that URL and next and then I'll select leave everything fully selected and then the third time I'm going to choose a new data source and I'm going to choose this data Federation option from the data source wizard wizard she's next this is where it's going to show me everything that's available and ask what I want to do so literally you'd go through you could come through and create a query and you can come through and manage relationships where you could set up your dependencies between the multiple elements there again more of that later on the idea here is just to show you how easy it is inside the report designer to get to that point if I switch to my field list you can now see that I've got this Federation data source which would be combining the results of those particular elements another new thing for WinForms report designer is the reusable Bands templates so let's switch to something a little more exciting like the invoice report again jump into the designer now previously for WinForms we've had the report gallery where we could drag and drop campaign or collection of components and reuse them now what we can do is actually click on the band and sorry bring up the context menu of the band and as you say add to gallery which means we do that with a detail band we can do that with the header band etc making it a lot easier to work with the creation of reports as we go through another feature inside the report designer here is the ability to use the loop for showing colors click on properties and here I've just got a field selected and we can see on the right-hand side of my foreground color we've got the loupe icon I click on the loop and we have this beautiful large bagg faint glass and you'll see as I go over any element we're gonna get the RGB or the hex color from anywhere on screen it doesn't have to just be within my my particular window it could be anywhere at all so I'm gonna choose the orange from the word invoice works if you actually click on the right color Julian you are so close I was ok and it will then return the result of back in do you think with a magnifying glass that big that's okay there's also some other settings that are available inside the refreshed look and feel if I come to a report level you can see that I've got access to the page settings so there's a page settings tab and sometimes it's the the simple little thing so if you've got a an expression field or a formula and you want to actually know what's in there you're not always going to have full access to that so what you can actually do is come along and just position your mouse over the element and you'll actually get the tooltip showing you exactly what's happening inside that expression so you don't have to go digging for it now we've got the segment colorizer x' for the XR chart control that's going to be covered in a lot more detail by Jillian and then you've got now got the ability for specifying the page numbers and multiple page ranges to print or export it sounds duplicitous but you can also specify duplicate page numbers to print multiple copies of the same page so that's now a valid range when you do that let's jump over and take a look at some of the things that's happening inside the web report designer for this I'll jump through and just really matter which one I invoke we'll go for the MVC reporting here we're going to see a brand new or an overhauled report wizard and this reduces the number of pages required to actually create a report and it opens in full screen so let's open up the web report designer I'll wait for it to finish drinks thing and then I'll close this menu down for a second so now when I invoke the menu and say new via wizard we can see that there's a lot more real estate being used to generate the report I'll say table report and next and we can see just on this next screen that because of that additional real estate that the team have made available were able to incorporate more on the single page minimizing the number of pages that we actually use to generate that through that wizard we saw a feature released in 18.1 and so the web report design that now has full support for vertical bands it also has the JSON data source support and authentication the typescript definitions so the same as the asp net core where when you're working inside the development environment you've got the code completion functionality and the web document viewer has had a number of performance enhancements done in by the way of improved memory consumption and there's also some new caching methods for both the report design preview and if you're working with Asia reporting let's take a quick look at life in WPF while this loads up WPF again has received that data Federation so you can generate a data sort that federated data source and combine your different elements now I don't believe I mentioned but that supports sequel datasource the excel JSON format entity framework XPO and the poco of the object datasource when you're generating the federated datasource there one of the things for WPF is now that the end user report designer has full support for the report gallery so we jump into the designer basically if you've watched any of the other webinars across the years about from when we introduced the report gallery it's now everything that's available in WinForms has been ported over to WPF so that's a welcomed option so here we have the report gallery down here you've also got those reusable band templates so again it's a new feature to version 19.1 for WinForms it's being brought straight into WPF we can add that into your gallery and you're gonna see it down here which you can rename reuse some enhancements for the end-user report designer include the ability to bring up the properties grid to actually control your favorites so when you jump in here you can then nominate what you want to see on your favorites panel there's some API updates for docking you can set the dock panel visibility and behaviors on start you've also got the ability to interact with the report gallery at that level as well as we saw with the WinForms elements if I jump on to a field and bring up the right bump when you hover over you've got that same mouse tool tip functionality across the text element the page dialogue the same as WinForms where you can control the output of the page setup' visual inside WPF and the XR chart showing those segments colorizer z' WPF it also has an export PDF changed there is full support for OpenType CFF fonts which is new as well before we move on to dashboards directly there's a couple of things for the report and dashboards server that I'd like to mention data models are now supported sorry the data model that now supports custom sequel queries so in in addition to being able to select from tables views and stored procs your main model can you can enter some custom sequel which is available in the sequel datasource wizard you can now also set your DB command timeout it deeds now if the configurable parameter on the data model and there's some new support for or extra support for themes in both the reporting dashboard designers there was one other thing I wanted to show which I actually have a slide for and that is which i think is a really nice feature the ability to auto-refresh into your dashboard now here I'm talking about the dashboard server product not just the general dashboards but if you are using that can that suite I think it's a great feature that's been added to be able to refresh that data at any given time switching tracks now let's start looking at some of the things that are available with dashboards on spring up the that my sensor and launch dashboards again will jump in and start looking at the wind forms demo first I mentioned earlier about the data Federation we looked at a couple of samples on how to actually create that data source now let's take a look at a good example where the data has been used and generating an actual report so here we've got the data Federation example and we can see that the sales data is coming from the object data source human resource from Excel and then we've got some combination of the two what we're going to do is jump into the editor change my data source here to get to Federation and come across two data source and edit so we can see what's going on here's the query builder showing clearly that the two data sources are mapped on this category field that we're bringing in the manager field and we've got all the sales fields so our output table is effectively showing these columns bound from these tables and of course you can mix and match there's many different data sources they could be the same data source type but from different locations they could be different data source locations or types as well the OLAP range filter has now got well sorry both the range filter and the date filter support OLAP data sources for all those people that are using cube style data repositories next we'll take a look at a new control we start with looking at the sales overview and we've got this date range control sitting down here now this is a great visualizer for picking a date range it does exactly what it's supposed to has the visual element allows me to quickly move around and of course I've got context sensitive functions to quickly jump into specific period so I could say yet today all those things but there's been a request that you can actually go in and have a date filter that's not taking up as much real estate there's not as visual from the aspect so I'm going to jump down to the customer support presentation here and we can see that the team's provided just that what we have is this nice low real-estate stealing element where you click on and we're going to be able to see each of the different things as I click through of course you get to control what's happening in this list and you can just use set filter if you want to come through and select a custom filter which would then bind all that data so a welcomed new component that's been requested some changes for the web dashboard basically the team went through and interrogated everywhere that a list could be used and this could be on dropdowns could be parameter values all sorts of things so let me just run up a web example and then what they did was said oK we've got to come up with a smarter way to a laser bill to look through this list and select what it is you want what it is you need so that's exactly what they did let's go down to energy stats and anywhere now in the web interface where there is a drop down list you've now got the ability of providing a quick lookup quick search type functionality that in itself the they've been going through literally everywhere that lists can be used and said is it possible that this particular drop-down can have a few hundred entries in it or more we then need to improve the way that that could be used so that's one of the things that they've definitely gone through and done it is still a work in progress there are things that they want to continue to improve but again is that it's iterative things to look for – between each of our releases the final thing that I want to talk about for a second is well sorry before I jump off web we as we saw with asp net core the localization enhancements so again that service providing those JSON format there are translation strings back I was on the WinForms one before and there's one very important thing that I wanted to highlight here and so I said because it's taken a lot of effort from the team to implement and it's you'll see we've got a sales overview board here and we've now got this new icon sitting over here and it's implementing State State management of your dashboard this one utilizes or for examples one of the things that the team's asked me to to convey is that they want you to play with the source code of this particular demo they want you to understand that implementing state management is really really easy and in fact one of the things that has happened with the WinForms product for this iteration is the fact that they've had to go in and refactor so much code to make this feature available it was introduced into the web version of dashboard back in 2016 it was introduced into WPF last year and it's finally made it into WinForms which is interesting because normally WinForms drives the other platforms this has been back-to-front but that's because they've had to go in and replace some very very old parts the code a lot of refactoring and in fact it took a lot longer than we anticipated to make this functionality available but it is now there where you've got state management for your windfall – boards I think Julian that means it's time for me to switch over for charting okay so let me just grab the screen as it were and make sure I select my name that would be bad okay charting thank you Paul for reporting and dashboards so now we go on to the other part of data visualization if you like and we've got several things to to show here and what's actually happened is similar kind of things as has happened to reporting your dashboards where we've implemented a new feature a new enhancement in one platform and migrated it to other platforms so I'm basically just going to show the WinForms version of this so I'll jump over to the charting demo notice we're using DirectX within within WinForms for charting so our render speed is much faster than is usual the first one I want to show is the segment colorizer so basically this is all about coloring parts of your chart automatically through in this case ranges so here we have daily temperature averaged over a period of time and what we've done is redefined a set of ranges of temperatures here so Center centroids are preferred Celsius so 25 30 20 to 25 and so on so forth we given them different colors and then we color the charts according to those colors where they appear on the x-axis sorry the y-axis so obviously the red means it's pretty hot and that's that particular section there and slightly dimmer red or less harsh red if you like into the next range and so on so forth so you get this kind of lovely way of visualizing temperature in your chart itself of the blue cold very cold to read very hot hot so we can also show a trend colorizer what we've done here is to say well if the temperature is rising at a particular period we'll color that in red because it's getting hotter and if it's dropping there will color it blue and so we have this kind of trend view of the girl the chart so in essence not only is a child providing direct visualization of these points according to time but we're also showing them in different colors and the different abilities for conveying information to your user and that's what charts really all about is conveying information rather than just looking at a table of data or some description so segment color eise's we've seen you know the range of trend point based colorize errs available twin forms and asp.net next up is a kind of fascinating wand it's the histogram we now have the ability to generate histograms for you so let me just reduce the number of series here so everyone's going mom I did it's been a long time since I learned all this stuff yeah what exactly is a histogram so imagined it's it's basically a statistical way of viewing your data imagine the time you know doing some kind of survey where I'm weighing different groups of the population and you know try to work out some kind of information that I can gather from say the population according to date range so I measure away people age 21 to 25 and then 26 or 30 and so forth and I get this kind of weird dot type thing where my argument the ages and my values of the weights and you imagine though you know people were very thin number of people very fat and you know you get this kind of weird distribution you can't really gain much of this information from this so the histogram is way of accumulating those points into a more if you like recognizable form so Libya withdrew with reduce the width a little bit of the resulting bar chart so these are basically the count of each points according to these particular intervals let's me Druce it even more and you get some basic shape if you like you could also show that as a spline sometimes people view bar charts as being histograms or you know confuse the two histograms are more about the statistical analysis of your data so histograms we have an aggregation function for that obviously we're inspired if you like by the way excel does histograms we have various calculation modes from there automatic the bin width and the bin number interval information display within the axis labels custom Idol customizable label text for overflow and the ability to like gridlines and tick marks with bins and so on so histograms available in wind Forbes and within WPF and also within asp.net so histograms hmm what's next on the list oh yes polar and radar views this small improvement here I'd say we now we basically just have one axis within payload and radar views because it's defined as a circle essentially and so the ability now to actually change the angle of the label of these various x-axis values so we can just change the axis labels to have a different angle maybe in some charts that you're going to be generating this will that should be a lot easier to read it's just a feature and that's available in asp.net and sorry in wind forms and in asp.net so we also have now the ability to Center align axes within the plot area so imagine you have some kind of chart which goes your arguments go from something negative to something positive and the same with your y-axis your values from something negatives or something positive it makes more sense to have your axes then on the zero marks of both axes rather than just on the left and on the bottom so we can central line axes within the chart let me jump over now to the WPF charting and here we have a couple of other features that I can talk about the first one is yeah here we are got the segment colorizer we certainly have the histogram support as I said earlier the next one down is the drill-down chart so what we're trying to do here is give you the ability to support some kind of hierarchical data and yes it's that magic word again hierarchical so you have some kind of data which if you like you can drill down into that data and reveal more information about that data so what we have here is have some horizontal bar charts each of these individual segments involve a separate region for this particular sales chart essentially so we look down and say oh this looks a little small dev AV West let me click on it and I'm drilling down now into that data for that particular region and that particular sales value and we can drill down even more and see individual charts and be able to maybe gain more information and understanding we can analyze the information they've drilled down levels as many as you like obviously three or four is probably too much and the interesting thing here is just to go back to something that I was demonstrating yesterday within our WPF segment is the new breadcrumb control here we have the breadcrumb control showing the different levels I'm at so that's the home they aren't drilling down into dev AV west of their particular region for this particular set of things and we're going into the headphone so I can you know jump back and jump back to home or if I drill down even on another one say I can just jump back home so the breadcrumb control in action here rather than just save the file exhort Explorer version I was showing yesterday so drill down as with all of our products we try and improve performance across the board whenever we can with WPF charting we've improved the rendering of 2d line series and financial indicators so there's less stuttering if you like as we're drawing in the chart so there's better frame rates during the interactive operations as well swimming and scrolling what-have-you so the improve rendering there we also support within WPF some new phone summary functions min max on average counts and so on so you can use those within your charts so I think next I'm going to jump into our asp.net core Charles now if I remember where I put that particular demo and here it is okay so our is but stopped again a speedo net core controls we've have some improvements in the charting area for asp.net core now obviously those of you in the note know that asp.net core or our controls for race we've got that core tend to be built on our dev extreme controls so the improvements aren't going to be talking about here apply to demyx stream as well skew thing first thing I want to talk about is the ability to have tooltips on the charts now so we can show tooltips as you hover over points in the chart and as you see from this particular example there is the ability to render the tooltips with some extra information we can render it essentially with HTML so there's some fun stuff that you could do there the other one a in general the the the simplest version of this just shows you the value of each point as you hover over it but certainly tooltips are now available when hovering over a point in a series as we see here another fun one is actually better that that initial demo here notice the labels here are visible for sure they don't overlap with each other that's always good what we've added now is a word wrap support for title chart axes labels pie chart and tree map labels so that you don't get any overlapping of the text with the next label so what I'm going to do here is I'm going to shrink the window and watch what happens to these labels as I shrink the window the first one to change is the inadequate cheese quantity label here notice we now wrapped that because obviously the the text is too long to actually fit in so we wrap that and as I shrink it more and more of these labels oh there's a separate thing here we're showing them on different lines but as we shrink more and more of them get word wrapped and so that is actually now built into our asp.net core kind of see DX def extreme a couple more I'm talking about overlaps is I don't have to you have a demo for this Oh we'll go back to the moon so we have here a funnel chart and this kind of overlapping problem has been around for a little while now where the labels are basically written on top of each other rendered on top of each other so we've added a new feature now and with the funnel chart the option for this particular property has three values one is none we we don't even bother we just render the labels as we see fit essentially and so we get this overlapping thing the next option for this particular property is shift where we try and shift the labels around so that you can see them without any overlap and the third option is hide basically we try and shift but if we can't even shift and get all the labels in without overwriting each other we'll just drop the label which is in for writing another label essentially and then the similar kind of thing with the bar gauge here the option has two two values here because of the way labels are shown within the bar gauge so here we have resolved labels none so we have the overwriting effect which is can be annoying and then we have the next option the other option is hide where we just say ok we can't actually display the label for this particular part of the bar gage so we'll just drop it essentially we're not will not show it and obviously what tends to happen is you can guess what the value is or you can hover over it let's go back a couple of steps the other great feature that we have now for it's been done that chord charts is the ability to add labels to the chart basically custom labels so as we see here we just have three custom labels here so we also do some kind of presentation we want to be able to show the chart with these labels and often they're not part of quote the chart and quotes they're just they're annotating information about the chart you want to draw people's attention to and that is pretty much it there are other minor things unless you're really interested many things about the charting but oh yeah there is one other thing is the react chart in package has been improved that's still in beta you can find out information about it on our website but that's essentially it for charting pore julienne and do we have any questions and presumably do have questions and all answered Oh watch it so yes we have already released some 19.1 but all the other questions have been pretty much well not much they have gotten answered by the team which has been fantastic brilliant okay so Amanda alright uh yeah thanks to the team for getting all those questions answered I did see one just pop up I don't know forward rap it happens to the text as the window shrinks and no more word wrap can be done does the text get smaller no we don't actually change the font size I think at that point we either do not display or remove well let's try it shall we let me just bring it up where are we did or did I close it no I didn't close it here it is boom okay so here we are we're now word wrapping nicely and it's getting smaller and smaller we Cantor's switched oh yeah we get to the point where reducing the size doesn't reduce the chart size anymore we just get to the final point okay cool and from Tony well histograms be made available for dashboards in the future oh yes for sure they're very confident yes they do the team just got told I'm not guaranteeing is going to be 19.2 but obviously with the dashboard what we're doing with the dashboard is we're using insight you know the charting products anyway so if a certain feature of the charting product should be displayed in the dashboard then why not we should be adding it to the dashboard support basically okay alright everybody like I mentioned before today's webinar will be available later on our DevExpress youtube channel you will also get a follow up email with links to all of our point one launch webinar recordings we do have two more webinars coming up this week tomorrow morning is deaf extreme with McCool and Don and then at noon tomorrow is what's new in coderush with Mark Miller and you can register now at DevExpress comm slash webinars and that is it for this one thank you so much to Paul and Julian thank you all for joining us and of course thank you for choosing DevExpress bye bye

One Comment

  1. Benjamin Ohene said:

    I think it would be nice to deployment to a real server as part of the demo. I have had trouble deploying a web dashboard to hosting server.

    May 22, 2019

Leave a Reply

Your email address will not be published. Required fields are marked *