Today I installed redash with AWS EC2 and AWS SES, with the help of the official guide.
Take a look at the public dashboard that visualizes the current user count on my Redash instance!
![redash.users.count.png](/assets/images/posts/redash.users.count.png)
The server runs on a t2.micro instance, backed by the Redash Ubuntu AMI.
I am using Amazon SES as the mail service.
Redash
Visualize Queries
To visualize something in Redash, you need a query.
And you execute a query on some data.
Fortunately, Redash has a default dataset (itself!) to play with, instead of hooking up an external data source.
Visualize Events
Create a new Query (/queries/new):
![redash.create.new.query.png](/assets/images/posts/redash.create.new.query.png)
Let’s aggregate events by action and type of a Redash instance:
SELECT count(*) as times
, action
, object_type
FROM events
group by action, object_type
order by times desc
![redash.query.new.png](/assets/images/posts/redash.query.new.png)
Use the following configuration to create a visualization:
![redash.visualization.new.png](/assets/images/posts/redash.visualization.new.png)
Final result
You should end up with something like this:
![redash.visualization.events.png](/assets/images/posts/redash.visualization.events.png)
Conclusion
It seems like a nice piece of software, my idea is to integrate Redash with mnesia to visualize things you saved in mnesia!