Any Way to Pass a variable into a MYSQL Query with Local Database

Hello,
The tool would need to be customized to fulfil your requirements, Please contact our Sales team via Contact us -> Request a Quote form, We'll look into it.

This would be for the end users in the front end.

-Eugene

You want to have the capability in frontend to change the parameters to display different data by specified time frames or it is required in backend module parameters?

I am looking at creating a large number of charts. For each of these charts I will need to have the data displaced by current/previous week, month, and year. So if I have 10 base charts in order to cover all of these time frames I would need to create 60 charts.

With that said is there a way to have a single chart where I can pass into it the changes that are necessary to display the data by the specified time frames.

For example I have an orders by store chart. I then could select within the cart current week to display the same data but for the current week, or previous week to display the data for the previous week, current month, previous month, and so on.

Regards,
-Eugene