How many here figured I was addressing you, in particular?
A Tutorial on Queries for Charts would be timely.
It is hardly addressed by current docs & tutorials, as far as I can tell.
Dashboards for Clients with various “Business Intelligence” chart illustrations is a Big Current Trend now at least a few years in its growth.
But what I see is that Microsoft dominates with tools.
Oracle, Salesforce & other companies have met this corporate demand with high-priced cloud & very high-priced desktop installments.
But Wappler is one of the few applications that touts being able to configure charts with Live, Dynamic data straight from the database connection. Most solutions require uploading json or csv “fixed” data.
Who routinely is generating dynamic charts with filters using Wappler DMXConnect queries that can handle multiple conditionals per database columns?
SELECT a.article_id, a.name, a.address, a.state, a.question1, a.question2, a.question3 (etc…)
where (a.question1 = 'Book store')
OR (a.question1 = 'Coffee Shop')') (etc ...)
FROM online_form a
Where I have another 10 columns of text variables to Group into their own filters.
I want to present a chart that by default contains bars for all the query categories accounted for.
Then the User clicks which Categories they want to be Excluded and the Query dynamically changes with each Category filter Excluded or re-clicked to be Included again.
If this is a server side php to mysql query do you routinely use CASES in mysql to name filters?
Or in the browser, pull all data, then use javascript related filters acting on json data in the browser using Redis, for example?
I realize there are so many “solutions” in use today.
So I want to confine creating my own project to techniques in use by Wappler-ites in MySQL and node.js projects.
Or can you point me to a deeper tutorial using Wappler as the one-in-all tool?
Thank you for thoughtful replies!
Last updated: