Our state of the art Gantt chart


Post by quandarycg »

The goal here is that we want weeks that don't belong to a particular interval to be set to 0 hours available rather than currently undefined intervals, the users are set to working the whole day.

We have intervals that cover an employee's week. So for any week not scheduled, we'd like to not have them available at all.

Is this possible?

I've seen: "unspecifiedTimeIsWorking": false, yet it seems to break the resource histogram.

{
    "calendarsData": [
        {
            "id": "general",
            "name": "General",
            "intervals": [],
            "expanded": true,
            "children": [
                {
                    "id": "sdrc-2",
                    "name": "Q's Calendar",
                    "intervals": [
                        {
                            "recurrentStartDate": "every weekday at 22:00 on the 10th through 16th day of October in 2021",
                            "recurrentEndDate": "every weekday at 6:00 on the 10th through 16th day of October in 2021",
                            "isWorking": false
                        },
                        {
                            "recurrentStartDate": "every weekday at 22:00 on the 3rd through 9th day of October in 2021",
                            "recurrentEndDate": "every weekday at 6:00 on the 3rd through 9th day of October in 2021",
                            "isWorking": false
                        },
                        {
                            "recurrentStartDate": "every weekday at 22:00 on the 17th through 23rd day of October in 2021",
                            "recurrentEndDate": "every weekday at 6:00 on the 17th through 23rd day of October in 2021",
                            "isWorking": false
                        },
                        {
                            "recurrentStartDate": "every weekday at 22:00 on the 24th through 30th day of October in 2021",
                            "recurrentEndDate": "every weekday at 6:00 on the 24th through 30th day of October in 2021",
                            "isWorking": false
                        },
                        {
                            "recurrentStartDate": "every weekday at 22:00 on the 31st through 6th day of November in 2021",
                            "recurrentEndDate": "every weekday at 6:00 on the 31st through 6th day of November in 2021",
                            "isWorking": false
                        },
                        {
                            "recurrentStartDate": "every weekday at 22:00 on the 7th through 13th day of November in 2021",
                            "recurrentEndDate": "every weekday at 6:00 on the 7th through 13th day of November in 2021",
                            "isWorking": false
                        },
                        {
                            "recurrentStartDate": "every weekday at 22:00 on the 14th through 20th day of November in 2021",
                            "recurrentEndDate": "every weekday at 6:00 on the 14th through 20th day of November in 2021",
                            "isWorking": false
                        },
                        {
                            "recurrentStartDate": "every weekday at 22:00 on the 26th through 2nd day of October in 2021",
                            "recurrentEndDate": "every weekday at 6:00 on the 26th through 2nd day of October in 2021",
                            "isWorking": false
                        },
                        {
                            "recurrentStartDate": "every weekday at 22:00 on the 3rd through 9th day of October in 2021",
                            "recurrentEndDate": "every weekday at 6:00 on the 3rd through 9th day of October in 2021",
                            "isWorking": false
                        },
                        {
                            "recurrentStartDate": "every weekday at 22:00 on the 10th through 16th day of October in 2021",
                            "recurrentEndDate": "every weekday at 6:00 on the 10th through 16th day of October in 2021",
                            "isWorking": false
                        },
                        {
                            "recurrentStartDate": "every weekday at 22:00 on the 17th through 23rd day of October in 2021",
                            "recurrentEndDate": "every weekday at 6:00 on the 17th through 23rd day of October in 2021",
                            "isWorking": false
                        },
                        {
                            "recurrentStartDate": "every weekday at 22:00 on the 24th through 30th day of October in 2021",
                            "recurrentEndDate": "every weekday at 6:00 on the 24th through 30th day of October in 2021",
                            "isWorking": false
                        },
                        {
                            "recurrentStartDate": "every weekday at 22:00 on the 31st through 6th day of November in 2021",
                            "recurrentEndDate": "every weekday at 6:00 on the 31st through 6th day of November in 2021",
                            "isWorking": false
                        },
                        {
                            "recurrentStartDate": "every weekday at 22:00 on the 7th through 13th day of November in 2021",
                            "recurrentEndDate": "every weekday at 6:00 on the 7th through 13th day of November in 2021",
                            "isWorking": false
                        },
                        {
                            "recurrentStartDate": "every weekday at 22:00 on the 14th through 20th day of November in 2021",
                            "recurrentEndDate": "every weekday at 6:00 on the 14th through 20th day of November in 2021",
                            "isWorking": false
                        },
                        {
                            "recurrentStartDate": "every weekday at 22:00 on the 21st through 27th day of November in 2021",
                            "recurrentEndDate": "every weekday at 6:00 on the 21st through 27th day of November in 2021",
                            "isWorking": false
                        },
                        {
                            "recurrentStartDate": "every weekday at 22:00 on the 28th through 4th day of December in 2021",
                            "recurrentEndDate": "every weekday at 6:00 on the 28th through 4th day of December in 2021",
                            "isWorking": false
                        },
                        {
                            "recurrentStartDate": "every weekday at 22:00 on the 5th through 11th day of December in 2021",
                            "recurrentEndDate": "every weekday at 6:00 on the 5th through 11th day of December in 2021",
                            "isWorking": false
                        },
                        {
                            "recurrentStartDate": "every weekday at 22:00 on the 12th through 18th day of December in 2021",
                            "recurrentEndDate": "every weekday at 6:00 on the 12th through 18th day of December in 2021",
                            "isWorking": false
                        },
                        {
                            "recurrentStartDate": "every weekday at 22:00 on the 19th through 25th day of December in 2021",
                            "recurrentEndDate": "every weekday at 6:00 on the 19th through 25th day of December in 2021",
                            "isWorking": false
                        }
                    ]
                },
                {
                    "id": "erc-299",
                    "name": "H, D's Calendar",
                    "intervals": [
                        {
                            "recurrentStartDate": "every weekday at 22:00 on the 23rd through 29th day of January in 2022",
                            "recurrentEndDate": "every weekday at 6:00 on the 23rd through 29th day of January in 2022",
                            "isWorking": false
                        },
                        {
                            "recurrentStartDate": "every weekday at 22:00 on the 30th through 5th day of February in 2022",
                            "recurrentEndDate": "every weekday at 6:00 on the 30th through 5th day of February in 2022",
                            "isWorking": false
                        },
                        {
                            "recurrentStartDate": "every weekday at 22:00 on the 6th through 12th day of February in 2022",
                            "recurrentEndDate": "every weekday at 6:00 on the 6th through 12th day of February in 2022",
                            "isWorking": false
                        },
                        {
                            "recurrentStartDate": "every weekday at 22:00 on the 13th through 19th day of February in 2022",
                            "recurrentEndDate": "every weekday at 6:00 on the 13th through 19th day of February in 2022",
                            "isWorking": false
                        },
                        {
                            "recurrentStartDate": "every weekday at 22:00 on the 8th through 14th day of August in 2021",
                            "recurrentEndDate": "every weekday at 6:00 on the 8th through 14th day of August in 2021",
                            "isWorking": false
                        },
                        {
                            "recurrentStartDate": "every weekday at 22:00 on the 15th through 21st day of August in 2021",
                            "recurrentEndDate": "every weekday at 6:00 on the 15th through 21st day of August in 2021",
                            "isWorking": false
                        },
                        {
                            "recurrentStartDate": "every weekday at 22:00 on the 22nd through 28th day of August in 2021",
                            "recurrentEndDate": "every weekday at 6:00 on the 22nd through 28th day of August in 2021",
                            "isWorking": false
                        }
                    ]
                }
            ]
        }
    ]
}

Post by arcady »

"unspecifiedTimeIsWorking": false

Should do the trick. Just make sure you use that for all calendars then. Otherwise it might give you unexpected results combined w/ calendars parent-child inheritance.
And of course if you make all time range non-working by default your intervals should define working time isWorking : true.

If you face some issues w/ the histogram when defining calendars this way please provide more details how we can reproduce them.


Post by quandarycg »

Whenever I add that on any of the calendars the app returns the errors:

Uncaught Error: Unknown identifier ClassDefEx-p-33.$.assigned
at throwUnknownIdentifier (gantt.umd.js:1376:9)
at EngineTransaction.get (Transaction.js:149:13)
at EngineReplica.get (Graph.js:390:9)
at TemplateClass.getFromGraph (ModelFieldAtom.js:68:46)
at ClassDefEx.get (Entity.js:159:13)
at ClassDefEx.get assignments (gantt.umd.js:98321:19)
at ClassDefEx.get assignments [as assignments] (TaskModel.js:796:13)
at ResourceAssignmentColumn.getRawValue (Column.js:954:9)
at Row.renderCell (Row.js:542:28)
at Row.render (Row.js:466:17)
gantt.umd.js:1376 Uncaught (in promise) Error: Unknown identifier ClassDefEx-p-33.$.assigned
at throwUnknownIdentifier (gantt.umd.js:1376:9)
at EngineTransaction.get (Transaction.js:149:13)
at EngineReplica.get (Graph.js:390:9)
at TemplateClass.getFromGraph (ModelFieldAtom.js:68:46)
at ClassDefEx.get (Entity.js:159:13)
at ClassDefEx.get assignments (gantt.umd.js:98321:19)
at ClassDefEx.get assignments [as assignments] (TaskModel.js:796:13)
at ResourceAssignmentColumn.getRawValue (Column.js:954:9)
at Row.renderCell (Row.js:542:28)
at Row.render (Row.js:466:17)
gantt.umd.js:1376 Uncaught Error: Unknown identifier ClassDefEx-t-267.$.assigned
at throwUnknownIdentifier (gantt.umd.js:1376:9)
at EngineTransaction.get (Transaction.js:149:13)
at EngineReplica.get (Graph.js:390:9)
at TemplateClass.getFromGraph (ModelFieldAtom.js:68:46)
at ClassDefEx.get (Entity.js:159:13)
at ClassDefEx.get assignments (gantt.umd.js:98321:19)
at ClassDefEx.get assignments [as assignments] (TaskModel.js:796:13)
at ResourceAssignmentColumn.getRawValue (Column.js:954:9)
at Row.renderCell (Row.js:542:28)
at Row.render (Row.js:466:17)
gantt.umd.js:1376 Uncaught Error: Unknown identifier ClassDefEx-p-33.$.assigned
at throwUnknownIdentifier (gantt.umd.js:1376:9)
at EngineTransaction.get (Transaction.js:149:13)
at EngineReplica.get (Graph.js:390:9)
at TemplateClass.getFromGraph (ModelFieldAtom.js:68:46)
at ClassDefEx.get (Entity.js:159:13)
at ClassDefEx.get assignments (gantt.umd.js:98321:19)
at ClassDefEx.get assignments [as assignments] (TaskModel.js:796:13)
at ResourceAssignmentColumn.getRawValue (Column.js:954:9)
at Row.renderCell (Row.js:542:28)
at Row.render (Row.js:466:17)
gantt.umd.js:1376 Uncaught Error: Unknown identifier ClassDefEx-t-202.$.assigned
at throwUnknownIdentifier (gantt.umd.js:1376:9)
at EngineTransaction.get (Transaction.js:149:13)
at EngineReplica.get (Graph.js:390:9)
at TemplateClass.getFromGraph (ModelFieldAtom.js:68:46)
at ClassDefEx.get (Entity.js:159:13)
at ClassDefEx.get assignments (gantt.umd.js:98321:19)
at ClassDefEx.get assignments [as assignments] (TaskModel.js:796:13)
at ResourceAssignmentColumn.getRawValue (Column.js:954:9)
at Row.renderCell (Row.js:542:28)
at Row.render (Row.js:466:17)
throwUnknownIdentifier @ gantt.umd.js:1376
get @ Transaction.js:149
get @ Graph.js:390
getFromGraph @ ModelFieldAtom.js:68
get @ Entity.js:159
get assignments @ gantt.umd.js:98321
get assignments @ TaskModel.js:796
getRawValue @ Column.js:954
renderCell @ Row.js:542
render @ Row.js:466
renderFromRow @ RowManager.js:790
matchRowCount @ RowManager.js:184
calculateRowCount @ RowManager.js:222
initWithHeight @ RowManager.js:123
onInternalResize @ GridElementEvents.js:666
onInternalResize @ GridBase.js:1149
functionChainRunner @ InstancePlugin.js:314
plugInto.<computed> @ InstancePlugin.js:289
onElementResize @ Widget.js:4556
onElementResize @ ResizeMonitor.js:166


Post by mats »

How can we reproduce? Please upload a test case.


Post by quandarycg »

Here is my project Model, let me know if there is any additional information that would be helpful.

{
    "success": true,
    "single": true,
    "calendarsData": [
        {
            "id": "general",
            "name": "General",
            "intervals": [],
            "expanded": true,
            // here is where ive tried to set "unspecifiedTimeIsWorking": false
            "children": [
                {
                    "id": "erc-365",
                    "name": "****, J's Calendar",
                    "intervals": []
                },
                {
                    "id": "sdrc-2",
                    "name": "Quandary's Calendar",
                    // also tried to set "unspecifiedTimeIsWorking": false here
                    "intervals": [
                        {
                            "recurrentStartDate": "every weekday at 00:00 after 2020-12-27T00:00:00 before 2021-01-03T00:00:00",
                            "recurrentEndDate": "every weekday at 20:00 after 2020-12-27T00:00:00 before 2021-01-03T00:00:00",
                            "isWorking": false
                        },
                        {
                            "recurrentStartDate": "every weekday at 00:00 after 2021-01-03T00:00:00 before 2021-01-10T00:00:00",
                            "recurrentEndDate": "every weekday at 20:00 after 2021-01-03T00:00:00 before 2021-01-10T00:00:00",
                            "isWorking": false
                        },
                        {
                            "recurrentStartDate": "every weekday at 00:00 after 2021-01-10T00:00:00 before 2021-01-17T00:00:00",
                            "recurrentEndDate": "every weekday at 20:00 after 2021-01-10T00:00:00 before 2021-01-17T00:00:00",
                            "isWorking": false
                        },
                        {
                            "recurrentStartDate": "every weekday at 00:00 after 2021-01-17T00:00:00 before 2021-01-24T00:00:00",
                            "recurrentEndDate": "every weekday at 20:00 after 2021-01-17T00:00:00 before 2021-01-24T00:00:00",
                            "isWorking": false
                        },
                        {
                            "recurrentStartDate": "every weekday at 00:00 after 2021-01-24T00:00:00 before 2021-01-31T00:00:00",
                            "recurrentEndDate": "every weekday at 20:00 after 2021-01-24T00:00:00 before 2021-01-31T00:00:00",
                            "isWorking": false
                        },
                        {
                            "recurrentStartDate": "every weekday at 00:00 after 2021-01-31T00:00:00 before 2021-02-07T00:00:00",
                            "recurrentEndDate": "every weekday at 20:00 after 2021-01-31T00:00:00 before 2021-02-07T00:00:00",
                            "isWorking": false
                        },
                        {
                            "recurrentStartDate": "every weekday at 00:00 after 2021-02-07T00:00:00 before 2021-02-14T00:00:00",
                            "recurrentEndDate": "every weekday at 20:00 after 2021-02-07T00:00:00 before 2021-02-14T00:00:00",
                            "isWorking": false
                        },
                        {
                            "recurrentStartDate": "every weekday at 00:00 after 2021-02-14T00:00:00 before 2021-02-21T00:00:00",
                            "recurrentEndDate": "every weekday at 20:00 after 2021-02-14T00:00:00 before 2021-02-21T00:00:00",
                            "isWorking": false
                        },
                        {
                            "recurrentStartDate": "every weekday at 00:00 after 2021-02-21T00:00:00 before 2021-02-28T00:00:00",
                            "recurrentEndDate": "every weekday at 20:00 after 2021-02-21T00:00:00 before 2021-02-28T00:00:00",
                            "isWorking": false
                        },
                        {
                            "recurrentStartDate": "every weekday at 00:00 after 2021-02-28T00:00:00 before 2021-03-07T00:00:00",
                            "recurrentEndDate": "every weekday at 20:00 after 2021-02-28T00:00:00 before 2021-03-07T00:00:00",
                            "isWorking": false
                        },
                        {
                            "recurrentStartDate": "every weekday at 00:00 after 2021-03-07T00:00:00 before 2021-03-14T00:00:00",
                            "recurrentEndDate": "every weekday at 20:00 after 2021-03-07T00:00:00 before 2021-03-14T00:00:00",
                            "isWorking": false
                        },
                        {
                            "recurrentStartDate": "every weekday at 00:00 after 2021-03-14T00:00:00 before 2021-03-21T00:00:00",
                            "recurrentEndDate": "every weekday at 20:00 after 2021-03-14T00:00:00 before 2021-03-21T00:00:00",
                            "isWorking": false
                        },
                        {
                            "recurrentStartDate": "every weekday at 00:00 after 2021-03-21T00:00:00 before 2021-03-28T00:00:00",
                            "recurrentEndDate": "every weekday at 20:00 after 2021-03-21T00:00:00 before 2021-03-28T00:00:00",
                            "isWorking": false
                        },
                        {
                            "recurrentStartDate": "every weekday at 00:00 after 2021-03-28T00:00:00 before 2021-04-04T00:00:00",
                            "recurrentEndDate": "every weekday at 20:00 after 2021-03-28T00:00:00 before 2021-04-04T00:00:00",
                            "isWorking": false
                        },
                        {
                            "recurrentStartDate": "every weekday at 00:00 after 2021-04-04T00:00:00 before 2021-04-11T00:00:00",
                            "recurrentEndDate": "every weekday at 20:00 after 2021-04-04T00:00:00 before 2021-04-11T00:00:00",
                            "isWorking": false
                        },
                        {
                            "recurrentStartDate": "every weekday at 00:00 after 2021-04-11T00:00:00 before 2021-04-18T00:00:00",
                            "recurrentEndDate": "every weekday at 20:00 after 2021-04-11T00:00:00 before 2021-04-18T00:00:00",
                            "isWorking": false
                        },
                        {
                            "recurrentStartDate": "every weekday at 00:00 after 2021-04-18T00:00:00 before 2021-04-25T00:00:00",
                            "recurrentEndDate": "every weekday at 20:00 after 2021-04-18T00:00:00 before 2021-04-25T00:00:00",
                            "isWorking": false
                        },
                        {
                            "recurrentStartDate": "every weekday at 00:00 after 2021-04-25T00:00:00 before 2021-05-02T00:00:00",
                            "recurrentEndDate": "every weekday at 20:00 after 2021-04-25T00:00:00 before 2021-05-02T00:00:00",
                            "isWorking": false
                        },
                        {
                            "recurrentStartDate": "every weekday at 00:00 after 2021-05-02T00:00:00 before 2021-05-09T00:00:00",
                            "recurrentEndDate": "every weekday at 20:00 after 2021-05-02T00:00:00 before 2021-05-09T00:00:00",
                            "isWorking": false
                        },
                        {
                            "recurrentStartDate": "every weekday at 00:00 after 2021-05-09T00:00:00 before 2021-05-16T00:00:00",
                            "recurrentEndDate": "every weekday at 20:00 after 2021-05-09T00:00:00 before 2021-05-16T00:00:00",
                            "isWorking": false
                        },
                        {
                            "recurrentStartDate": "every weekday at 00:00 after 2021-05-16T00:00:00 before 2021-05-23T00:00:00",
                            "recurrentEndDate": "every weekday at 20:00 after 2021-05-16T00:00:00 before 2021-05-23T00:00:00",
                            "isWorking": false
                        },
                    ]
                },
                {
                    "id": "erc-299",
                    "name": "****, D's Calendar",
                    "intervals": [
                    ]
                }
            ]
        }
    ],
    "eventsData": [
        {
            "id": "p-33",
            "name": "Gantt Test Project",
            "displayName": "<img src=\"https://images.quickbase.com/si/16/226-rect_gray.png\" title=\"Not Started\">|Gantt Test Project|Medium",
            "returnToQB": "https://company.quickbase.com/db/bpwx528ch?a=er&rid=33",
            "timeDuration": 220.5,
            "estimatedHours": "",
            "recentDescription": "",
            "recentStatus": "",
            "milestoneValue": false,
            "children": [
                {
                    "id": "r-19",
                    "name": "REQ 1",
                    "displayName": "REQ 1|",
                    "expanded": true,
                    "estimatedHours": "",
                    "returnToQB": "https://company.quickbase.com/db/brnjwbvt3?a=dr&rid=19",
                    "recentStatus": "Completed",
                    "timeDuration": 174.5,
                    "recentDescription": "comment 4",
                    "style": "background:#757575",
                    "milestoneValue": false,
                    "children": [
                        {
                            "id": "t-184",
                            "name": "REQ 1-15",
                            "displayName": "<img src=\"https://images.quickbase.com/si/16/049-clock.png\" title=\"Delayed Start\">|REQ 1-15|",
                            "startDate": "2021-02-25",
                            "returnToQB": "https://company.quickbase.com/db/bpwx528cn?a=dr&rid=184",
                            "duration": 19,
                            "recentStatus": "Not Started",
                            "percentDone": 25,
                            "timeDuration": 4,
                            "recentDescription": "",
                            "milestoneValue": false,
                            "hadPredecessor": "0"
                        },
                        {
                            "id": "t-291",
                            "name": "REQ 1-15",
                            "displayName": "<img src=\"https://images.quickbase.com/si/16/049-clock.png\" title=\"Delayed Start\">|REQ 1-15|",
                            "startDate": "2021-02-25",
                            "returnToQB": "https://company.quickbase.com/db/bpwx528cn?a=dr&rid=291",
                            "duration": 19,
                            "recentStatus": "Not Started",
                            "percentDone": 25,
                            "timeDuration": 4,
                            "recentDescription": "",
                            "milestoneValue": false,
                            "hadPredecessor": "0"
                        },
                        {
                            "id": "t-271",
                            "name": "New task 2",
                            "displayName": "<img src=\"https://images.quickbase.com/si/16/049-clock.png\" title=\"Delayed Start\">|New task 2|",
                            "startDate": "2021-03-07",
                            "returnToQB": "https://company.quickbase.com/db/bpwx528cn?a=dr&rid=271",
                            "duration": 0,
                            "recentStatus": "Not Started",
                            "percentDone": 0,
                            "timeDuration": 2,
                            "recentDescription": "",
                            "milestoneValue": true,
                            "hadPredecessor": "0"
                        },
                        {
                            "id": "t-292",
                            "name": "New task 2",
                            "displayName": "<img src=\"https://images.quickbase.com/si/16/049-clock.png\" title=\"Delayed Start\">|New task 2|",
                            "startDate": "2021-03-07",
                            "returnToQB": "https://company.quickbase.com/db/bpwx528cn?a=dr&rid=292",
                            "duration": 0,
                            "recentStatus": "Not Started",
                            "percentDone": 0,
                            "timeDuration": 2,
                            "recentDescription": "",
                            "milestoneValue": true,
                            "hadPredecessor": "0"
                        },
                        {
                            "id": "t-266",
                            "name": "New milestone 4",
                            "displayName": "<img src=\"https://images.quickbase.com/si/16/049-clock.png\" title=\"Delayed Start\">|New milestone 4|",
                            "startDate": "2021-03-09",
                            "returnToQB": "https://company.quickbase.com/db/bpwx528cn?a=dr&rid=266",
                            "duration": 4,
                            "recentStatus": "Not Started",
                            "percentDone": 0,
                            "timeDuration": 6,
                            "recentDescription": "",
                            "milestoneValue": false,
                            "hadPredecessor": "0"
                        },
                        {
                            "id": "t-268",
                            "name": "New milestone 4",
                            "displayName": "<img src=\"https://images.quickbase.com/si/16/049-clock.png\" title=\"Delayed Start\">|New milestone 4|",
                            "startDate": "2021-03-09",
                            "returnToQB": "https://company.quickbase.com/db/bpwx528cn?a=dr&rid=268",
                            "duration": 0,
                            "recentStatus": "Not Started",
                            "percentDone": 0,
                            "timeDuration": 2,
                            "recentDescription": "",
                            "milestoneValue": true,
                            "hadPredecessor": "0"
                        },
                        {
                            "id": "t-280",
                            "name": "New task 1",
                            "displayName": "<img src=\"https://images.quickbase.com/si/16/049-clock.png\" title=\"Delayed Start\">|New task 1|",
                            "startDate": "2021-03-09",
                            "returnToQB": "https://company.quickbase.com/db/bpwx528cn?a=dr&rid=280",
                            "duration": 0,
                            "recentStatus": "Not Started",
                            "percentDone": 0,
                            "timeDuration": 5,
                            "recentDescription": "",
                            "milestoneValue": true,
                            "hadPredecessor": "0"
                        },
                        {
                            "id": "t-311",
                            "name": "New task  for testing demo",
                            "displayName": "<img src=\"https://images.quickbase.com/si/16/049-clock.png\" title=\"Delayed Start\">|New task  for testing demo|",
                            "startDate": "2021-03-09",
                            "returnToQB": "https://company.quickbase.com/db/bpwx528cn?a=dr&rid=311",
                            "duration": 0,
                            "recentStatus": "Not Started",
                            "percentDone": 0,
                            "timeDuration": 5,
                            "recentDescription": "",
                            "milestoneValue": true,
                            "hadPredecessor": "0"
                        },
                        {
                            "id": "t-312",
                            "name": "New task 2 for testing demo",
                            "displayName": "<img src=\"https://images.quickbase.com/si/16/049-clock.png\" title=\"Delayed Start\">|New task 2 for testing demo|",
                            "startDate": "2021-03-09",
                            "returnToQB": "https://company.quickbase.com/db/bpwx528cn?a=dr&rid=312",
                            "duration": 0,
                            "recentStatus": "Not Started",
                            "percentDone": 0,
                            "timeDuration": 5,
                            "recentDescription": "",
                            "milestoneValue": true,
                            "hadPredecessor": "0"
                        },
                        {
                            "id": "t-227",
                            "name": "New milestone 1",
                            "displayName": "<img src=\"https://images.quickbase.com/si/16/049-clock.png\" title=\"Delayed Start\">|New milestone 1|",
                            "startDate": "2021-03-10",
                            "returnToQB": "https://company.quickbase.com/db/bpwx528cn?a=dr&rid=227",
                            "duration": 0,
                            "recentStatus": "Not Started",
                            "percentDone": 0,
                            "timeDuration": 4,
                            "recentDescription": "",
                            "milestoneValue": true,
                            "hadPredecessor": "0"
                        },
                        {
                            "id": "t-267",
                            "name": "New task 4",
                            "displayName": "<img src=\"https://images.quickbase.com/si/16/049-clock.png\" title=\"Delayed Start\">|New task 4|",
                            "startDate": "2021-03-10",
                            "returnToQB": "https://company.quickbase.com/db/bpwx528cn?a=dr&rid=267",
                            "duration": 5,
                            "recentStatus": "Not Started",
                            "percentDone": 0,
                            "timeDuration": 4,
                            "recentDescription": "",
                            "milestoneValue": false,
                            "hadPredecessor": "0"
                        },
                        {
                            "id": "t-233",
                            "name": "REQ 1-1",
                            "displayName": "<img src=\"https://images.quickbase.com/si/16/049-clock.png\" title=\"Delayed Start\">|REQ 1-1|",
                            "startDate": "2021-03-12",
                            "returnToQB": "https://company.quickbase.com/db/bpwx528cn?a=dr&rid=233",
                            "duration": 0,
                            "recentStatus": "Not Started",
                            "percentDone": 0,
                            "timeDuration": 5,
                            "recentDescription": "",
                            "milestoneValue": true,
                            "hadPredecessor": "0"
                        },
                        {
                            "id": "t-228",
                            "name": "New milestone 12",
                            "displayName": "<img src=\"https://images.quickbase.com/si/16/049-clock.png\" title=\"Delayed Start\">|New milestone 12|",
                            "startDate": "2021-03-13",
                            "returnToQB": "https://company.quickbase.com/db/bpwx528cn?a=dr&rid=228",
                            "duration": 0,
                            "recentStatus": "Not Started",
                            "percentDone": 0,
                            "timeDuration": 2,
                            "recentDescription": "",
                            "milestoneValue": true,
                            "hadPredecessor": "0"
                        },
                        {
                            "id": "t-245",
                            "name": "New milestone 16",
                            "displayName": "<img src=\"https://images.quickbase.com/si/16/049-clock.png\" title=\"Delayed Start\">|New milestone 16|",
                            "startDate": "2021-03-15",
                            "returnToQB": "https://company.quickbase.com/db/bpwx528cn?a=dr&rid=245",
                            "duration": 0,
                            "recentStatus": "Not Started",
                            "percentDone": 0,
                            "timeDuration": 5,
                            "recentDescription": "",
                            "milestoneValue": true,
                            "hadPredecessor": "0"
                        },
                        {
                            "id": "t-276",
                            "name": "New task 1",
                            "displayName": "<img src=\"https://images.quickbase.com/si/16/049-clock.png\" title=\"Delayed Start\">|New task 1|",
                            "startDate": "2021-03-15",
                            "returnToQB": "https://company.quickbase.com/db/bpwx528cn?a=dr&rid=276",
                            "duration": 0,
                            "recentStatus": "Not Started",
                            "percentDone": 0,
                            "timeDuration": 4,
                            "recentDescription": "",
                            "milestoneValue": true,
                            "hadPredecessor": "0"
                        },
                        {
                            "id": "t-278",
                            "name": "New task 1",
                            "displayName": "<img src=\"https://images.quickbase.com/si/16/049-clock.png\" title=\"Delayed Start\">|New task 1|",
                            "startDate": "2021-03-15",
                            "returnToQB": "https://company.quickbase.com/db/bpwx528cn?a=dr&rid=278",
                            "duration": 0,
                            "recentStatus": "Not Started",
                            "percentDone": 0,
                            "timeDuration": 3,
                            "recentDescription": "",
                            "milestoneValue": true,
                            "hadPredecessor": "0"
                        },
                        {
                            "id": "t-279",
                            "name": "New task 1",
                            "displayName": "<img src=\"https://images.quickbase.com/si/16/049-clock.png\" title=\"Delayed Start\">|New task 1|",
                            "startDate": "2021-03-15",
                            "returnToQB": "https://company.quickbase.com/db/bpwx528cn?a=dr&rid=279",
                            "duration": 0,
                            "recentStatus": "Not Started",
                            "percentDone": 0,
                            "timeDuration": 2,
                            "recentDescription": "",
                            "milestoneValue": true,
                            "hadPredecessor": "1"
                        },
                        {
                            "id": "t-202",
                            "name": "New task 1",
                            "displayName": "<img src=\"https://images.quickbase.com/si/16/049-clock.png\" title=\"Delayed Start\">|New task 1|",
                            "startDate": "2021-03-17",
                            "returnToQB": "https://company.quickbase.com/db/bpwx528cn?a=dr&rid=202",
                            "duration": 18.958333333333,
                            "recentStatus": "Not Started",
                            "percentDone": 50,
                            "timeDuration": 1,
                            "recentDescription": "",
                            "milestoneValue": false,
                            "hadPredecessor": "0"
                        },
                        {
                            "id": "t-246",
                            "name": "test task",
                            "displayName": "<img src=\"https://images.quickbase.com/si/16/049-clock.png\" title=\"Delayed Start\">|test task|",
                            "startDate": "2021-03-23",
                            "returnToQB": "https://company.quickbase.com/db/bpwx528cn?a=dr&rid=246",
                            "duration": 5,
                            "recentStatus": "Not Started",
                            "percentDone": 0,
                            "timeDuration": 3,
                            "recentDescription": "",
                            "milestoneValue": false,
                            "hadPredecessor": "0"
                        },
                        {
                            "id": "t-277",
                            "name": "New task 2",
                            "displayName": "<img src=\"https://images.quickbase.com/si/16/049-clock.png\" title=\"Delayed Start\">|New task 2|",
                            "startDate": "2021-03-23",
                            "returnToQB": "https://company.quickbase.com/db/bpwx528cn?a=dr&rid=277",
                            "duration": 5,
                            "recentStatus": "Not Started",
                            "percentDone": 0,
                            "timeDuration": 0.5,
                            "recentDescription": "",
                            "milestoneValue": false,
                            "hadPredecessor": "0"
                        },
                        {
                            "id": "t-204",
                            "name": "New task 1",
                            "displayName": "<img src=\"https://images.quickbase.com/si/16/049-clock.png\" title=\"Delayed Start\">|New task 1|",
                            "startDate": "2021-03-24",
                            "returnToQB": "https://company.quickbase.com/db/bpwx528cn?a=dr&rid=204",
                            "duration": 5,
                            "recentStatus": "Not Started",
                            "percentDone": 75,
                            "timeDuration": 5,
                            "recentDescription": "",
                            "milestoneValue": false,
                            "hadPredecessor": "1"
                        },
                        {
                            "id": "t-251",
                            "name": "New task 1",
                            "displayName": "<img src=\"https://images.quickbase.com/si/16/049-clock.png\" title=\"Delayed Start\">|New task 1|",
                            "startDate": "2021-03-24",
                            "returnToQB": "https://company.quickbase.com/db/bpwx528cn?a=dr&rid=251",
                            "duration": 5,
                            "recentStatus": "Not Started",
                            "percentDone": 0,
                            "timeDuration": 4,
                            "recentDescription": "",
                            "milestoneValue": true,
                            "hadPredecessor": "1"
                        },
                        {
                            "id": "t-264",
                            "name": "New task 1",
                            "displayName": "<img src=\"https://images.quickbase.com/si/16/049-clock.png\" title=\"Delayed Start\">|New task 1|",
                            "startDate": "2021-03-24",
                            "returnToQB": "https://company.quickbase.com/db/bpwx528cn?a=dr&rid=264",
                            "duration": 18.958333333333,
                            "recentStatus": "Not Started",
                            "percentDone": 0,
                            "timeDuration": 9,
                            "recentDescription": "",
                            "milestoneValue": false,
                            "hadPredecessor": "1"
                        },
                        {
                            "id": "t-270",
                            "name": "New task 40",
                            "displayName": "<img src=\"https://images.quickbase.com/si/16/049-clock.png\" title=\"Delayed Start\">|New task 40|",
                            "startDate": "2021-03-24",
                            "returnToQB": "https://company.quickbase.com/db/bpwx528cn?a=dr&rid=270",
                            "duration": 18.958333333333,
                            "recentStatus": "Not Started",
                            "percentDone": 0,
                            "timeDuration": 2,
                            "recentDescription": "",
                            "milestoneValue": false,
                            "hadPredecessor": "1"
                        },
                        {
                            "id": "t-224",
                            "name": "New task 1",
                            "displayName": "<img src=\"https://images.quickbase.com/si/16/049-clock.png\" title=\"Delayed Start\">|New task 1|",
                            "startDate": "2021-03-25",
                            "returnToQB": "https://company.quickbase.com/db/bpwx528cn?a=dr&rid=224",
                            "duration": 10.958333333333,
                            "recentStatus": "Not Started",
                            "percentDone": 0,
                            "timeDuration": 5,
                            "recentDescription": "",
                            "milestoneValue": false,
                            "hadPredecessor": "1"
                        },
                        {
                            "id": "t-225",
                            "name": "Changes test",
                            "displayName": "<img src=\"https://images.quickbase.com/si/16/049-clock.png\" title=\"Delayed Start\">|Changes test|",
                            "startDate": "2021-04-19",
                            "returnToQB": "https://company.quickbase.com/db/bpwx528cn?a=dr&rid=225",
                            "duration": 5,
                            "recentStatus": "Not Started",
                            "percentDone": 0,
                            "timeDuration": 8,
                            "recentDescription": "",
                            "milestoneValue": false,
                            "hadPredecessor": "0"
                        },
                        {
                            "id": "t-281",
                            "name": "New task 1",
                            "displayName": "<img src=\"https://images.quickbase.com/si/16/049-clock.png\" title=\"Delayed Start\">|New task 1|",
                            "startDate": "2021-04-19",
                            "returnToQB": "https://company.quickbase.com/db/bpwx528cn?a=dr&rid=281",
                            "duration": 5,
                            "recentStatus": "Not Started",
                            "percentDone": 0,
                            "timeDuration": 8,
                            "recentDescription": "",
                            "milestoneValue": false,
                            "hadPredecessor": "0"
                        },
                        {
                            "id": "t-282",
                            "name": "New task 1",
                            "displayName": "<img src=\"https://images.quickbase.com/si/16/049-clock.png\" title=\"Delayed Start\">|New task 1|",
                            "startDate": "2021-04-19",
                            "returnToQB": "https://company.quickbase.com/db/bpwx528cn?a=dr&rid=282",
                            "duration": 5,
                            "recentStatus": "Not Started",
                            "percentDone": 0,
                            "timeDuration": 8,
                            "recentDescription": "",
                            "milestoneValue": false,
                            "hadPredecessor": "0"
                        },
                        {
                            "id": "t-283",
                            "name": "New task 1",
                            "displayName": "<img src=\"https://images.quickbase.com/si/16/049-clock.png\" title=\"Delayed Start\">|New task 1|",
                            "startDate": "2021-04-19",
                            "returnToQB": "https://company.quickbase.com/db/bpwx528cn?a=dr&rid=283",
                            "duration": 5,
                            "recentStatus": "Not Started",
                            "percentDone": 0,
                            "timeDuration": 8,
                            "recentDescription": "",
                            "milestoneValue": false,
                            "hadPredecessor": "0"
                        },
                        {
                            "id": "t-284",
                            "name": "New task 1",
                            "displayName": "<img src=\"https://images.quickbase.com/si/16/049-clock.png\" title=\"Delayed Start\">|New task 1|",
                            "startDate": "2021-04-19",
                            "returnToQB": "https://company.quickbase.com/db/bpwx528cn?a=dr&rid=284",
                            "duration": 5,
                            "recentStatus": "Not Started",
                            "percentDone": 0,
                            "timeDuration": 8,
                            "recentDescription": "",
                            "milestoneValue": false,
                            "hadPredecessor": "0"
                        },
                        {
                            "id": "t-285",
                            "name": "New task 2",
                            "displayName": "<img src=\"https://images.quickbase.com/si/16/049-clock.png\" title=\"Delayed Start\">|New task 2|",
                            "startDate": "2021-04-19",
                            "returnToQB": "https://company.quickbase.com/db/bpwx528cn?a=dr&rid=285",
                            "duration": 5,
                            "recentStatus": "Not Started",
                            "percentDone": 0,
                            "timeDuration": 8,
                            "recentDescription": "",
                            "milestoneValue": false,
                            "hadPredecessor": "0"
                        },
                        {
                            "id": "t-286",
                            "name": "New task 1",
                            "displayName": "<img src=\"https://images.quickbase.com/si/16/049-clock.png\" title=\"Delayed Start\">|New task 1|",
                            "startDate": "2021-04-19",
                            "returnToQB": "https://company.quickbase.com/db/bpwx528cn?a=dr&rid=286",
                            "duration": 5,
                            "recentStatus": "Not Started",
                            "percentDone": 0,
                            "timeDuration": 8,
                            "recentDescription": "",
                            "milestoneValue": false,
                            "hadPredecessor": "0"
                        },
                        {
                            "id": "t-287",
                            "name": "New task 2",
                            "displayName": "<img src=\"https://images.quickbase.com/si/16/049-clock.png\" title=\"Delayed Start\">|New task 2|",
                            "startDate": "2021-04-19",
                            "returnToQB": "https://company.quickbase.com/db/bpwx528cn?a=dr&rid=287",
                            "duration": 5,
                            "recentStatus": "Not Started",
                            "percentDone": 0,
                            "timeDuration": 8,
                            "recentDescription": "",
                            "milestoneValue": false,
                            "hadPredecessor": "0"
                        },
                        {
                            "id": "t-288",
                            "name": "New task 3",
                            "displayName": "<img src=\"https://images.quickbase.com/si/16/049-clock.png\" title=\"Delayed Start\">|New task 3|",
                            "startDate": "2021-04-19",
                            "returnToQB": "https://company.quickbase.com/db/bpwx528cn?a=dr&rid=288",
                            "duration": 5,
                            "recentStatus": "Not Started",
                            "percentDone": 0,
                            "timeDuration": 8,
                            "recentDescription": "",
                            "milestoneValue": false,
                            "hadPredecessor": "0"
                        },
                        {
                            "id": "t-289",
                            "name": "New task 4",
                            "displayName": "<img src=\"https://images.quickbase.com/si/16/049-clock.png\" title=\"Delayed Start\">|New task 4|",
                            "startDate": "2021-04-19",
                            "returnToQB": "https://company.quickbase.com/db/bpwx528cn?a=dr&rid=289",
                            "duration": 5,
                            "recentStatus": "Not Started",
                            "percentDone": 0,
                            "timeDuration": 8,
                            "recentDescription": "",
                            "milestoneValue": false,
                            "hadPredecessor": "0"
                        },
                        {
                            "id": "t-272",
                            "name": "New task 3",
                            "displayName": "<img src=\"https://images.quickbase.com/si/16/049-clock.png\" title=\"Delayed Start\">|New task 3|",
                            "startDate": "2021-04-20",
                            "returnToQB": "https://company.quickbase.com/db/bpwx528cn?a=dr&rid=272",
                            "duration": 18.958333333333,
                            "recentStatus": "Not Started",
                            "percentDone": 0,
                            "timeDuration": 1,
                            "recentDescription": "",
                            "milestoneValue": false,
                            "hadPredecessor": "1"
                        }
                    ]
                },
            ],
            "expanded": false
        },
        {
            "id": "p-34",
            "name": "Page",
            "displayName": "<img src=\"https://images.quickbase.com/si/16/226-rect_gray.png\" title=\"Not Started\">|Page|Medium",
            "returnToQB": "https://company.quickbase.com/db/bpwx528ch?a=er&rid=34",
            "timeDuration": 0,
            "estimatedHours": "",
            "recentDescription": "",
            "recentStatus": "",
            "milestoneValue": false,
            "children": [
                {
                    "id": "r-32",
                    "name": "Page Changes",
                    "displayName": "Page Changes|DESIGN",
                    "expanded": true,
                    "estimatedHours": "",
                    "returnToQB": "https://company.quickbase.com/db/brnjwbvt3?a=dr&rid=32",
                    "recentStatus": "Approved",
                    "timeDuration": 0,
                    "recentDescription": "",
                    "style": "background:#757575",
                    "milestoneValue": false,
                    "children": [
                        {
                            "id": "t-156",
                            "name": "Update Echo Summary Counts",
                            "displayName": "<img src=\"https://images.quickbase.com/si/16/220-point_gray.png\" title=\"Inactive\">|Update Echo Summary Counts|",
                            "startDate": "2021-12-10",
                            "returnToQB": "https://company.quickbase.com/db/bpwx528cn?a=dr&rid=156",
                            "duration": 1,
                            "recentStatus": "Completed",
                            "percentDone": 0,
                            "timeDuration": 0,
                            "recentDescription": "The count at the top of the echo page does not filter out items not visible to certain apps",
                            "milestoneValue": false,
                            "hadPredecessor": "0"
                        }
                    ]
                }
            ],
            "expanded": false
        }
    ],
    "resourcesData": [
        {
            "id": "er-365",
            "name": "****, J",
            "email": "jeff.****@company.com",
            "calendar": "erc-365",
            "rid": "365"
        },
        {
            "id": "sdr-2",
            "name": "Quandary",
            "email": "175.00",
            "calendar": "sdrc-2",
            "rid": "2"
        },
        {
            "id": "er-299",
            "name": "****, D",
            "email": "d@company.com",
            "calendar": "erc-299",
            "rid": "299"
        }
    ],
    "assignmentsData": [
        {
            "id": 28,
            "event": "t-184",
            "resource": "sdr-2"
        },
        {
            "id": 30,
            "event": "t-190",
            "resource": "er-299"
        },
        {
            "id": 33,
            "event": "t-202",
            "resource": "er-"
        },
        {
            "id": 36,
            "event": "t-224",
            "resource": "er-299"
        },
        {
            "id": 37,
            "event": "t-225",
            "resource": "er-299"
        },
        {
            "id": 38,
            "event": "t-227",
            "resource": "sdr-2"
        },
    ],
    "timeRangesData": [],
    "validateResponse": true
}
[\code]

Post by alex.l »

I tried to use this data with our resourcehistogram example and I don't see any errors. Could you please try it yourself or provide a runnable test case to check. Maybe some extra steps/configs required to reproduce that?

Attachments
Screenshot 2022-02-01 at 17.17.12.png
Screenshot 2022-02-01 at 17.17.12.png (285.54 KiB) Viewed 711 times

All the best,
Alex


Post by quandarycg »

Here, unspecified time or unscheduled time, is set to working the full day. Our goal is to have this unspecified time show - Not Available. You have no errors because I commented out the two spots where I tried setting unspecifiedTimeWorking to false.


Post by alex.l »

Ok, I see. Looks like your calendar data is not correct in case you used that flag.

If you set general as an active calendar with the next config:

        {
            "id": "general",
            "name": "General",
            "intervals": [],
            "expanded": true,
            "unspecifiedTimeIsWorking": false,

that means there is no working time at all. Tasks has no periods to be scheduled, because unspecifiedTimeIsWorking is false and there are no intervals what time is working.

If you set child calendars, as example sdrc-2 which does have intervals, the problem will be the same: all unspecified time is already not available, and after you added periods with "isWorking": false, nothing changes - there are still no time to schedule tasks.

If you use unspecifiedTimeIsWorking: false, you need to provide intervals when tasks may be scheduled. Try to update your data.

All the best,
Alex


Post Reply