Skip to main content

How to view salaries summary in pivot table

Although we’ve already seen how to apply aggregate functions (e.g. sum, average) on all salaries in a post about creating an overview of job postings, now we’re going to dig into even more details by using Lumeer’s pivot table view.

You may already be familiar with pivot table from Excel or other tools. The main feature which makes it different from classical table is that it’s not collection of records (rows). Instead, it summarizes information from that classical table and does it by calculating values of aggregation functions in every cell. Probably the best way to understand the idea of pivot table is to see an example, and we’ll show you one in a moment.

We start with a table showing job postings and hiring manager linked to them (we have already learned how to create such a table). Let’s switch the view from table to pivot table.

A window with pivot table settings shows up. Lumeer automatically adjust those settings for you based on available information - the first table (Postings) forms the rows, the second (Employees) forms the columns. Features of classical tables, such as sorting or filtering, are present in pivot table, too. The question we are going to answer is: “How much money is needed for salaries for each job posting title linked to each hiring manager?”

Without much effort, we have a beautiful pivot table! Rows are grouped by job titles, columns are grouped by hiring managers and the actual values displayed in table cells are aggregations, in our case sums and counts of salaries. What’s more, total values for every column and every row are also displayed, because we checked Show totals option in the settings.

Pivot table is useful in many situations and displaying summarisation of salaries is just one of them. However, there are also other views of data which may come handy to you. Have a look at calendar or map view and see how you can quickly view and manipulate your data with Lumeer.



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…

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 …