If the data preview can see the data, why can't the chart preview get the data?
F
Fathia Jama
started a topic
over 1 year ago
I have a couple of dashboard charts, both on the same table. Both of the queries behind them will produce data no problem in the Query Data Preview. In the chart preview, with charts are set up the same as other entities that DO work, both the charts for this entity I get a popup that says "Unable to retrieve data from the server"...I also get "Unable to display the chart. Some validation have failed" on the preview window. So if the data preview can see the data, why can't the chart preview get the data? (since I have almost identical queries and charts that work with other entities...the only difference is that the tables are different).
Best Answer
F
Fathia Jama
said
over 1 year ago
When queries are run for charts they are embedded into another query like this :
select x, y from (select x,y) group by <your_chart_categories_and_series>
This means that if your query contains a semicolumn ";" in the end, it won't make your chart appear, but will make you Query Data Preview appear.
Also, depending on your database, some functions and other "order by" statements cannot be embedded.
You can find the root cause of your issue if you have a look at your Error log.
In version 5.3.4, a dashboard validation was added if a user has added a semicolon.
1 Comment
F
Fathia Jama
said
over 1 year ago
Answer
When queries are run for charts they are embedded into another query like this :
select x, y from (select x,y) group by <your_chart_categories_and_series>
This means that if your query contains a semicolumn ";" in the end, it won't make your chart appear, but will make you Query Data Preview appear.
Also, depending on your database, some functions and other "order by" statements cannot be embedded.
You can find the root cause of your issue if you have a look at your Error log.
In version 5.3.4, a dashboard validation was added if a user has added a semicolon.
Fathia Jama
I have a couple of dashboard charts, both on the same table. Both of the queries behind them will produce data no problem in the Query Data Preview. In the chart preview, with charts are set up the same as other entities that DO work, both the charts for this entity I get a popup that says "Unable to retrieve data from the server"...I also get "Unable to display the chart. Some validation have failed" on the preview window. So if the data preview can see the data, why can't the chart preview get the data? (since I have almost identical queries and charts that work with other entities...the only difference is that the tables are different).
When queries are run for charts they are embedded into another query like this :
Also, depending on your database, some functions and other "order by" statements cannot be embedded.
You can find the root cause of your issue if you have a look at your Error log.
In version 5.3.4, a dashboard validation was added if a user has added a semicolon.Fathia Jama
When queries are run for charts they are embedded into another query like this :
Also, depending on your database, some functions and other "order by" statements cannot be embedded.
You can find the root cause of your issue if you have a look at your Error log.
In version 5.3.4, a dashboard validation was added if a user has added a semicolon.