# Integration keen.io with trello script **URL:** \ **Category:** Users\ **Created:** [May 8, 2016, 5:33am UTC](https://discuss.dgraph.io/t/integration-keen-io-with-trello-script/158 "2016-05-08T05:33:48Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![pawan](https://yyz1.discourse-cdn.com/flex007/user_avatar/discuss.dgraph.io/pawan/32/1946_2.png) [@pawan](https://discuss.dgraph.io/u/pawan)\ **Post date:** [May 8, 2016, 5:33am UTC](https://discuss.dgraph.io/t/integration-keen-io-with-trello-script/158/1 "2016-05-08T05:33:48Z")
So I spent some time yesterday to integrate the trello script with [keen.io](http://keen.io) 1. Data collection [keen.io](http://keen.io) for those who are not aware is a platform which provides APIs to collect, analyze and visualize data.It typically stores data in something called collections. So I made a collection called `performance` to which the script(which would usually run daily as a cron on a machine) would post data. The data contains the name of the team member and their score calculated that day looking back a week. This data would be posted conditional to the presence of a flag while running the script. Also, if the data is successfully posted to [keen.io](http://keen.io), a notification would be sent to Slack. This way we would know the script ran for the day. If we don’t get that notification, we can check the machine on which the script is setup to run and see if something went wrong. This part is done. 2. Data Visualization For this [keen.io](http://keen.io) provides a Javascript SDK, which can read data from a [keen.io](http://keen.io) collection and plot it in a graph. I think I have figured out the right query for this, but just need to test it out for a couple of days. An issue here is that [keen.io](http://keen.io) doesn’t host graphs/dashboards. We have to host them ourselves. Github pages could be a free and easy option, but then that would be publicly available because that’s how Github pages work. So I have to find out how to host this with the minimum overhead of maintenance. 3. Setting up cron After the first two steps are done, I will setup a cron that runs at the same time every day. Qn - Do we want it to run on weekends too ? If it doesn’t then the graph would be discontinuous. Other than this, it should be easy to set it up. ---
**Author:** ![mrjn](https://yyz1.discourse-cdn.com/flex007/user_avatar/discuss.dgraph.io/mrjn/32/775_2.png) [@mrjn](https://discuss.dgraph.io/u/mrjn)\ **Post date:** [May 8, 2016, 6:05am UTC](https://discuss.dgraph.io/t/integration-keen-io-with-trello-script/158/2 "2016-05-08T06:05:10Z")
> [@pawan](#): > > Data Visualization Yeah, that’s the biggest issue with [keen.io](http://keen.io). You can look at the third party integrations: [https://keen.io/docs/data-visualization/](https://keen.io/docs/data-visualization/) Otherwise, we could just publically host it as part of `dgraph.io/perf`. Would be radically open and transparent! 🙂 ---
**Author:** ![pawan](https://yyz1.discourse-cdn.com/flex007/user_avatar/discuss.dgraph.io/pawan/32/1946_2.png) [@pawan](https://discuss.dgraph.io/u/pawan)\ **Post date:** [May 8, 2016, 6:29am UTC](https://discuss.dgraph.io/t/integration-keen-io-with-trello-script/158/3 "2016-05-08T06:29:32Z")
I wouldn’t mind us publically hosting it 🙂 ---
**Author:** ![mrjn](https://yyz1.discourse-cdn.com/flex007/user_avatar/discuss.dgraph.io/mrjn/32/775_2.png) [@mrjn](https://discuss.dgraph.io/u/mrjn)\ **Post date:** [May 8, 2016, 6:30am UTC](https://discuss.dgraph.io/t/integration-keen-io-with-trello-script/158/4 "2016-05-08T06:30:09Z")
I’m okay too! @ashwin95r, @koppula: What do you guys think? Btw, @pawan: Can your Cron also post the summary on Slack, instead of just _pinging_ it? ---
**Author:** ![pawan](https://yyz1.discourse-cdn.com/flex007/user_avatar/discuss.dgraph.io/pawan/32/1946_2.png) [@pawan](https://discuss.dgraph.io/u/pawan)\ **Post date:** [May 8, 2016, 6:38am UTC](https://discuss.dgraph.io/t/integration-keen-io-with-trello-script/158/5 "2016-05-08T06:38:12Z")
Actually the trello script pings slack. Sure, but do we want the summary everyday? ---
**Author:** ![mrjn](https://yyz1.discourse-cdn.com/flex007/user_avatar/discuss.dgraph.io/mrjn/32/775_2.png) [@mrjn](https://discuss.dgraph.io/u/mrjn)\ **Post date:** [May 8, 2016, 6:55am UTC](https://discuss.dgraph.io/t/integration-keen-io-with-trello-script/158/6 "2016-05-08T06:55:28Z")
Yup. Summary everyday, just like what gets posted to [keen.io](http://keen.io) ---
**Author:** ![ashwin95r](https://yyz1.discourse-cdn.com/flex007/user_avatar/discuss.dgraph.io/ashwin95r/32/16_2.png) [@ashwin95r](https://discuss.dgraph.io/u/ashwin95r)\ **Post date:** [May 8, 2016, 6:56am UTC](https://discuss.dgraph.io/t/integration-keen-io-with-trello-script/158/7 "2016-05-08T06:56:14Z")
Is it just the score that is public? or are the name of the tasks that were performed publicly visible too? ---
**Author:** ![pawan](https://yyz1.discourse-cdn.com/flex007/user_avatar/discuss.dgraph.io/pawan/32/1946_2.png) [@pawan](https://discuss.dgraph.io/u/pawan)\ **Post date:** [May 8, 2016, 7:07am UTC](https://discuss.dgraph.io/t/integration-keen-io-with-trello-script/158/8 "2016-05-08T07:07:34Z")
It will be a graph with scores overtime that would be public. Not the tasks @mrjn Ok, I was thinking seeing a daily score won’t add much value(a weekly score could through) whereas a graph of scores over time would. Though sending it to slack is pretty trivial. ---
**Author:** ![mrjn](https://yyz1.discourse-cdn.com/flex007/user_avatar/discuss.dgraph.io/mrjn/32/775_2.png) [@mrjn](https://discuss.dgraph.io/u/mrjn)\ **Post date:** [May 8, 2016, 10:22am UTC](https://discuss.dgraph.io/t/integration-keen-io-with-trello-script/158/9 "2016-05-08T10:22:46Z")
I meant a weekly window published daily. That way you know if you are regressing, and can do something about it during the week. ![](https://canada1.discourse-cdn.com/flex007/uploads/dgraph/original/1X/c94cc60a6781e2da8287c8f90f4d36a275aac03c.png) ---
**Author:** ![pawan](https://yyz1.discourse-cdn.com/flex007/user_avatar/discuss.dgraph.io/pawan/32/1946_2.png) [@pawan](https://discuss.dgraph.io/u/pawan)\ **Post date:** [May 9, 2016, 12:54am UTC](https://discuss.dgraph.io/t/integration-keen-io-with-trello-script/158/10 "2016-05-09T00:54:29Z")
Thanks @mrjn. I understood that earlier too. That’s the same score that’s sent to [keen.io](http://keen.io). ---
**Author:** ![mrjn](https://yyz1.discourse-cdn.com/flex007/user_avatar/discuss.dgraph.io/mrjn/32/775_2.png) [@mrjn](https://discuss.dgraph.io/u/mrjn)\ **Post date:** [May 9, 2016, 12:55am UTC](https://discuss.dgraph.io/t/integration-keen-io-with-trello-script/158/11 "2016-05-09T00:55:46Z")
Ah… okay. I wasn’t sure. Though, it’s better to over-communicate and be absolutely clear 😄. Btw, you might want to push out your changes so they don’t just stay on your laptop. I push out to git multiple times a day to avoid any hard disk crash disasters. ---
**Author:** ![pawan](https://yyz1.discourse-cdn.com/flex007/user_avatar/discuss.dgraph.io/pawan/32/1946_2.png) [@pawan](https://discuss.dgraph.io/u/pawan)\ **Post date:** [May 9, 2016, 1:00am UTC](https://discuss.dgraph.io/t/integration-keen-io-with-trello-script/158/12 "2016-05-09T01:00:50Z")
Sure , I will do that today. I should make that a habit, a hard disk crash would indeed be painful. I may not have access to the tools repository though. ---
**Author:** ![mrjn](https://yyz1.discourse-cdn.com/flex007/user_avatar/discuss.dgraph.io/mrjn/32/775_2.png) [@mrjn](https://discuss.dgraph.io/u/mrjn)\ **Post date:** [May 9, 2016, 1:02am UTC](https://discuss.dgraph.io/t/integration-keen-io-with-trello-script/158/13 "2016-05-09T01:02:45Z")
DGraph team has write access. So, you have the access to commit. Though eventually you might want to send out a pull request, so I can have a look as well. ---
**Author:** ![pawan](https://yyz1.discourse-cdn.com/flex007/user_avatar/discuss.dgraph.io/pawan/32/1946_2.png) [@pawan](https://discuss.dgraph.io/u/pawan)\ **Post date:** [May 9, 2016, 1:03am UTC](https://discuss.dgraph.io/t/integration-keen-io-with-trello-script/158/14 "2016-05-09T01:03:34Z")
Yes, sure I will send across a PR as soon as I get to work. ---
**Author:** ![pawan](https://yyz1.discourse-cdn.com/flex007/user_avatar/discuss.dgraph.io/pawan/32/1946_2.png) [@pawan](https://discuss.dgraph.io/u/pawan)\ **Post date:** [May 9, 2016, 4:18am UTC](https://discuss.dgraph.io/t/integration-keen-io-with-trello-script/158/15 "2016-05-09T04:18:00Z")
Checked out [datahero](https://keen.io/docs/integrations/datahero/). They are good but damn expensive. I have just picked one of the open source dashboard themes from the [keen.io](http://keen.io) page. If everyone is ok, we will host it on Github pages and be good to go for now. ---
**Author:** ![mrjn](https://yyz1.discourse-cdn.com/flex007/user_avatar/discuss.dgraph.io/mrjn/32/775_2.png) [@mrjn](https://discuss.dgraph.io/u/mrjn)\ **Post date:** [May 9, 2016, 4:20am UTC](https://discuss.dgraph.io/t/integration-keen-io-with-trello-script/158/16 "2016-05-09T04:20:31Z")
If we’re going to be public about this, no point paying at all. We can host it on Github, or we can even just run it as part of our website – a separate page in there or something. ---
**Author:** ![pawan](https://yyz1.discourse-cdn.com/flex007/user_avatar/discuss.dgraph.io/pawan/32/1946_2.png) [@pawan](https://discuss.dgraph.io/u/pawan)\ **Post date:** [May 9, 2016, 7:29am UTC](https://discuss.dgraph.io/t/integration-keen-io-with-trello-script/158/17 "2016-05-09T07:29:26Z")
@koppula @ashwin95r Your thoughts on having this dashboard public ? ---
**Author:** ![koppula](https://yyz1.discourse-cdn.com/flex007/user_avatar/discuss.dgraph.io/koppula/32/17_2.png) [@koppula](https://discuss.dgraph.io/u/koppula)\ **Post date:** [May 9, 2016, 7:43am UTC](https://discuss.dgraph.io/t/integration-keen-io-with-trello-script/158/18 "2016-05-09T07:43:00Z")
I think hosting on Github makes sense. Not so sure about putting this up on the website though – I think we don’t on the website and just on Github. ---
**Author:** ![ashwin95r](https://yyz1.discourse-cdn.com/flex007/user_avatar/discuss.dgraph.io/ashwin95r/32/16_2.png) [@ashwin95r](https://discuss.dgraph.io/u/ashwin95r)\ **Post date:** [May 9, 2016, 7:51am UTC](https://discuss.dgraph.io/t/integration-keen-io-with-trello-script/158/19 "2016-05-09T07:51:43Z")
While it can be public, I don’t think we need to put it up on the website or link to it from other places. ---
**Author:** ![pawan](https://yyz1.discourse-cdn.com/flex007/user_avatar/discuss.dgraph.io/pawan/32/1946_2.png) [@pawan](https://discuss.dgraph.io/u/pawan)\ **Post date:** [May 9, 2016, 7:53am UTC](https://discuss.dgraph.io/t/integration-keen-io-with-trello-script/158/20 "2016-05-09T07:53:50Z")
Cool, will host it on Github pages for now. We are still refining the formula we use to calculate this score and are still to come to up with a threshold of what constitutes a good score. So I also agree we don’t need to advertise it. Maybe when we publish our blog post about our trello integration, we could add a link to the dashboard then. [Next page](https://discuss.dgraph.io/t/integration-keen-io-with-trello-script/158.md?page=2)