Hello Lena

Thank you for your interest in our plugin.

Charts created with wpDataTables can't be filled in any other way other than by adding data in the table the chart is created from. Also, for them to be filterable, you will need to add the chart and the table on the same page, and enable "Follow table filtering".

Now, the plugin doesn't yet have an integration with any payment plugins (like WooCommerce, although we are working on that), so to create a table from an actual order, you will need to create a custom SQL Query based table, which will pull the needed data from your database. Doing that requires some knowledge of SQL, and we can't help you with it, because support doesn't include writing custom SQL queries.

You can try using our SQL query generator, but that's not an ultimate generator, and it should be treated as a helper for constructing queries.