joeyoungblood

I believe what you are requesting is possible in our Premium version.

See the section about using variables in our documentation here: https://www.wpbusinessintelligence.com/documentation/

If you want to send an example query over for us to review before purchasing please use our contact form: https://www.wpbusinessintelligence.com/contact/

• This reply was modified 3 years, 5 months ago by joeyoungblood.

Hi James,

Apologies for the delay in responding to you.

I have reported this to our dev team as a bug and we are actively looking for a fix for this now.

Do you have a link I can share with our developers so we can better see the issue? Examples of data in your db column (demo / fake data please), chart type, and your query would be helpful too.

Note: You can also use our contact form to send information privately: https://www.wpbusinessintelligence.com/contact/

• This reply was modified 3 years, 5 months ago by joeyoungblood.

Since we didn’t hear back from you this is being marked as resolved. Please make a new post if you have further issues.

I checked the page you linked and do not see a WP Business Intelligence bar chart. I am seeing Google Data Studio embeds.

You can see a demo of our bar chart only here: WordPress Bar Chart Demo

• This reply was modified 3 years, 7 months ago by joeyoungblood.
• This reply was modified 3 years, 7 months ago by joeyoungblood.

Thank you for the kind words Miquel! We love your wildlife website and what you’re doing with WP Business Intelligence Lite.

Super happy to hear this!

Would you mind taking a moment and leaving a review for our plugin here on WordPress?

Just released a new version with a bug fix for this issue. Please let me know how that works.

Note about Names and Captions:

Names are currently for your information only internally. They do not display with your charts and graphs nor do they appear in your tooltips. If you had WP Business Intelligence installed previously then all of your charts will be named (null). You can rename them to anything you wish.

Captions always display below your chart or graph. If you do not want a caption to display for your chart or graph please do not add one.

Since WP Business Intelligence uses shortcodes to display you can always use the Block Editor, Classic Editor, or page builder of your choice to add custom titles above your charts and graphs and text below them instead of using the caption feature.

Hi Miquel, we have still not been able to replicate your error. However, we are still actively trying to determine what might be causing this so we can get a fix to you and your wonderful website.

This morning we launched 2 new versions with the second one being a bug fix for a problem we introduced. Please try and upgrade your plugin to v3.1.6 to see if that fixes your error.

You may also try contacting your webhost to see if they can find errors in your logs that might be due to a server setting.

Had this same problem with a client site, Subscriptions plugin was at the version cited by Claudio Sanches above has having the fix. Latest WP release, PHP 7.3.

Client opted to use a third-party solution instead of continuing to pay an annual fee for a broken subscription plugin.

Thank you Miquel for this video. We are looking in to this now and get a fix for it as soon as we can.

We have not been able to replicate this issue on WP Business Intelligence Lite inside of our test environment. Would you be able to take a quick screen recording video to better show me what is happening? You can use Loom or a similar service to record your screen and share a link to that recording: https://www.loom.com/

Hmmm thanks. I believe I fully understand the issue now, that should help us troubleshoot it.

This looks like an SQL error. If I understand correctly you are trying to display tables by using the page id in a dynamic query to automatically display the correct chart instead of creating an SQL query for each chart and displaying via separate short codes is that accurate? If so, this may have worked until our v3.1.3 when we udpated our underlying architecture to latest stable releases.

I will pass it on to my dev team and we will try and troubleshoot, but if you’re using the plugin outside of how it was built to be used (i.e. not querying a live database to generate one chart from the tables) you may run into problems.

We just released a new version, the only real change is giving a few more chart types to the free version of the plugin. Please let me know if it deactivates on you again. We tested this in various configurations and haven’t been able to replicate the issue.