News for the ‘Stats’ Category

Trello in Status Board

Update 2: Apparently, there was a change in how Trello supplied the user token, so my script simply didn’t work. This should be fixed now, and the scripts work!

Update: Instructions to get this panel on your iPad are now up and running, and it should be easy enough for most people to get this working! See post for details!

One of the first widgets I planned on building after getting Status Board was one for Trello, the taskplanning tool.

Of course I want to keep track of how many tasks I’m working on right now, and how many are still in the queue. Maybe I want to see the names of the cards in my list, and maybe I want a burndown-chart for some projects, I haven’t decided…

I wasn’t very familiar with the API, and I couldn’t find a functional php-wrapper for it, so I used VeggieMeats php-trello as a starting point, and fixed it where it had to be fixed. (Yes, when I get the time, I will fork it and upload the corrections I’ve found).

Because of this, the trello widgets was put in the back of my head for a while, while I developed a few other widgets, such as the Google Analytics ones and the SL widget.

But now the time has come, and my focus is now on Trello. The first of three planned widgets is done, and it looks like this:


It’s very simple. You enter a boardID (plus some other sensitive info, since this board is private) and then it shows you how many (open) cards are in each list. Folks, this is pulled right from the API, no manual CSV here.

There’s probably more info to be added to this graph later o, but for now this does what I need it to.

In a while, I will make this availible for anyone. I need to come up with a (kind-of) user-friendly way to get all the info correct. We’re talkin loong user tokens and id:s you need to find. There will probably be some kind of form on this page where you can enter you info and then it will give you a link to open on your iPad to install the widget. But, as I said, I’m working on how to make this easy for everyone.

Instructions to get this working in your own status board with your own Trello board

First, make sure you do this on the iPad where you have Status Board installed!

1. Get your user token from Trello (if you haven’t got it already). I made a script for this to make it easy for you to get your own. You open a link from my site (further down) and it will redirect you to Trello’s authentication page. There, you’ll need to approve my “app” to access your data (read-only) and then it will redirect you back to my site where your token will be presented. Copy this token and paste it in the form below. Here’s the link!

2. Get your Board ID from the Trello Board you wish to use in this widget. I found that the easiest way to get the ID is to open the board in a browser and then find the board id in the url (as pictured below). Then copy this ID and paste in the form below.



3. Get your username from Trello (If you need help with this, tweet me, and I’ll help you) Copy it and paste it into the form below.

4. When all fields are entered correctly, tap the button below the form, and Status Board should open with this new Panel in it!

Form to enter your data in:

Paste your user token: Paste your username:

Paste your Board ID:

Click here on your iPad!

(If above button doesn’t work)

Come back here for more info, or follow me on twitter where I will post as I update.

Also, if there’s some trello functionality or stats you’d like to see that I haven’t thought of, post it in the comments, and I’ll see what I can do!


Posted: April 22nd, 2013
Categories: Design, Stats, Status Board, Webdesign, Widgets
Comments: Comments.

GA Top Viewed Pages panel for Status Board

After creating my first Google Analytics panel for Status Board, showing a nice graph over number of Visitors and Pageviews the last week, I wanted to see more of what content users found interesting. So I quickly wrote a table panel that showed the top pages and how many views they had, also over the last week. Some of the code is rather custom, as in my page titles I have a “ >>” prefix completely messing up my table names. I hade to parse the name string to only get the interesting portion. And I never realized this would be interesting to anyone else.

Until today, when @timteeling posted on twitter that he had forked my repo to do exactly this! Since I noticed he hadn’t implemented this string parsing, I decided to share what I had come up with, and here it is!



As you can see, the pageviews show in yellow, just to match the yellow in the other panel. They go nicely together!

Get the script here
Posted: April 19th, 2013
Categories: Design, Stats, Status Board, Webdesign, Widgets
Comments: Comments.

SL panel till Status Board

This panel is mostly intended for swedish users in Stockholm who want to display departures from any station in Stockholm in the iPad app “Status Board” from @panic. Perhaps you’re interested in my other panel that shows you Google Analytics stats for any of your sites? Therefore, I will now switch to swedish.

Appen Status Board från Panic är en våt dröm för alla oss som älskar data, statistik och att visualisera data. Med appen följer en del standard-widgets, för t ex dina iPad-kalendrar, väder och klockan.

Den stora styrkan sitter dock i de tre “DIY” (Do it yourself) panelerna. Med de kan man anropa en webbadress och få data levererat med jämna mellanrum. Självklart finns regler för hur datat ska vara strukturerat för att appen ska förstå hur det ska visas.

För oss Stockholmare har jag tagit fram en sådan här panel som visar kommande avgångar från vilken SL-station som helst. Man kan också ställa in en “avståndstid” (minuter det tar att gå till stationen). För mig tar det t ex 10 minuter att gå från jobbet till stationen. Då är det inte så intressant för mig att se de avgångar som går inom 10 minuter, de kommer jag ändå inte att hinna.


Du styr inställningarna genom att ange parametrar i url:en. Parametern station motsvarar ett stationsID för den station du vill se avgångar för. Dessa ID:n är inte helt enkla att ha koll på, så för att få fram dessa måste man ta en liten omväg. (I framtiden planerar jag att bygga ett litet formulär för att få fram dessa här på sidan)

Gå till TrafikLabs API-konsol för SL.
Öppna “GetSite”
Skriv den station du önskar och klicka på “skicka anrop”.
Kolla i texten under “svar” och hitta den station du ville, ID:t hittar du där.

Mer info och källkoden hittar du här på GitHub. Känn dig fri att lägga detta på en egen server om du vill, eller bygg ut koden med egen kod om du vill och kan!

För att installera panelen med standardinställngarna (Station: Kista C och Avstånd: 10 min) öppna detta inlägg på din iPad och klicka på knappen nedan. Då öppnas Status Board automatiskt.


Installera panel



Posted: April 18th, 2013
Categories: Design, Stats, Status Board, Webdesign, Widgets
Comments: Comments.

Google Analytics Panel for Status Board

Update: Swedish Status Board users! Check out my new widget for showing SL departures. Read more here!

Update 2: I just released the companion panel for this showing you the top viewed pages of any site. Read more here!

I love Panic’s new app Status Board.

And I also love watching Google Analytics.

So I couldn’t help myself, and this is the result.



The panel is a php script based on the g-api library for accessing Google Analytics, with a little tweaking of my own to support the newest GA API.

It basically seems to do the same as Hilton’s Ruby script, but this one runs on php instead.

The php-file (together with the modified g-api class) can be found on my github. Feel free to change as you please. In fact, you HAVE to change it in order for it to work.
Get the script here


Posted: April 13th, 2013
Categories: Design, Stats, Status Board, Widgets
Comments: Comments.

State of Mobile

Min första @HaikuDeck. Blev rejält inspirerad av #webbdagarna och kände att jag var tvungen att sammanställa lite fakta om hur mobilmarknaden faktiskt ser ut idag!

Kul verktyg att använda, kan rekommendera det för snabba presentationer som inte kräver massa snazzy effects. (Dvs alla…)

Posted: March 15th, 2013
Categories: Ideas, Mobile, Mobile Web, Stats, Thoughts
Tags: ,
Comments: Comments.