Hello Aggelos.

Thank you for your interest in our plugin.

When you're creating a chart, there's an option that needs to be enabled - "Follow table filtering". When this is applied, and both the chart and the table are located on the same page, you can add a filter to the table, and depending on the filtered values, the chart will follow. You do not have to include the Date column on the chart to do this.

For example, if your table has date column, string column, and values column, you can create a chart from the latter two.

Then when you place filters in a form above the table, you can filter the table only per date column, and chart will display values based on that filter. We can even help you hiding the table from front end, leaving only the filter and the chart.

Best regards.

Hello again Aggelos

I am sorry to disappoint you, but unfortunately something like this is not possible with the plugin's built-in features.

The filter can only use the format you've selected in general settings of wpDataTables. If you set the whole column to display only year (Y), you can do that. If you are creating a table linked to an existing data source (SQL, Excel, CSV or Google Spreadsheet), you can duplicate the date column, so the new duplicated column would show only the year. Then, you could filter per year, but hide that column, so it would show the full date (if that is what you need).

Unfortunately, that is the only workaround for this.

Best regards.