Skip to main content

How to show candidates on a map

We have already showed how to display data in calendar, but what if besides time dimension, our data also have space dimension?
Working with addresses can be pretty tough because they have a complex structure (most often street and its number, town and ZIP code), but can be written in many different formats. However, if we want addresses to be easily searchable and maintainable, our system has to know meaning of each part of address string. We can start typing addresses into the table and Lumeer will give us suggestions from which we will choose. This saves us time because we don’t have to type so much, but there’s one more benefit: as Lumeer gave us the suggestion, he knows exactly the semantics of whole address string and can tell which part is street, town etc. which will be useful for visualization on a map.


With address column in the table, we can easily display its rows on the map by switching the perspective:



Now we see the candidates displayed on a map. By clicking on their icon, a detail of candidate is displayed under the map.


Let’s switch back to table perspective for a while and add linked collection with job postings to the view.




After switching to map perspective again, we see under the map that it displays candidates and postings linked to them.




If we zoom out the map, candidate icons that are close to each other start to aggregate into bigger icons with a count written inside the icon.


However, the icons on the map can display even more detail. For example, we want to know how many candidates in each town are applying for each posting. This can be easily achieved by clicking on Job Title attribute, which groups candidates by the attribute.




That was again easy and painless, as everything you try to accomplish with Lumeer. Its graphical views and visualizations provide you with a lot of insights, and along with that, you can still use good old pivot table to perform aggregations and calculations.

Comments

Favorites

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 to effectively search and publish townhall meeting's resolutions

In previous posts, we created invitation to a townhall meeting and added minutes and comments. The collections are now filled with data and we will show you how to search those data and easily export them into publishable form.

After every townhall meeting, the municipality has to publish the resolutions which were approved during the meeting. To achieve that, we first search for the data we need by using Lumeer’s search box. We adjust the filters, hit enter and immediately see all resolutions from particular meeting.

We see the result of the search in table perspective, but we switch it to smart document perspective and produce the list of resolutions in a similar way that we have created the invitation.



Of course, we can choose how we want to export the document. Do we want to print it? Then we use export to PDF. Do we want to publish it on municipality’s website? We can put the PDF there, or, even simpler, we just put there the link to document which points directly to Lumeer, where t…