Greetings!
Im really struggling with the time-series graph… Per the feature release details it looks like it has the ability to do everything I want to do, yet cant seem to make it happen. For instance, would love to create multiple x-axis + y axis per below but having trouble even generating a single y value per multiple x. Please help. Mysql below generates correct x metrics and time-range, and value range looks good on y axis, but the y values/lines (count(*)) arent populating
SELECT
date(timestamp) as time,
a.legal_business_name,
count(*) as value
from
completed_transaction c
inner join associate a on
a.id = c.accomplice_associate_id
WHERE
receiving_status_id in (3,6)
and transaction_type_id in (1,12)
group by DATE_FORMAT(timestamp, ‘%y-%m’),
accomplice_associate_id
and $__timeFilter(timestamp)
