claudio
Forum Replies Created
-
Forum: Plugins
In reply to: [WP Business Intelligence Lite] pre sales enqHi Paul,
you will find some more information on our web site.http://www.wpbusinessintelligence.com/project/sunburst-chart/
Claudio
Forum: Plugins
In reply to: [WP Business Intelligence Lite] Showing numbers instead of set Labels?Hi,
you can have one value and one label selected.
So in your case you are selecting too many columns of your query resultset.
Please have a look here:
http://www.wpbusinessintelligence.com/products-and-services/wp-business-intelligence-faq/how-do-i-create-a-pie-chart/The value gives you the size of each slice, while the label should be one column of the resultset.
cheersForum: Plugins
In reply to: [WP Business Intelligence Lite] Parse error during installationVersion 1.6.7 should fix this
Forum: Plugins
In reply to: [WP Business Intelligence Lite] Axises are not showing upThanks, can you show me the query result as well please?
Forum: Plugins
In reply to: [WP Business Intelligence Lite] Charts not showing up after updateA change in the table visualisation does not seem to be supported by all jQuery version. We rolled back the change in v 1.6.7
Forum: Plugins
In reply to: [WP Business Intelligence Lite] Chart is not showing on dashboardNo news on this since 4 months.
Forum: Plugins
In reply to: [WP Business Intelligence Lite] UserIDAfter fixing the SQL query and a bug in the plugin, this is closed.
Forum: Plugins
In reply to: [WP Business Intelligence Lite] Axises are not showing upWhich chart? Is it visible publicly?
Forum: Plugins
In reply to: [WP Business Intelligence Lite] Parse error during installationHi it is due to an array declaration that is not supported by your PHP version. I updated the file with a more standard one. Please download it again.
Forum: Plugins
In reply to: [WP Business Intelligence Lite] UserIDIn the picture received you still use
Login1 = {{{user_ID}}}
please use
Login1 = {{{user_login}}}
have you tested your queries in MySQL? Do they work there?
Forum: Plugins
In reply to: [WP Business Intelligence Lite] UserIDuser_ID is a number, did you try user_login?
is there any record where login = a number?
this number is the ID of the currently logged in user
user_ID is a number
in the screenshot sent you expect that this number is = Login1Forum: Plugins
In reply to: [WP Business Intelligence Lite] UserIDuser_ID is a number, did you try user_login?
you need to understand the type of data you are manipulating in order to write consistent queries
Forum: Plugins
In reply to: [WP Business Intelligence Lite] Doesn't display chart on the pageHi can you please check if you have any error in the JS console (Ctrl+shift+I)? Sometimes this issues are caused by corrupted data that crashes the JS charting library
Forum: Plugins
In reply to: [WP Business Intelligence Lite] UserIDOK I see that there is no UserID column in your table so you cannot use it in your WHERE clause. WHERE clauses work on existing columns.
please try this
SELECT
MAX(IF(field_name=’number-Glucose’, field_value, NULL )) AS ‘Glucose’,
MAX(IF(field_name=’date-glucose’, field_value, NULL )) AS ‘Date1’,
MAX(IF(field_name=’Submitted Login’, field_value, NULL )) AS ‘Login1’
FROM wp_cf7dbplugin_submits
WHERE
Login1 = {{{user_ID}}}Forum: Plugins
In reply to: [WP Business Intelligence Lite] UserIDIt’s a matter of debugging the SQL query.
Did you compare your results with the ones obtained in the MySQL workbench? What happens if you replace {{{user_ID}}} with an actual user ID?
And most of all, are you sure that your form data are not serialized?
Is field_name a column of the wp_cf7dbplugin_submits table?What happens if you run this query?
SELECT
*
FROM wp_cf7dbplugin_submits
WHERE
UserID = {{{user_ID}}}