Hi, guys!
I want to create simple Pie Chart with MySQL datasource.
I use two simple querys:
SELECT SUM(amount) as Monthly FROM tblhosting WHERE domainstatus = 'active' and billingcycle = 'Monthly';
SELECT SUM(amount)/12 as Annually FROM tblhosting WHERE domainstatus = 'active' and billingcycle = 'Annually';
When I try create Table with this querys it works fine.
But when try the same with “Pie Chart” I got error:
undefined is not an object (evaluating 'this.datapoints.length')
Query Inspector:
xhrStatus:“complete”
request:Object
method:“POST”
url:“api/tsdb/query”
data:Object
from:“1525941113670”
to:“1525962713671”
queries:Array[2]
response:Object
results:Object
A:Object
refId:“A”
meta:Object
rowCount:1
sql:“SELECT SUM(amount) as Monthly FROM tblhosting WHERE domainstatus = ‘active’ and billingcycle = ‘Monthly’;”
series:null
tables:Array[1]
B:Object
refId:“B”
meta:Object
rowCount:1
sql:“SELECT SUM(amount)/12 as Annually FROM tblhosting WHERE domainstatus = ‘active’ and billingcycle = ‘Annually’;”
series:null
tables:Array[1]
0:Object
