Hello. On my website I want to create several speedometer charts each showing a single number from a sql query of a non Wordpress database. The sql queries are a simple count with each only differing by the where clause. I can see create and see the tables in wpdatatables but can’t find where to extract the resulted number into the chart or even display the number without the chart. I’ve watched several tutorials but can’t find on that displays like I need. Any help appreciated.
Charts can only be created from existing tables, so if you don't have any issues creating SQL Query based tables, you can create charts from the data in those tables without any issues.
If you need several charts from multiple columns of a single table, you simply need to create several charts using different columns.
I'm sure you already know this, and I just don't understand what you're trying to do here, so can you please explain in a bit more detail, and maybe share some screenshots with me?
Hello. On my website I want to create several speedometer charts each showing a single number from a sql query of a non Wordpress database. The sql queries are a simple count with each only differing by the where clause. I can see create and see the tables in wpdatatables but can’t find where to extract the resulted number into the chart or even display the number without the chart. I’ve watched several tutorials but can’t find on that displays like I need. Any help appreciated.
Hello Jeff
Thank you for your purchase.
Charts can only be created from existing tables, so if you don't have any issues creating SQL Query based tables, you can create charts from the data in those tables without any issues.
If you need several charts from multiple columns of a single table, you simply need to create several charts using different columns.
I'm sure you already know this, and I just don't understand what you're trying to do here, so can you please explain in a bit more detail, and maybe share some screenshots with me?
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables