Advanced reporting with monday.com

If you ever walk into a monday.com office, you will see dashboards everywhere! We like to measure everything from the company's performance to the amount of coffee drank per week ☕️. Reporting plays a crucial role in any decision we make. With that in mind, we've created some pretty amazing features that will help you run reports on your boards and your entire monday.com account. 

In this guide, we will walk you through our advanced functionalities such as stacked charts, Pivot Table, Workload View, and more! If you are new to reporting, we recommend you read our basic reporting guide right here. Let's get started 😃

 

Visualize data using three parameters with stacked charts

Charts are a great way to see the analytics side of your workflow. See how well your team members are performing, how fast your tasks get done, how they change over time, and more.

In this example, we are using a sales pipeline to visually track the progress of all the deals our sales team is currently working on. 

 

 

We are interested in seeing how many sales each agent made in April. To do so, we will use the stacked chart. The X-axis represents each agent, while the Y-axis represents the amount closed in USD.

Our third parameter helps us better understand which type of plan is sold the most by each agent. For example, Shelly is the only agent performing really well in selling Enterprise plans, whereas Lea is great in selling both Pro and Basic plans.  

Sales Pipeline Stacked Chart.png

 

Note:  You can also use stacked charts in dashboards, but it currently supports only one board. The option to use stacked charts for several boards should be released very soon :)

 

Add a benchmark and cumulative data

Let's enhance our chart even more by using a benchmark and cumulative data. The cumulative data option allows you to show how the data you are reporting on progresses over time. Each month will include all previous months plus the addition of the current month.

To return to our example, we can use the cumulative data to show the sales team's progress per month. Our X-axis represents the months, while the Y-axis represents the total amount closed in USD. We've stacked our chart per agent.

With the cumulative data, we can easily see the great progression of the team over the months. 

Insights- Stacked Bar.png

You can also add a Benchmark line to display the goal or the low/high threshold so you can keep track of your numbers in comparison to that line. 🙌

 

Get a clear overview of your team's workload 

Managing your resources and allocating all your tasks correctly is a crucial step of any successful project. With the Workload View and Widget, you can get a clear overview of how your team's work is divided! You can see at a glance who is over capacity and assign upcoming tasks accordingly. If needed, you can always reassign or change due dates to make sure everyone stays on target with the number of tasks they can complete within that timeframe.

In this example, we are launching a new product. Our board contains the following columns: 

  • A People Column 
  • A Date Column (you can also use a timeline column)
  • A Numbers Column to indicate the effort required for each task (you can also use a formula column). 

It is important to have these columns in your board for the workload view/widget to work. 

workload.png

 

Once your board is ready and your tasks are assigned, you can open the workload view. You can display the data in two ways: count item and effort. 

  • Count Item - If you choose Count items, each item that is assigned to that person will be counted as 1 and displayed on the board. 
  • Effort Sometimes, some of our tasks take more effort or carry more weight to the project. In our use case, we are using the time estimation column. That setting works with both a Numbers or Formula Column. 

 

Weekly Capacity Once done, we can then choose a Weekly Capacity for the entire team. This will be the limit of how many hours you want the team to be working on those tasks in that week. In our example, we set up the weekly capacity to 10 hours per week. 

Insights- Workload.gif

At a glance, you will be able to see how your work is divided and who is overcapacity. This will allow you to reschedule or re-allocate work as necessary to ensure timelines can be met. Check out the Workload Widget articles for more details about how this works. 

 

Slice and dice information with the Pivot Board

Our Pivot Board View allows you to analyze your board's different verticals better by slicing and dicing the information. Being fully flexible and customizable, this view will enable a deeper level of reporting from many different perspectives.

In this example, we are managing a dog-walking company. We are interested in seeing how many dogs each walker was assigned to per month. 🐾 Each row will represent a dog walker, and each column will represent a specific month. 

Insights- Pivot Board.png

 

You can even add multiple layers! This will allow you to analyze your board more deeply and identify trends. Here, for example, our columns are split by month and neighbourhood

2.png

 

Finally, you can summarize your data by the sum, average, median, and more! On the top left of your pivot, click on Count as below and select your preferred setting.  In this example, we are interested in seeing how much each dog walker earned each month. We will choose the sum and then the price. Voilà 🙌  Now we can see at a glance how much each dog walker earned.

Insights- Pivot board 2.png

The pivot board is a super flexible tool that will help you summarize and manipulate your information in many different ways. This will allow you to identify trends, follow your processes, and analyze your data better than ever before!

 

View and update data on the go with the mobile app 

The mobile app will allow you to collaborate with your team right from the palm of your hand! It's perfect if you're on the go and want to stay in tune with your team members. View your dashboards, board views, and boards, and pull your mobile out of your pocket to update information the minute it becomes relevant! You can even use the mobile app in offline mode to collaborate with your team from the field, or even on the subway on your commute to work! Check out this article to get started!

image_3.png

 

Identify textual sentiment at a glance

With the Word Cloud, you can turn your textual data from your board into meaningful visualizations, allowing you to gain in-depth analysis and convey crucial information when necessary.  

The Word Cloud helps turn databases of textual information into insights by depicting the key terms from your texts in a stunning visual representation. The bolder and bigger the terms, the more these terms appear on your board. With just a quick glance over your word cloud, you'll be able to gain some key takeaways and insights! 

image2.png

All these amazing functionalities should help you get the most out of our data! 😃

 

 

If you have any questions, please reach out to our team right here. We’re available 24/7 and happy to help.

Last modified on

Still have questions?
We can help.

Chat support

Get in touch with our support team through our chat for any questions, concerns, or inquiries.

Community forum

Learn, share ideas and connect with other monday.com customers.

Expert help

Hire a monday.com expert to optimize your workflows.