DevExpress Dashboard – New Date Filter (v19.1)

Our list of item types to use with the DevExpress Dashboard is always growing. For our v19.1 release we are introducing the new Date Filter, bringing the total count of Dashboard Items to 18.

Obviously the Date Filter works with dates, and it competes with the existing Range Filter that can also be used to select date ranges. Here are the two item types for comparison:

Range Filter and Date Filter

So what are the differences?

A main difference is the visual size of the widget. Range Filters are designed to display data and provide interactive filtering functionality at the same time. Like most data visualization widgets, they require significant amounts of space in a dashboard layout. For some scenarios, they are too large – we analyzed common setups and found that Range Filters used an average of 15% of dashboard space.

On the other hand, the Date Filter is a widget designed specifically for filtering purposes, and not for visualization. Sometimes you know exactly which date ranges you want to analyze: full calendar or fiscal years, Christmas holidays, dates before or after a marketing campaign, etc. That last scenario implies open-ended ranges, which are not currently supported by the Range Filter.

Date Filter Features

Here is a summary of the new Date Filter features that distinguish it from the Range Filter.

Compact Widget

Compact Date Filter Widget

The smallest Date Filter view is a Date Picker button. In the test scenario, it takes up only 2% of the dashboard space.

Quick Filter Buttons

Quick Filter Buttons

You can add a custom set of predefined ranges for your users. The buttons provide a more obvious selection UI than the Custom Periods functionality of the Range Filter.

Using Quick Filters increases the required screen area to about 5% to 9% in our tests. They can be combined with a Date Picker or used stand-alone.

Vertical Arrangement

Vertical Arrangement

This option is crucial for some dashboard layouts. Our Customer Support Demo shows a common use case.

Filter Options: Before Date, After Date or Exact Date

After Date Filtering

Of course the Date Filter can select exact dates, but it also supports open-ended filtering ranges that begin or end on the date picked by the user.

Start Using Date Filter

The new widget is supported on all platforms – just add a Date Filter item to your dashboard. Alternatively, you can convert an existing Range Filter to a Date Filter using our Item Conversion functionality in the Web Designer or the WinForms Designer.

Feature demos for the Date Filter are available in the Web Dashboard Demo as well as the Customer Support Demo mentioned above. Finally, if you have v19.1 installed on your machine, you can follow this link to start the WinForms Dashboard Demo and this link for the WPF Dashboard Demo.

Please Let Us Know Your Thoughts

We would appreciate it very much if you could submit your response to this short survey:

Webinar

Please use the link below to register for our upcoming Dashboards and Reporting webinar, where all new features of the v19.1 release are demonstrated.

Register for the Dashboards and Reporting Webinar

9 comment(s)
Andrey Makhorin
Andrey Makhorin

Great!

Is it possible to use this filter as standalone control, without dashboard (web, WinForms, WPF)?

30 April, 2019
Andrey (DevExpress)
Andrey (DevExpress)

@Andrey Makhorin

Thank you!

So far we have not planned to release it as a standalone control.

We used only regular DevExpress controls for every platform, so I believe you should be able to create the same UI and UX based on our idea.

30 April, 2019
Nate Laff
Nate Laff

Super rad. Will change the majority of my range filters to this new widget for sure.

30 April, 2019
Baldur Fürchau
Baldur Fürchau

This sounds good, but i have another problem with dates:

In USA it exists "Fiscal"-Calendar like 544/454/445-Weeks.

So each quarter contains every time 91 Days and 13 Weeks.

The value 544 means, first Month as 5 weeks, second and third have 4 weeks.

Every view years you get an additionl leap-week, so this quarter as than, for example, 545-Weeks.

So the calculation of weeks, months, quarters and years are depending on each individual calendar. And: each company has its own fiscal-calendar.

So your new date flter wouldn't help for this cases, because our USA-Customers wont to show the dashbords summarized and compared within this fiscal year!

en.wikipedia.org/.../4%E2%80%934%E2%80%935_calendar

Additional in Germany, many companies have a "shifted" calendar, for example, the Business year starts every time with 1 of April. So the calcualtion of Quarter and Halfyear must know this.

Did you plan such a feature for calculation such a calendar?

Has anyone else a similar problem and how does he/she solve this with the current dashboard?

1 May, 2019
Andrey (DevExpress)
Andrey (DevExpress)

community.devexpress.com/.../devexpress-dashboard-new-date-filter-v19-1.aspx

@Baldur,

Thank you for your detailed explanation.

No doubt the "fiscal years" feature is on our radar, but it was not included in our Roadmap 2019 because we gave preference to other features based on our customers' requests.

Currently, you can use Calculated Fields to create custom Date grouping based on your requirements.

I will pass your requirements (both regarding fiscal years and in "4-4-5" custom grouping) to our R&D team.

6 May, 2019
Ryan Smith_2
Ryan Smith_2

Does this work with OLAP datasources? I am not having any luck with getting it to bind to a date Dimension so far

22 May, 2019
Andrey (DevExpress)
Andrey (DevExpress)

Yes, Date Filter Item is supposed to work with OLAP DataSources.

If you experience any problems, do not hesitate to open a support ticket so we could review your use case.

https://www.devexpress.com/ask

23 May, 2019
MALTA
MALTA
Hi it would be REALLY nice if you could implement the Fiscal Year logic.  In our case the Fiscal Year starts on 1st Feb.  Hence the YTD must start from 1/2/2019 up till current date.  You mentioned calculated fields, but we are using the dashboard and OLAP and in this case it is only a dream that we've waiting for years
19 September, 2019
Andrey (DevExpress)
Andrey (DevExpress)
@MALTA
Thank you for your feedback!
I have passed it to our R&D department. We will take it into account while planning a Roadmap for 2020.
23 September, 2019

Please login or register to post comments.