Using MySQL data source and following query containing INNER JOIN to get time series data. But it is giving Data is missing a number field error.
SELECT
$__timeGroupAlias(up.created,$__interval),
count(id) AS "Total"
FROM plans_userplan up
INNER JOIN plans_planquota pq ON pq.plan_id = up.plan_id
INNER JOIN plans_quota q ON q.id = pq.quota_id
INNER JOIN authentication_user u ON u.id = up.user_id
WHERE
$__timeFilter(up.created) AND q.codename = 'CUSTOM_SCRIPT'
GROUP BY 1
But data is available in the database and can be retrieved using (modified query)
select
count(*)
from plans_userplan up
inner join plans_planquota pq on pq.plan_id = up.plan_id
inner join plans_quota q on q.id = pq.quota_id
INNER JOIN authentication_user u on u.id = up.user_id
where q.codename = 'CUSTOM_SCRIPT'
