Significant features for both Dashboards and Pivots come with 5.3.3. Aggregation by readiness or compliance severity for pivots provides an important executive perspective of the data. When combined with all the existing flexibility of pivots, this makes many new views possible. Card and list widgets in dashboards bring a useful scorecard style and as well as additional detail. Lists themselves have many improvements including an additional filter and column of Primary Device, along with a new Between operator for date values. Automated onboarding is a customisation our consultants often get asked for, so I'm now very pleased to bring this to the UI making it easy for end users to set up and support this themselves. Lastly, opening up the Evergreen API for lists enables a new level of integration with powerful third party reporting tools such as PowerBI.
Additional widget types of card (DAS-15077) and list (DAS-14386) are now available on Dashboards. The card widget displays a single value, for example the number of red devices in project. This is useful when you need to highlight a KPI on a dashboard. The list widget can display multiple rows of data from a list, this is useful when you want to add more detailed information to your dashboard.
Date ranges can now be specified for date filters using the Between operator (DAS-13831). This is an inclusive range that returns all rows that have a value that is on or after the start date and before or on the end date.
Automated onboarding (DAS-14965) facilitates a hands off approach to including new objects in your Evergreen project. If you are confident that new objects which fall inside the defined scope should be onboarded without the need for vetting them first, this can be done on a scheduled basis. Out of the box schedules can either be daily or tie in with existing scheduled transform runs. Custom schedules are also available via SQL Server agent.
Pivots now have aggregation support for compliance and readiness fields (DAS-13860). This means that you can create a pivoted view and show data aggregated on the highest severity of compliance or readiness. An example would be to create a pivot with project buckets for row groups, no columns and a stage for the value with an aggregate function of severity. Also in pivots there are more specific sort orders for Operating System, Service Pack or Build (DAS-13862) and task value columns (DAS-13864).
Subscribe here to receive the latest Dashworks Release Notes via email.
