I find it difficult to create a chart style “Events by Date”.
My MySQL query is as follows:
SELECT
FROM_UNIXTIME(UNIX_TIMESTAMP(example_date), “%d/%m/%y”),
count(example_event)
FROM example_table
GROUP BY example_date
ORDER BY example_date DESC
example_date is from a TIMESTAMP type and example_event is from a VARCHAR type.
Can include an example of how the results looks like? If the query id is 123, then the results URL will be /api/queries/123/results.json. You can share it privately if you prefer.
Also how did you configure the chart? The date as X axis and count as Y?