claudio
Forum Replies Created
-
Thanks
I meant what type of charts are these? Just to give me a direction for debuggingHi, I’m sorry about that. I cannot reproduce the issue so for now I rolled back to 1.4
Can you please let me know which type of charts/table are you using?
thanks!Forum: Plugins
In reply to: [WP Business Intelligence Lite] IsTime doesn't work with TIMESTAMP type?The latest version of the plugin (1.5) to be released in sept 2014 is supporting MySQL timestamps via UNIX_TIMESTAMP to be used in the query.
e.g.
select UNIX_TIMESTAMP(date) as date, price from stocks order by date ASC
Forum: Plugins
In reply to: [WP Business Intelligence Lite] Passing variables into queryWPBI is able to parse WP specific variables as they are common to all WP install. On the other hand product ids that are specific to a given e-commerce plugin cannot be handled. Unless your e-commerce platform uses posts as products. in that case you could use {{{post_id}}} to identify products.
Forum: Plugins
In reply to: [WP Business Intelligence Lite] Error 404 when creating queryGot no news after 4 weeks so I suppose this is resolved.
Forum: Plugins
In reply to: [WP Business Intelligence Lite] Chart shows NULL as 0Thanks for your feedback, unfortunately this is not something I can change as it is a behavior implemented in NVD3. In order to get the desired behavior we should implement the charts directly in D3JS. See this post for details.
http://stackoverflow.com/questions/10826180/in-d3-js-skip-append-for-null-dataForum: Plugins
In reply to: [WP Business Intelligence Lite] problem with limit in queryHi Omid,
I’m not sure I understand. When you use limit you are limiting the result to the first N records. So the behavior seems correct. Have you tested your query in a SQL editor? What’s your expected result?Forum: Plugins
In reply to: [WP Business Intelligence Lite] Chart shows NULL as 0I am afraid I cannot do much about that because the data integrity is handled by d3js. When D3 receives NULLs these are read as zeros. I think that if possible you should try to clean your data in the DB.
The PHP code itself is data agnostic and does not interfere with what is retrieved from the DB.Forum: Plugins
In reply to: [WP Business Intelligence Lite] Error 404 when creating queryThe DB is not affected if you remove the files. So please just try to replace the new version folder with the old one.
Cheers
ClaudioForum: Plugins
In reply to: [WP Business Intelligence Lite] tooltip & background not work in line chartThanks for the follow-up Omid.
The behaviour when very few data are present is managed by d3.js and for now it’s not really configurable.
cheers
ClaudioForum: Plugins
In reply to: [WP Business Intelligence Lite] Error 404 when creating queryOk and if your roll back to the previous version the error is gone? Can you just replace the plugin directory with the old one?
Forum: Plugins
In reply to: [WP Business Intelligence Lite] tooltip & background not work in line chartHello isk,
I just tested version 1.3 downloaded from the WP site and I get the tooltips for the line chart. Are you sure there is no conflict with your theme? I suggest to have a look at the JS console to look for any error and then test the plugin with a different theme.
cheers,
ClaudioForum: Plugins
In reply to: [WP Business Intelligence Lite] Error 404 when creating queryHi,
you said it was working fine and then broke?
What did you change?
Any error in the JS console? In the PHP log? The 404 is on which page?It looks like the values selected make no sense. You should have a single column selected as “value” and another as “label”. In your dataset I see several values from zeros to dates. This makes no sense for a pie chart. You should have one data serie with numerical values (the pie slices) and another with the text labels.
OK thanks Bob, good luck with your investigation.
cheers,