All Collections
Data Center and Formulas
What are Data Center formulas used for?
What are Data Center formulas used for?

Make data-driven decision for your Schedule

Patrick Gruhn avatar
Written by Patrick Gruhn
Updated over a week ago

🎯 For Admins. This feature, formally called Planning metrics, is included from the Pro Plan and up. Reach out to our support team if you'd like to try it out.


The Data Center formulas feature, along with the Data sets, is a Scheduling tool that allows you to keep track of your planning needs.
These metrics are meant to help you get one step closer to making data-driven decisions and give you an easy overview of your business needs, directly in Schedule (see an example below).

With this feature, you can keep your costs on track or be prepared for busy periods.

For instance, you can use Data Center formulas to display in Schedule:

  • your scheduling needs: e.g. number of shifts needed for the upcoming period,

  • productivity insights: e.g. sales revenue / employee/ hour

  • schedule differences: e.g scheduled hours vs. worked hours

  • cost & resources insights: e.g. eat-in orders vs. take-out orders, number of reservations vs. guest no shows.

  • performance and strategy insights: e.g. event revenue vs. event cost.

Because your needs can change very fast or be different from one part of your organization to another, the Data Center formulas feature is constructed to rely on the data that you input and the information recorded in your Schedule.

To see what it can do for you, start by heading over to the Reports > Data Center.

Get familiar with Data Center formulas using this setup guide for Demand planning.

This will open the Data Center page where you can start creating the data sets and formulas you need. This is also where you will find an overview of your existing metrics later.

The Data Center element you choose determines where the data comes from. This gives you two ways to use data:

  • as a Data set, useful if your metrics need to use single-data inputs, per day or per hour. A Data set should be used in Formulas if you need it to be visible in Schedule.
    More info about the Data sets can be found in this article.

  • as a Formula, that gives you the opportunity to combine multiple metrics into one. Formulas can be set up using mathematical operations between your other Data sets and/or elements from your schedule (actual values recorded on your Planday).
    More info about the Formulas can be found in this article.

Specifically, a Data set would require you (or your colleagues) to input or import what's needed. In contrast, a Formula could be based on a mix of data that needs to be filled in and data gathered from your schedule.

If you're in doubt about what kind of metric you should create, you can look through some of the commonly used data sets or formulas here.



ℹ️ Need more help?

🔍 Search the Help Center | See videos at Tutorials.Planday.com | Watch a webinar

💬 For personalised support

Login and contact our support team via the blue icon at the bottom if you have more questions or book a one-to-one professional training session with an expert.

Did this answer your question?