Skip to main content

How to track your goals with OKRs

Every organization, small or big, has to make sure that everybody is on the same track in order to reach their goals. Vision needs to be mapped to strategy, strategy to concrete goals which everybody inside the organization is aware of. OKRs is one of the frameworks that helps organizations to achieve it and there is a number of big companies (Google amongst them) that are successfully using it to navigate their growth.

OKR stands for Objectives and key results and means exactly that. The main idea is that you set a goal (or an objective) you want to achieve and set a list of key results which are required to achieve it. There is one important thing about the key results: they have to be measurable. “Increase the number of customers” is not a good example, as it is hard to tell if the key result was achieved - is it enough to get one more customer? Then your key result is “Increase the number of customers by one”. Or do you want to increase the number by 10%? Then your key result is “Increase the number of customers by 10%”.

After you set those OKRs, well, there is nothing less to do than to work on them (which only you have knowledge and expertise to do) and track them to see if you are going in the right direction (which Lumeer can help you with). Let’s do it!

If you are not familiar with Lumeer’s basic concepts such as organizations, projects, collections or attributes, you may find this article with basic principles helpful.

We start with collection with employees to whom we are going to record their objectives.

Right now we need just their names, so we hide all the other columns:

First, we define the objectives. They are more general statements and aren’t measurable (as opposed to SMART goals) - we get to that with key results. We create a separate collection for them and then use linked records to connect objectives to managers:

Next, we define key results for each objective in separate collection. We again use linked records:

Every key result has its goal and current status and we can use them to calculate progress. If you used to work with Excel, you are probably familiar with the functions. Lumeer lets you define functions for the whole attribute (column), but it’s certainly more fun to do it than with Excel - right click on the name of the column, click on “Edit function” and see for yourself!

Instead of literally writing the function, you build it in Lumeer’s visual designer (detailed manual on functions will help you with that):

And there it is: the progress calculated from Goal and Current columns. However, it doesn’t look very appealing, so we customize attribute type to Percentage to get a much nicer look:

So now we have progress on key result calculated, but what about objectives? Let’s also see their progress! We decided to calculate it as an average progress of its key results. You may be wondering: we calculated key result progress from columns in the same collection, but objectives are in different collection, so how can they use progress column from key results? Well, visual designer can handle it:

We polish the values look with percentage format same as we did it with before:

Let’s save our current view for easy access in the future:

Finally, let’s switch to chart to see and compare managers’ results in bar chart:

Interested in OKRs? Try Lumeer today and start tracking!


  1. I should state this is an extraordinary post. I have perused keep going two blog entries on a similar theme, those were amazing as well. Keep it up and continue posting web journals on related issue.
    Goal Tracker App iphone


Post a Comment


How to track tasks for employees?

When multiple employees work on multiple projects, even in a small company it can easily happen that you lose track of who is doing what and on which project. However, it is very important to have quick and easy access to this kind information: you want to know progress on a project to plan for the future release, or you want to see if employees have some spare capacity or are too overwhelmed by the workload. 
Maybe you feel that all that information is being lost in a pile of spreadsheets and emails. They are all there, but to access them means to spend precious minutes or even hours on searching the documents, every time. You wish to have everything in one place, with every question about current status or capacity answered within seconds and with just a few clicks. You want to easily make changes that are smoothly and automatically propagated to relevant people in the company. In this article, we will show you how to achieve this with Lumeer.
After we login into Lumeer, we create …

How to create a comprehensive overview of job postings

Managing information about two or three job postings at your company is easy and can be done even in some simple tool or spreadsheet. However, as the number of postings, candidates and other information grows, it becomes increasingly difficult not to get lost in the data and maintain a clear overview. There are candidates with their names, addresses and positions they are applying for. There are also job postings with salaries and managers who want to hire people for those positions. Those pieces of information are related to each other and we will show you how to effectively manage and view them with Lumeer. As Lumeer allows us to put similar data to collections, we will want to store information about candidates, job postings and company’s employees in separate collections. It’s the most intuitive way because candidates have similar attributes, e.g. name, address, phone number or the date they applied for a job at the company. On the other hand, postings have their names and salaries…

How secure are your data in Lumeer?

As more and more data is processed by computers, the question of data security has become inherent to all users. For business users it is even more important to know that their valuable data are secure.

Maybe you have heard about recent Intel’s L1 Terminal Fault vulnerability. We at Lumeer take security of your data very seriously, and that’s why we have cooperated with Digital Ocean to provide you protection against this threat.

Of course, we do a lot more for data security - encryption, redundancy and backup. Encryption means that when data is moving between computers, it is encoded in such way that only authorized parties (meaning you) can access it. Redundancy protects you against hard drive failure - if one drive fails, data is easily recovered because there is at least one other drive at the server that contains a copy. Backups go even further, they are stored in different geographical locations and are done periodically to assure you that even if there was a more serious damag…