Hello Mark.

There are a few ways of achieving this. Although, it may not look exactly the same as it does in the example URL.

Let's say you have six tables: "NFL", "NBA", "MLB", "NCAAF", "NCAAB", and "NHL". You'd store all this data for each table individually, so all six tables would have "Year", "Bet Type", "Record", "Win %", "Money Won" and "ROI".

Those buttons that would allow you to select a sport would be generated by either JS, CSS or some button-generating plugin. It'd call the table by using its shortcode, and then change the display for each sport. Then, years would be displayed by using filters. Chart for each table would have to be made separately, and every sport would have a separate webpage where the table's and chart's shortcode would be, and "Follow table filtering" would have to be turned on in order for chart to follow the years when you click on a filter. You can read more about charts in our documentation.

The other way of doing this would be to have a single table with all sports in it. Then all those buttons would simply be filters, and it may be even easier to do. You need a column for each sport, and then a column for each year. In order to use cascade filtering, so you can only choose a year if you select a sport, you'd need to acquire Powerful Filters and use them on that table.

Basically a table consisting of all the data you need would be filtered on the same page by using filters and cascade filtering so you only have one table and one chart.

I hope this helps.

Best regards.

Hi Mark.

I tried to make a chart to go along with the table, but the chart did not allow me to have 2 columns that are strings so I was not able to have years on the x part of the chart and money won on the y part of the chart.

I'm guessing you set the "money won" column be string because of the $ character, correct? It needs to be an integer column, so you'd be able to use it. You can add the $ sign as a default cell prefix, under column settings:

Powerful filters is a great add-on, but please read more about it in our documentation before purchase, to see if it fits your needs.

As for having another table with the same info - yes that is possible. You can either create a new table by Generating a query to MySQL database, and then use the table you already have by selecting its name (it can be found under "Editing", when you enable "Allow front-end editing" slider - the name is usually wp_wpdatatable_#).

However, one filter cannot filter through multiple tables - global filter is not available, so You'd need a new filter for this Copy of the existing table.

Basically, the final result cannot be the same, but something similar is doable. Unfortunately some limitations, like global filters, and default behavior of charts cannot be changed.

Also, please note - if your table is very big, the chart may not render or the table load will time out (usually after a couple of thousand rows).

I hope this helps.

Best regards.

Hi Mark.

You're correct - cascading filtering from Powerful Filters would be able to do this.

If you want the filter default value to be NFL, you can change it in the column's settings:

So just set the Predefined value to be "NFL" and it'll load that by default.

Same goes for the year column.

Again, for the options to change based on the sport, you'd need the cascading option.

Best regards.

Hi Mark.

Before answering all your questions, can you please provide me a temporary WP-admin login for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course we do not provide login data to third party. You can write credentials here just check Private Reply so nobody can see them except us.

Best regards.

Hi Mark.

I removed the blank space from the select box. Please clear cache and perform a hard reload of the table if it doesn't apply right away.

Please save this, because you'll have to do it again once the plugin updates:

You have to make some changes in code. In file wp-content/plugins/wpdatatables/assets/js/wpdatatables/wdt.columnFilter.js: around line 667 you will find this:

select += '<option value="">' + ' ' + '</option>';

and you have to comment it like this:

//select += '<option value="">' + ' ' + '</option>';

Also, you have to set option Number of possible values to load to All on Data tab in column settings. 

You're correct about the powerful filters - when cascading is selected, there's no way of entering a pre-defined value.

Unfortunately, this is implemented in the code of the plugin, and can't be changed that easily. This is achievable with some custom work, which unfortunately isn't covered in the included support of the plugin. We can offer you our paid customization service where you can hire one of our developers to implement this feature for you. If you are interested please let me know, and I can send you quote for this service.

Best regards.

Hi Mark.

No, unfortunately it can't be changed there.

The search appears for limited Number of possible values to load. So, again, you have to set option Number of possible values to load to All on Data tab in column settings for it to remove the search.

And again, make sure to delete cache and perform a hard reload to apply the changes if they don't apply right away.

As for conditional formatting:

IF sport column is set to NFL, Time range column should display Since 2010, 2010-11, 2011-12, 2012-13 - unfortunately conditional formatting between columns is not possible.

So, custom work for Powerful Filters would be the only way to have cascade filtering enabled.

Best regards.

Sorry, Mark.

I forgot to mention that "Use minified wpDataTables Javascript" slider has to be disabled for the feature to work on front-end.

I apologize for that. I've disabled it, and now the empty value is hidden from front-end as well.

Best regards.

Here's the attachment of the settings.

Best.

Good to hear that it works, Mark.

There is a way predefined values can work with Powerful Filters, but it would require changing a few .js, .css and .php files in the code. So, it's not as simple as commenting lines of code, etc. and that's why it falls under customization which is offered through paid custom work.

You can take a look at ../wp-content/plugins/wdt-powerful-filters/assets/js/wdt.pf.backend.js

If you were to change the following line of code (around line 126) from:

.prop('disabled', true)

to:

.prop('disabled', false)

You will be able to set a pre-defined value. And the table will filter with these predefined values.

However, let me show you an example:

Predefined values for SPORT and TIME RANGE are there and the table filters correctly. You will not be able to select the rest of the filters until you select a different value for SPORT filter, and switch back to NFL. Same goes for TIME RANGE.

For instance, you change the line of code mentioned above, and you enable predefined value while using cascade filtering; so you have two predefined filters:

NFL; Since 2010; THIRD FILTER; FOURTH FILTER

Since 2010, THIRD and FOURTH filters will still be disabled, even though the Since 2010 is loaded. So, you need to click on another value in SPORT (for instance NBA), then click back on NFL to be able to select the "Since 2010" again.

You're welcome to explore the .js and .php files and to try and make it work.

Other than that - again, we can offer paid custom service for us to implement this.

The reason Predefined values don't work with Cascade filtering is simply because it would allow users to select a predefined value for a column and then try to apply the cascade logic - so if a user sets a predefined value for the third column, cascade filtering becomes non-cascade filtering - obsolete function.

The issue has been forwarded to our development team, and we added the idea to our list, to enable pre-defined filtering at least for the free (independent) filtering.

Best regards.

Hello again Mark.

The price for customization is $50 per hour.  If you are interested please let me know, so I can forward the request to our developers, and if they have time to do it I'll send you a quote for the service with the final price.

Best regards.