The latest release of the Syncfusion Dashboard Platform features new data connections, dynamic parameter handling, stored procedures, the ability to embed the Dashboard Server in any of your applications, and much more.
Connect files (CSV, Excel, JSON, text documents) uploaded through the File entity to the logged-in Dashboard Server from the Dashboard Designer connection dialog.
Connect web data sources that return JSON results or individual files that contain JSON strings in a nested structure.
Display dates in a fiscal year format by setting the preferred fiscal year start month.
Execute stored procedures that include default-value parameters and pass null values to a parameter.
New expression functions have been added to calculate percentage of total (TOTAL), running total (RUNNINGSUM, RUNNINGAVG, RUNNINGCOUNT, RUNNINGMAX, RUNNINGMIN, RUNNINGVAR, RUNNINGSTDEV), and row number (INDEX).
Add an infinite number of rows by dragging or resizing the widgets beyond the last row, allowing more widgets to be accommodated in a dashboard. Widgets can also be varied in size to look elegant on the designer canvas.
Filters and other visualization widgets are optimized to render well even in smaller spaces, and to show more widgets in the visible area.
Set automatic refresh times for the dashboard as a whole or specific widgets on an hourly, daily, weekly, monthly, or yearly basis.
Set a date range as a parameter in literal mode and bind multiple values to a parameter in list mode.
Link the image widget with other tabs in a dashboard, across dashboards, and with internal and external URLs.
Customize mouse and touch actions for a widget related to filter, linking, and drill-down operations at run time.
Decimal and group separators can be customized as part of number formatting.
Show data labels across regions in the map widget. Toggle their visibility based on your needs.
Bind one or more standard shape formats at the same time to recognize data values of the same column that satisfy any of these formats.
Measure formatting support is provided for 100% stacked charts.
Customize start value, end value, and intervals of the primary and secondary value axes in the chart.
Set one or more items to be selected by default based on their indexes in the combo box during design.
Measure formatting, linking, custom themes, date formatting, and advanced date formatting are supported in custom widgets.
Compact view enables card items to be arranged in a legible manner with optimized contents.
Toggle the visibility of each item in a card through the settings available in the properties window.
Customize the background color, font color, indicator, and range limits in the card widget. You can also add or remove ranges.
Display sparklines in the card widget to represent the actual value distribution based on a category.
An additional metric can be showcased along with the actual and target values in a card by adding it in the new “custom value” section.
Card elements can be aligned individually as needed.
Card elements have been optimized to use the same font size as other card widgets spanning equal cell size and with similar elements.
A tree map in drill-down mode will render faster than before with on-demand data loading enabled.
Sort rows based on the measure column values in pivot grid.
Drill states can be persisted during initial rendering, exporting, and maximize operations in the pivot grid.
Dashboard Viewer is now compatible with Angular 4 and 5 frameworks.
Visual Studio extensions for the Dashboard Viewer are provided for use in ASP.NET Web Forms, ASP.NET MVC, and ASP.NET Core applications.
Connect to file data sources and retrieve the files to host in the Dashboard Server. Set permissions for users and groups to access them.
Pin the dashboard widget to the home page and include the applied filters.
Windows Server 2016 VM installed with the Dashboard Server is now available in the Azure Marketplace.
Connect to previous versions of the Dashboard Server right from v126.96.36.199, in addition to the current one.