Hi Travis,

Thank you for your purchase.

For creating charts you will need to use one string type column(string, date, DateTime...) and all other have to be integers and floats. If your table has those data then you can try to use the option Grouping charts.

Let me know is this what you looking for.

Hi Travis

If you are referring to entries when you say forms you can add a hidden field in the form that will add one after every form submission. 

Later you can add this column in the table which will be integer column type and you can use calculation functions to calculate a total.

You can showcase a table with those options, you can show the total value with a shortcode, but you will not be able to display that value on a chart.  

I hope this answers your question, but please send us some examples on how you would like to display the data or send us a recording so we can understand better. 

You can use the date-range filter for the date column, and when you create the chart, in the wizard enable "Follow table filtering". That will make the chart follow the filtering of the table. Then you can hide the table using some CSS and you will have only the filters and the chart shown.

you would first need to disable the following in table settings: 

"Show X entries" drop-down; "Info Block" from Display tab: 

"Enable main search block" from Sorting and Filtering tab: 

And "Table Tools" from Table Tools tab: 

Then, you can hide the table, leaving the filters above the chart like this:

<style>.wpdt-c .wpDataTablesWrapper table {display: none !important;}</style>[wpdatatable id=1][wpdatachart id=1] 

And that's it. This is how you'd create a page where you'd have Chart #1 dependent on wpDataTable #1 so it follows filtering, and the table hidden using CSS. 

I hope that helps 

Hi Travis

Unfortunately we don't provide support via Zoom or screensharing, but I can see the images in my previous answer were not sent properly so I will try and resend this again with the images, hopefully this will make more sense.

"Show X entries" drop-down; "Info Block" from Display tab: 

"Enable main search block" from Sorting and Filtering tab: 

And "Table Tools" from Table Tools tab: 

Then, you can hide the table, leaving the filters above the chart like this:

<style>.wpdt-c .wpDataTablesWrapper table {display: none !important;}</style>[wpdatatable id=1][wpdatachart id=1] 

Do let me know how I can provide more assistance, what step you are having issues with so I can try and provide a more detailed explanation.

Hi Travis

Each chart in our documentation mentions that one string or date column supported, and that goes for all charts.

Meaning you cannot add more than one string-type column (string, date, datetime, URL, email). The string-type column will be used for the X axis, and all other columns need to be integer or float. You will probably need to restructure the table, in order to get the chart you need.

Can you show me your table and the chart in Excel (for example), and I'll see if there's a workaround for what you're trying to achieve?

Here is a screenshot of the date range filter, but it coming from the table that is hidden, there is no specific date range filter specifically for charts.

Hi Travis

This would only be possible with an SQL Query table, where you would show only the last 7 days with one of these queries:

SELECT * FROM Table_Name
WHERE connect_time >= DATE_ADD(CURDATE(),INTERVAL -7 DAY);

or

SELECT * FROM Table_Name
WHERE connect_time >= DATE_SUB(CURDATE(),INTERVAL 7 DAY);

Without those functions, you can also do

SELECT * FROM Table_Name
WHERE connect_time >= (CURDATE() + INTERVAL -7 DAY);

or

SELECT * FROM Table_Name
WHERE connect_time >= (CURDATE() - INTERVAL 7 DAY);

then create a chart based on this table, turn on follow table filtering, place both the chart and the table on the same page and hide the table.

Now, there is a way to simply hide the table using CSS, leaving only the chart and the filters. Anyone who knows CSS will be able to still display the table if they were to inspect the page, and simply change the properties.

Since you need to show the filters, a simple css like this would not be useful, because it'd hide the filters too:

.wpdt-c .wpDataTables.wpDataTablesWrapper {
display: none !important;
}

So, instead you would first need to disable the following in table settings:

"Show X entries" drop-down; "Info Block" from Display tab:

"Enable main search block" from Sorting and Filtering tab:

And "Table Tools" from Table Tools tab:

Then, you can hide the table, leaving the filters above the chart like this:

<style>
.wpdt-c .wpDataTablesWrapper table {
display: none !important;
}
</style>
[wpdatatable id=1]
[wpdatachart id=1]

And that's it. This is how you'd create a page where you'd have Chart #1 dependent on wpDataTable #1 so it follows filtering, and the table hidden using CSS.