Total labor cost by department

SQL query for d2o PMI

Calculate total labor cost by department for a specific date range.

SELECT department_name, SUM(labor_cost) AS total_cost FROM labor_department_daily WHERE date BETWEEN ‘start_date’ AND ‘end_date’ GROUP BY department_name

d2o PMI data model

Table Properties

Table Property Info

Table Departments

Table Segments

Table Revenues Department Monthly

Table Contenttypes

Table Reports

Table Reportvalues

Table Accountvalues Budget

Table Accountvalues Forecast

Table Revenues Department Daily

Table Labor Department Daily

Table Categories

Table Category Settings

Table Cockpits

Table Cockpits Monthly

Table Guest Feedback

Table Hierarchy Indexes

Magical SQL for d2o PMI with Peliqan.io

Explore data in a rich spreadsheet UI. Use Magical SQL to combine and transform data. SQL queries become new tables that can be shared with business users and used in any BI tool such as Microsoft Power BI, Tableau or Metabase.

Let AI do the work for you

Peliqan’s AI assistant helps you to write SQL queries to get to insights fast. Ask your question in plain English and immediately see the result in Peliqan’s rich spreadsheet viewer.

Total labor cost by department

SQL query for d2o PMI

d2o PMI data model

Magical SQL for d2o PMI with Peliqan.io

Let AI do the work for you

Ready to get instant access to all your company data ?

Ready to get instant access to
all your company data ?