Estimate Date Dimension

Modified on Mon, 27 Jul at 9:11 PM

Calendar Summary

The Estimate Date Dimension is a QQube feature that keeps original estimate amounts visible while actual job costs are filtered to a selected transaction-date range.

Calendar Type

QQube estimate comparison date

Date Represents

Original estimate date

QQube Source

Estimate comparison logic

Primary Use

Compare estimates with filtered actual costs

Included Data Models

Operations: Job Cost Details

QQube Source

QQube separates the Estimate Date from the Transaction Date so original estimate amounts remain visible when actual job costs are filtered to a specific transaction-date range.

Required Date Filtering

Filter the Transaction Date Dimension for the required actual-cost date range and also include 01/01/1980. QQube uses this placeholder date to retain the estimate records.

Leave the Estimate Date filter unchanged.

Source Example

QQube Estimate Date filtering example

Available Fields

The following fields are included in the Estimate Date Dimension.

Display Order	Field Name
1	Estimate Date
2	Estimate Date Day Holiday Name
3	Estimate Date Day is Holiday
4	Estimate Date Day is Weekend Day
5	Estimate Date Day is Working Day
6	Estimate Date Day Number in Month
7	Estimate Date Day Number in Quarter
8	Estimate Date Day Number in Week
9	Estimate Date Day Number in Year
10	Estimate Date Day of Week
11	Estimate Date Day of Week Abbr
12	Estimate Date Formal Date
13	Estimate Date Month Abbr
14	Estimate Date Month Begin Date
15	Estimate Date Month End Date
16	Estimate Date Month Name
17	Estimate Date Month Number
18	Estimate Date Month-Year
19	Estimate Date Quarter
20	Estimate Date Quarter Begin Date
21	Estimate Date Quarter End Date
22	Estimate Date Quarter Number
23	Estimate Date Quarter-Year
24	Estimate Date Week Begin Date
25	Estimate Date Week End Date
26	Estimate Date Year
27	Estimate Date Year Begin Date
28	Estimate Date Year End Date
29	Estimate Date Year Number