Timeline of a query result?

Hi,

I’m trying ReDash for dashboarding some services for a few days now. One of my needs is the following one:

I have a SQL query SELECT COUNT(*) FROM users and I’d like to get graph / CSV export of number of users in the duration.

Is there a way to do so?

I found a way to refresh data every day, but I’d like to get result stored and ability to list values.
Maybe I’m wrong about what the tool is targeted for, let me know your feeling.

Thanks in advance.

Presumably your users table includes a created_at field. In which case you would chart this to whatever resolution you’d prefer. In Postgres for example:

SELECT date_trunc('hour', created_at), COUNT(*)
FROM users
GROUP BY 1