2c:null 2d:["$","title",null,{"children":"Calendar Pie Visual - Zohocharts | AarthiS | Observable"}] 32:T70c,const calendar = (() => { const frame = document.createElement("iframe"); frame.title = manifest.name; frame.style.cssText = "display:block;width:100%;height:850px;border:0;background:white"; const visualCode = createCalendarVisual.toString().replace(/<\/script/gi, "<\\/script"); const safeJSON = value => JSON.stringify(value).replace(/ group.forEach(setting => {defaults[setting.uniqueName] = setting.defaultValue;})); const runtimeMetadata = {...metadata, customSettings:{...defaults, ...metadata.customSettings}}; frame.srcdoc = `

Loading ZohoCharts…

`; return frame; })(); display(calendar); invalidation.then(() => calendar.remove()); 33:T79a8,const data = [ ["2026-01-01", "Leave", 3], ["2026-01-01", "present", 40], ["2026-01-01", "Remote", 2], ["2026-01-01", "OD", 5], ["2026-01-02", "Leave", 2], ["2026-01-02", "present", 40], ["2026-01-02", "Remote", 6], ["2026-01-02", "OD", 2], ["2026-01-05", "Leave", 2], ["2026-01-05", "present", 34], ["2026-01-05", "Remote", 8], ["2026-01-05", "OD", 6], ["2026-01-06", "Leave", 3], ["2026-01-06", "present", 42], ["2026-01-06", "Remote", 1], ["2026-01-06", "OD", 4], ["2026-01-07", "Leave", 4], ["2026-01-07", "present", 45], ["2026-01-07", "OD", 1], ["2026-01-08", "Leave", 3], ["2026-01-08", "present", 38], ["2026-01-08", "Remote", 4], ["2026-01-08", "OD", 5], ["2026-01-09", "Leave", 5], ["2026-01-09", "present", 39], ["2026-01-09", "Remote", 5], ["2026-01-09", "OD", 1], ["2026-01-12", "Leave", 4], ["2026-01-12", "present", 32], ["2026-01-12", "Remote", 10], ["2026-01-12", "OD", 4], ["2026-01-13", "Leave", 3], ["2026-01-13", "present", 40], ["2026-01-13", "Remote", 7], ["2026-01-14", "Leave", 4], ["2026-01-14", "present", 39], ["2026-01-14", "Remote", 5], ["2026-01-14", "OD", 2], ["2026-01-15", "Leave", 1], ["2026-01-15", "present", 42], ["2026-01-15", "Remote", 4], ["2026-01-15", "OD", 3], ["2026-01-16", "Leave", 4], ["2026-01-16", "present", 38], ["2026-01-16", "Remote", 4], ["2026-01-16", "OD", 4], ["2026-01-19", "Leave", 7], ["2026-01-19", "present", 37], ["2026-01-19", "Remote", 4], ["2026-01-19", "OD", 2], ["2026-01-20", "Leave", 4], ["2026-01-20", "present", 34], ["2026-01-20", "Remote", 10], ["2026-01-20", "OD", 2], ["2026-01-21", "Leave", 4], ["2026-01-21", "present", 39], ["2026-01-21", "Remote", 6], ["2026-01-21", "OD", 1], ["2026-01-22", "Leave", 5], ["2026-01-22", "present", 35], ["2026-01-22", "Remote", 7], ["2026-01-22", "OD", 3], ["2026-01-23", "Leave", 3], ["2026-01-23", "present", 36], ["2026-01-23", "Remote", 9], ["2026-01-23", "OD", 2], ["2026-01-26", "Leave", 5], ["2026-01-26", "present", 37], ["2026-01-26", "Remote", 6], ["2026-01-26", "OD", 2], ["2026-01-27", "Leave", 4], ["2026-01-27", "present", 39], ["2026-01-27", "Remote", 4], ["2026-01-27", "OD", 3], ["2026-01-28", "Leave", 3], ["2026-01-28", "present", 38], ["2026-01-28", "Remote", 8], ["2026-01-28", "OD", 1], ["2026-01-29", "Leave", 2], ["2026-01-29", "present", 37], ["2026-01-29", "Remote", 7], ["2026-01-29", "OD", 4], ["2026-01-30", "Leave", 8], ["2026-01-30", "present", 38], ["2026-01-30", "Remote", 2], ["2026-01-30", "OD", 2], ["2026-02-02", "Leave", 3], ["2026-02-02", "present", 34], ["2026-02-02", "Remote", 9], ["2026-02-02", "OD", 4], ["2026-02-03", "Leave", 5], ["2026-02-03", "present", 30], ["2026-02-03", "Remote", 9], ["2026-02-03", "OD", 6], ["2026-02-04", "Leave", 3], ["2026-02-04", "present", 42], ["2026-02-04", "Remote", 4], ["2026-02-04", "OD", 1], ["2026-02-05", "Leave", 4], ["2026-02-05", "present", 39], ["2026-02-05", "Remote", 7], ["2026-02-06", "Leave", 4], ["2026-02-06", "present", 41], ["2026-02-06", "Remote", 4], ["2026-02-06", "OD", 1], ["2026-02-09", "Leave", 5], ["2026-02-09", "present", 37], ["2026-02-09", "Remote", 6], ["2026-02-09", "OD", 2], ["2026-02-10", "Leave", 4], ["2026-02-10", "present", 38], ["2026-02-10", "Remote", 6], ["2026-02-10", "OD", 2], ["2026-02-11", "Leave", 3], ["2026-02-11", "present", 41], ["2026-02-11", "Remote", 4], ["2026-02-11", "OD", 2], ["2026-02-12", "Leave", 2], ["2026-02-12", "present", 41], ["2026-02-12", "Remote", 6], ["2026-02-12", "OD", 1], ["2026-02-13", "Leave", 4], ["2026-02-13", "present", 39], ["2026-02-13", "Remote", 5], ["2026-02-13", "OD", 2], ["2026-02-16", "Leave", 1], ["2026-02-16", "present", 36], ["2026-02-16", "Remote", 11], ["2026-02-16", "OD", 2], ["2026-02-17", "Leave", 4], ["2026-02-17", "present", 41], ["2026-02-17", "Remote", 4], ["2026-02-17", "OD", 1], ["2026-02-18", "Leave", 4], ["2026-02-18", "present", 35], ["2026-02-18", "Remote", 9], ["2026-02-18", "OD", 2], ["2026-02-19", "Leave", 2], ["2026-02-19", "present", 36], ["2026-02-19", "Remote", 8], ["2026-02-19", "OD", 4], ["2026-02-20", "Leave", 2], ["2026-02-20", "present", 39], ["2026-02-20", "Remote", 7], ["2026-02-20", "OD", 2], ["2026-02-23", "Leave", 6], ["2026-02-23", "present", 38], ["2026-02-23", "Remote", 4], ["2026-02-23", "OD", 2], ["2026-02-24", "Leave", 2], ["2026-02-24", "present", 41], ["2026-02-24", "Remote", 4], ["2026-02-24", "OD", 3], ["2026-02-25", "Leave", 5], ["2026-02-25", "present", 31], ["2026-02-25", "Remote", 10], ["2026-02-25", "OD", 4], ["2026-02-26", "Leave", 5], ["2026-02-26", "present", 33], ["2026-02-26", "Remote", 7], ["2026-02-26", "OD", 5], ["2026-02-27", "Leave", 1], ["2026-02-27", "present", 33], ["2026-02-27", "Remote", 9], ["2026-02-27", "OD", 7], ["2026-03-02", "Leave", 5], ["2026-03-02", "present", 37], ["2026-03-02", "Remote", 8], ["2026-03-03", "Leave", 5], ["2026-03-03", "present", 41], ["2026-03-03", "Remote", 3], ["2026-03-03", "OD", 1], ["2026-03-04", "Leave", 7], ["2026-03-04", "present", 34], ["2026-03-04", "Remote", 5], ["2026-03-04", "OD", 4], ["2026-03-05", "Leave", 2], ["2026-03-05", "present", 39], ["2026-03-05", "Remote", 6], ["2026-03-05", "OD", 3], ["2026-03-06", "Leave", 5], ["2026-03-06", "present", 38], ["2026-03-06", "Remote", 6], ["2026-03-06", "OD", 1], ["2026-03-09", "Leave", 1], ["2026-03-09", "present", 41], ["2026-03-09", "Remote", 4], ["2026-03-09", "OD", 4], ["2026-03-10", "Leave", 2], ["2026-03-10", "present", 42], ["2026-03-10", "Remote", 3], ["2026-03-10", "OD", 3], ["2026-03-11", "Leave", 2], ["2026-03-11", "present", 33], ["2026-03-11", "Remote", 12], ["2026-03-11", "OD", 3], ["2026-03-12", "Leave", 4], ["2026-03-12", "present", 37], ["2026-03-12", "Remote", 7], ["2026-03-12", "OD", 2], ["2026-03-13", "Leave", 3], ["2026-03-13", "present", 37], ["2026-03-13", "Remote", 7], ["2026-03-13", "OD", 3], ["2026-03-16", "Leave", 8], ["2026-03-16", "present", 32], ["2026-03-16", "Remote", 9], ["2026-03-16", "OD", 1], ["2026-03-17", "Leave", 5], ["2026-03-17", "present", 33], ["2026-03-17", "Remote", 7], ["2026-03-17", "OD", 5], ["2026-03-18", "Leave", 5], ["2026-03-18", "present", 33], ["2026-03-18", "Remote", 8], ["2026-03-18", "OD", 4], ["2026-03-19", "Leave", 4], ["2026-03-19", "present", 35], ["2026-03-19", "Remote", 4], ["2026-03-19", "OD", 7], ["2026-03-20", "Leave", 6], ["2026-03-20", "present", 38], ["2026-03-20", "Remote", 5], ["2026-03-20", "OD", 1], ["2026-03-23", "Leave", 3], ["2026-03-23", "present", 37], ["2026-03-23", "Remote", 6], ["2026-03-23", "OD", 4], ["2026-03-24", "Leave", 2], ["2026-03-24", "present", 37], ["2026-03-24", "Remote", 7], ["2026-03-24", "OD", 4], ["2026-03-25", "Leave", 2], ["2026-03-25", "present", 37], ["2026-03-25", "Remote", 7], ["2026-03-25", "OD", 4], ["2026-03-26", "Leave", 4], ["2026-03-26", "present", 39], ["2026-03-26", "Remote", 3], ["2026-03-26", "OD", 4], ["2026-03-27", "Leave", 3], ["2026-03-27", "present", 36], ["2026-03-27", "Remote", 6], ["2026-03-27", "OD", 5], ["2026-03-30", "Leave", 4], ["2026-03-30", "present", 34], ["2026-03-30", "Remote", 12], ["2026-03-31", "Leave", 2], ["2026-03-31", "present", 40], ["2026-03-31", "Remote", 7], ["2026-03-31", "OD", 1], ["2026-04-01", "Leave", 3], ["2026-04-01", "present", 38], ["2026-04-01", "Remote", 7], ["2026-04-01", "OD", 2], ["2026-04-02", "Leave", 4], ["2026-04-02", "present", 36], ["2026-04-02", "Remote", 5], ["2026-04-02", "OD", 5], ["2026-04-03", "Leave", 1], ["2026-04-03", "present", 43], ["2026-04-03", "Remote", 4], ["2026-04-03", "OD", 2], ["2026-04-06", "Leave", 4], ["2026-04-06", "present", 36], ["2026-04-06", "Remote", 6], ["2026-04-06", "OD", 4], ["2026-04-07", "Leave", 4], ["2026-04-07", "present", 37], ["2026-04-07", "Remote", 8], ["2026-04-07", "OD", 1], ["2026-04-08", "Leave", 2], ["2026-04-08", "present", 38], ["2026-04-08", "Remote", 8], ["2026-04-08", "OD", 2], ["2026-04-09", "Leave", 5], ["2026-04-09", "present", 38], ["2026-04-09", "Remote", 5], ["2026-04-09", "OD", 2], ["2026-04-10", "Leave", 4], ["2026-04-10", "present", 38], ["2026-04-10", "Remote", 5], ["2026-04-10", "OD", 3], ["2026-04-13", "Leave", 5], ["2026-04-13", "present", 33], ["2026-04-13", "Remote", 11], ["2026-04-13", "OD", 1], ["2026-04-14", "Leave", 4], ["2026-04-14", "present", 38], ["2026-04-14", "Remote", 6], ["2026-04-14", "OD", 2], ["2026-04-15", "Leave", 4], ["2026-04-15", "present", 38], ["2026-04-15", "Remote", 7], ["2026-04-15", "OD", 1], ["2026-04-16", "Leave", 6], ["2026-04-16", "present", 32], ["2026-04-16", "Remote", 8], ["2026-04-16", "OD", 4], ["2026-04-17", "Leave", 5], ["2026-04-17", "present", 38], ["2026-04-17", "Remote", 3], ["2026-04-17", "OD", 4], ["2026-04-20", "Leave", 2], ["2026-04-20", "present", 40], ["2026-04-20", "Remote", 5], ["2026-04-20", "OD", 3], ["2026-04-21", "Leave", 3], ["2026-04-21", "present", 40], ["2026-04-21", "Remote", 7], ["2026-04-22", "Leave", 5], ["2026-04-22", "present", 32], ["2026-04-22", "Remote", 8], ["2026-04-22", "OD", 5], ["2026-04-23", "Leave", 4], ["2026-04-23", "present", 33], ["2026-04-23", "Remote", 9], ["2026-04-23", "OD", 4], ["2026-04-24", "Leave", 4], ["2026-04-24", "present", 35], ["2026-04-24", "Remote", 9], ["2026-04-24", "OD", 2], ["2026-04-27", "Leave", 3], ["2026-04-27", "present", 39], ["2026-04-27", "Remote", 5], ["2026-04-27", "OD", 3], ["2026-04-28", "Leave", 3], ["2026-04-28", "present", 35], ["2026-04-28", "Remote", 9], ["2026-04-28", "OD", 3], ["2026-04-29", "Leave", 8], ["2026-04-29", "present", 29], ["2026-04-29", "Remote", 8], ["2026-04-29", "OD", 5], ["2026-04-30", "Leave", 6], ["2026-04-30", "present", 33], ["2026-04-30", "Remote", 7], ["2026-04-30", "OD", 4], ["2026-05-01", "Leave", 8], ["2026-05-01", "present", 33], ["2026-05-01", "Remote", 8], ["2026-05-01", "OD", 1], ["2026-05-04", "Leave", 6], ["2026-05-04", "present", 38], ["2026-05-04", "Remote", 4], ["2026-05-04", "OD", 2], ["2026-05-05", "Leave", 4], ["2026-05-05", "present", 36], ["2026-05-05", "Remote", 8], ["2026-05-05", "OD", 2], ["2026-05-06", "Leave", 2], ["2026-05-06", "present", 36], ["2026-05-06", "Remote", 7], ["2026-05-06", "OD", 5], ["2026-05-07", "Leave", 6], ["2026-05-07", "present", 37], ["2026-05-07", "Remote", 4], ["2026-05-07", "OD", 3], ["2026-05-08", "Leave", 7], ["2026-05-08", "present", 36], ["2026-05-08", "Remote", 3], ["2026-05-08", "OD", 4], ["2026-05-11", "Leave", 2], ["2026-05-11", "present", 38], ["2026-05-11", "Remote", 5], ["2026-05-11", "OD", 5], ["2026-05-12", "Leave", 4], ["2026-05-12", "present", 41], ["2026-05-12", "Remote", 2], ["2026-05-12", "OD", 3], ["2026-05-13", "Leave", 4], ["2026-05-13", "present", 36], ["2026-05-13", "Remote", 6], ["2026-05-13", "OD", 4], ["2026-05-14", "Leave", 8], ["2026-05-14", "present", 36], ["2026-05-14", "Remote", 4], ["2026-05-14", "OD", 2], ["2026-05-15", "Leave", 5], ["2026-05-15", "present", 36], ["2026-05-15", "Remote", 6], ["2026-05-15", "OD", 3], ["2026-05-18", "Leave", 5], ["2026-05-18", "present", 37], ["2026-05-18", "Remote", 6], ["2026-05-18", "OD", 2], ["2026-05-19", "Leave", 5], ["2026-05-19", "present", 35], ["2026-05-19", "Remote", 6], ["2026-05-19", "OD", 4], ["2026-05-20", "Leave", 3], ["2026-05-20", "present", 40], ["2026-05-20", "Remote", 3], ["2026-05-20", "OD", 4], ["2026-05-21", "Leave", 9], ["2026-05-21", "present", 34], ["2026-05-21", "Remote", 3], ["2026-05-21", "OD", 4], ["2026-05-22", "Leave", 4], ["2026-05-22", "present", 42], ["2026-05-22", "Remote", 4], ["2026-05-25", "Leave", 3], ["2026-05-25", "present", 41], ["2026-05-25", "Remote", 5], ["2026-05-25", "OD", 1], ["2026-05-26", "Leave", 2], ["2026-05-26", "present", 39], ["2026-05-26", "Remote", 7], ["2026-05-26", "OD", 2], ["2026-05-27", "Leave", 2], ["2026-05-27", "present", 45], ["2026-05-27", "Remote", 2], ["2026-05-27", "OD", 1], ["2026-05-28", "Leave", 2], ["2026-05-28", "present", 38], ["2026-05-28", "Remote", 8], ["2026-05-28", "OD", 2], ["2026-05-29", "Leave", 2], ["2026-05-29", "present", 37], ["2026-05-29", "Remote", 7], ["2026-05-29", "OD", 4], ["2026-06-01", "Leave", 3], ["2026-06-01", "present", 41], ["2026-06-01", "Remote", 5], ["2026-06-01", "OD", 1], ["2026-06-02", "Leave", 5], ["2026-06-02", "present", 37], ["2026-06-02", "Remote", 5], ["2026-06-02", "OD", 3], ["2026-06-03", "Leave", 3], ["2026-06-03", "present", 33], ["2026-06-03", "Remote", 9], ["2026-06-03", "OD", 5], ["2026-06-04", "Leave", 5], ["2026-06-04", "present", 33], ["2026-06-04", "Remote", 7], ["2026-06-04", "OD", 5], ["2026-06-05", "Leave", 7], ["2026-06-05", "present", 37], ["2026-06-05", "Remote", 5], ["2026-06-05", "OD", 1], ["2026-06-08", "Leave", 9], ["2026-06-08", "present", 33], ["2026-06-08", "Remote", 6], ["2026-06-08", "OD", 2], ["2026-06-09", "Leave", 5], ["2026-06-09", "present", 38], ["2026-06-09", "Remote", 6], ["2026-06-09", "OD", 1], ["2026-06-10", "Leave", 3], ["2026-06-10", "present", 39], ["2026-06-10", "Remote", 6], ["2026-06-10", "OD", 2], ["2026-06-11", "present", 42], ["2026-06-11", "Remote", 7], ["2026-06-11", "OD", 1], ["2026-06-12", "Leave", 3], ["2026-06-12", "present", 37], ["2026-06-12", "Remote", 10], ["2026-06-15", "Leave", 7], ["2026-06-15", "present", 32], ["2026-06-15", "Remote", 7], ["2026-06-15", "OD", 4], ["2026-06-16", "Leave", 4], ["2026-06-16", "present", 40], ["2026-06-16", "Remote", 3], ["2026-06-16", "OD", 3], ["2026-06-17", "Leave", 7], ["2026-06-17", "present", 35], ["2026-06-17", "Remote", 7], ["2026-06-17", "OD", 1], ["2026-06-18", "Leave", 1], ["2026-06-18", "present", 41], ["2026-06-18", "Remote", 5], ["2026-06-18", "OD", 3], ["2026-06-19", "Leave", 1], ["2026-06-19", "present", 36], ["2026-06-19", "Remote", 9], ["2026-06-19", "OD", 4], ["2026-06-22", "Leave", 6], ["2026-06-22", "present", 38], ["2026-06-22", "Remote", 4], ["2026-06-22", "OD", 2], ["2026-06-23", "Leave", 8], ["2026-06-23", "present", 28], ["2026-06-23", "Remote", 9], ["2026-06-23", "OD", 5], ["2026-06-24", "Leave", 3], ["2026-06-24", "present", 45], ["2026-06-24", "Remote", 2], ["2026-06-25", "Leave", 6], ["2026-06-25", "present", 35], ["2026-06-25", "Remote", 6], ["2026-06-25", "OD", 3], ["2026-06-26", "Leave", 3], ["2026-06-26", "present", 42], ["2026-06-26", "Remote", 3], ["2026-06-26", "OD", 2], ["2026-06-29", "Leave", 7], ["2026-06-29", "present", 26], ["2026-06-29", "Remote", 12], ["2026-06-29", "OD", 5], ["2026-06-30", "Leave", 2], ["2026-06-30", "present", 38], ["2026-06-30", "Remote", 8], ["2026-06-30", "OD", 2], ["2026-07-01", "Leave", 2], ["2026-07-01", "present", 40], ["2026-07-01", "Remote", 7], ["2026-07-01", "OD", 1], ["2026-07-02", "Leave", 5], ["2026-07-02", "present", 31], ["2026-07-02", "Remote", 9], ["2026-07-02", "OD", 5], ["2026-07-03", "Leave", 2], ["2026-07-03", "present", 37], ["2026-07-03", "Remote", 6], ["2026-07-03", "OD", 5], ["2026-07-06", "Leave", 4], ["2026-07-06", "present", 40], ["2026-07-06", "Remote", 4], ["2026-07-06", "OD", 2], ["2026-07-07", "Leave", 3], ["2026-07-07", "present", 35], ["2026-07-07", "Remote", 7], ["2026-07-07", "OD", 5], ["2026-07-08", "Leave", 5], ["2026-07-08", "present", 37], ["2026-07-08", "Remote", 6], ["2026-07-08", "OD", 2], ["2026-07-09", "Leave", 1], ["2026-07-09", "present", 42], ["2026-07-09", "Remote", 4], ["2026-07-09", "OD", 3], ["2026-07-10", "present", 37], ["2026-07-10", "Remote", 12], ["2026-07-10", "OD", 1], ["2026-07-13", "Leave", 6], ["2026-07-13", "present", 34], ["2026-07-13", "Remote", 5], ["2026-07-13", "OD", 5], ["2026-07-14", "Leave", 1], ["2026-07-14", "present", 40], ["2026-07-14", "Remote", 7], ["2026-07-14", "OD", 2], ["2026-07-15", "Leave", 3], ["2026-07-15", "present", 41], ["2026-07-15", "Remote", 4], ["2026-07-15", "OD", 2], ["2026-07-16", "Leave", 6], ["2026-07-16", "present", 31], ["2026-07-16", "Remote", 9], ["2026-07-16", "OD", 4], ["2026-07-17", "Leave", 5], ["2026-07-17", "present", 38], ["2026-07-17", "Remote", 5], ["2026-07-17", "OD", 2], ["2026-07-20", "Leave", 2], ["2026-07-20", "present", 40], ["2026-07-20", "Remote", 6], ["2026-07-20", "OD", 2], ["2026-07-21", "Leave", 6], ["2026-07-21", "present", 36], ["2026-07-21", "Remote", 5], ["2026-07-21", "OD", 3], ["2026-07-22", "Leave", 6], ["2026-07-22", "present", 35], ["2026-07-22", "Remote", 6], ["2026-07-22", "OD", 3], ["2026-07-23", "Leave", 10], ["2026-07-23", "present", 33], ["2026-07-23", "Remote", 5], ["2026-07-23", "OD", 2], ["2026-07-24", "Leave", 4], ["2026-07-24", "present", 37], ["2026-07-24", "Remote", 8], ["2026-07-24", "OD", 1], ["2026-07-27", "Leave", 9], ["2026-07-27", "present", 29], ["2026-07-27", "Remote", 10], ["2026-07-27", "OD", 2], ["2026-07-28", "Leave", 2], ["2026-07-28", "present", 37], ["2026-07-28", "Remote", 9], ["2026-07-28", "OD", 2], ["2026-07-29", "Leave", 4], ["2026-07-29", "present", 39], ["2026-07-29", "Remote", 7], ["2026-07-30", "Leave", 3], ["2026-07-30", "present", 40], ["2026-07-30", "Remote", 3], ["2026-07-30", "OD", 4], ["2026-07-31", "Leave", 3], ["2026-07-31", "present", 40], ["2026-07-31", "Remote", 5], ["2026-07-31", "OD", 2], ["2026-08-03", "Leave", 4], ["2026-08-03", "present", 41], ["2026-08-03", "Remote", 5], ["2026-08-04", "Leave", 5], ["2026-08-04", "present", 37], ["2026-08-04", "Remote", 8], ["2026-08-05", "Leave", 4], ["2026-08-05", "present", 39], ["2026-08-05", "Remote", 5], ["2026-08-05", "OD", 2], ["2026-08-06", "Leave", 8], ["2026-08-06", "present", 40], ["2026-08-06", "Remote", 2], ["2026-08-07", "Leave", 2], ["2026-08-07", "present", 38], ["2026-08-07", "Remote", 7], ["2026-08-07", "OD", 3], ["2026-08-10", "Leave", 7], ["2026-08-10", "present", 33], ["2026-08-10", "Remote", 8], ["2026-08-10", "OD", 2], ["2026-08-11", "Leave", 6], ["2026-08-11", "present", 35], ["2026-08-11", "Remote", 6], ["2026-08-11", "OD", 3], ["2026-08-12", "Leave", 3], ["2026-08-12", "present", 37], ["2026-08-12", "Remote", 6], ["2026-08-12", "OD", 4], ["2026-08-13", "Leave", 3], ["2026-08-13", "present", 40], ["2026-08-13", "Remote", 6], ["2026-08-13", "OD", 1], ["2026-08-14", "Leave", 6], ["2026-08-14", "present", 35], ["2026-08-14", "Remote", 8], ["2026-08-14", "OD", 1], ["2026-08-17", "Leave", 4], ["2026-08-17", "present", 34], ["2026-08-17", "Remote", 9], ["2026-08-17", "OD", 3], ["2026-08-18", "Leave", 3], ["2026-08-18", "present", 38], ["2026-08-18", "Remote", 8], ["2026-08-18", "OD", 1], ["2026-08-19", "Leave", 11], ["2026-08-19", "present", 31], ["2026-08-19", "Remote", 3], ["2026-08-19", "OD", 5], ["2026-08-20", "Leave", 4], ["2026-08-20", "present", 35], ["2026-08-20", "Remote", 7], ["2026-08-20", "OD", 4], ["2026-08-21", "Leave", 6], ["2026-08-21", "present", 38], ["2026-08-21", "Remote", 3], ["2026-08-21", "OD", 3], ["2026-08-24", "Leave", 6], ["2026-08-24", "present", 32], ["2026-08-24", "Remote", 9], ["2026-08-24", "OD", 3], ["2026-08-25", "Leave", 5], ["2026-08-25", "present", 42], ["2026-08-25", "Remote", 1], ["2026-08-25", "OD", 2], ["2026-08-26", "Leave", 5], ["2026-08-26", "present", 39], ["2026-08-26", "Remote", 3], ["2026-08-26", "OD", 3], ["2026-08-27", "Leave", 4], ["2026-08-27", "present", 34], ["2026-08-27", "Remote", 9], ["2026-08-27", "OD", 3], ["2026-08-28", "Leave", 3], ["2026-08-28", "present", 36], ["2026-08-28", "Remote", 8], ["2026-08-28", "OD", 3], ["2026-08-31", "Leave", 3], ["2026-08-31", "present", 40], ["2026-08-31", "Remote", 6], ["2026-08-31", "OD", 1], ["2026-09-01", "Leave", 8], ["2026-09-01", "present", 31], ["2026-09-01", "Remote", 3], ["2026-09-01", "OD", 8], ["2026-09-02", "Leave", 8], ["2026-09-02", "present", 35], ["2026-09-02", "Remote", 7], ["2026-09-03", "Leave", 3], ["2026-09-03", "present", 37], ["2026-09-03", "Remote", 5], ["2026-09-03", "OD", 5], ["2026-09-04", "Leave", 4], ["2026-09-04", "present", 37], ["2026-09-04", "Remote", 6], ["2026-09-04", "OD", 3], ["2026-09-07", "Leave", 1], ["2026-09-07", "present", 44], ["2026-09-07", "Remote", 4], ["2026-09-07", "OD", 1], ["2026-09-08", "Leave", 7], ["2026-09-08", "present", 36], ["2026-09-08", "Remote", 5], ["2026-09-08", "OD", 2], ["2026-09-09", "Leave", 4], ["2026-09-09", "present", 39], ["2026-09-09", "Remote", 5], ["2026-09-09", "OD", 2], ["2026-09-10", "Leave", 2], ["2026-09-10", "present", 42], ["2026-09-10", "Remote", 3], ["2026-09-10", "OD", 3], ["2026-09-11", "Leave", 2], ["2026-09-11", "present", 38], ["2026-09-11", "Remote", 7], ["2026-09-11", "OD", 3], ["2026-09-14", "Leave", 7], ["2026-09-14", "present", 37], ["2026-09-14", "Remote", 3], ["2026-09-14", "OD", 3], ["2026-09-15", "Leave", 3], ["2026-09-15", "present", 40], ["2026-09-15", "Remote", 5], ["2026-09-15", "OD", 2], ["2026-09-16", "Leave", 7], ["2026-09-16", "present", 40], ["2026-09-16", "OD", 3], ["2026-09-17", "Leave", 3], ["2026-09-17", "present", 41], ["2026-09-17", "Remote", 4], ["2026-09-17", "OD", 2], ["2026-09-18", "Leave", 3], ["2026-09-18", "present", 39], ["2026-09-18", "Remote", 6], ["2026-09-18", "OD", 2], ["2026-09-21", "Leave", 3], ["2026-09-21", "present", 41], ["2026-09-21", "Remote", 4], ["2026-09-21", "OD", 2], ["2026-09-22", "Leave", 4], ["2026-09-22", "present", 36], ["2026-09-22", "Remote", 7], ["2026-09-22", "OD", 3], ["2026-09-23", "Leave", 5], ["2026-09-23", "present", 36], ["2026-09-23", "Remote", 7], ["2026-09-23", "OD", 2], ["2026-09-24", "Leave", 5], ["2026-09-24", "present", 34], ["2026-09-24", "Remote", 7], ["2026-09-24", "OD", 4], ["2026-09-25", "Leave", 3], ["2026-09-25", "present", 37], ["2026-09-25", "Remote", 9], ["2026-09-25", "OD", 1], ["2026-09-28", "Leave", 4], ["2026-09-28", "present", 39], ["2026-09-28", "Remote", 6], ["2026-09-28", "OD", 1], ["2026-09-29", "Leave", 4], ["2026-09-29", "present", 38], ["2026-09-29", "Remote", 7], ["2026-09-29", "OD", 1], ["2026-09-30", "Leave", 3], ["2026-09-30", "present", 36], ["2026-09-30", "Remote", 8], ["2026-09-30", "OD", 3], ["2026-10-01", "Leave", 4], ["2026-10-01", "present", 38], ["2026-10-01", "Remote", 5], ["2026-10-01", "OD", 3], ["2026-10-02", "Leave", 4], ["2026-10-02", "present", 39], ["2026-10-02", "Remote", 5], ["2026-10-02", "OD", 2], ["2026-10-05", "Leave", 5], ["2026-10-05", "present", 39], ["2026-10-05", "Remote", 5], ["2026-10-05", "OD", 1], ["2026-10-06", "Leave", 4], ["2026-10-06", "present", 43], ["2026-10-06", "Remote", 3], ["2026-10-07", "Leave", 6], ["2026-10-07", "present", 39], ["2026-10-07", "Remote", 5], ["2026-10-08", "Leave", 3], ["2026-10-08", "present", 38], ["2026-10-08", "Remote", 7], ["2026-10-08", "OD", 2], ["2026-10-09", "Leave", 5], ["2026-10-09", "present", 35], ["2026-10-09", "Remote", 8], ["2026-10-09", "OD", 2], ["2026-10-12", "Leave", 6], ["2026-10-12", "present", 37], ["2026-10-12", "Remote", 6], ["2026-10-12", "OD", 1], ["2026-10-13", "Leave", 5], ["2026-10-13", "present", 39], ["2026-10-13", "Remote", 4], ["2026-10-13", "OD", 2], ["2026-10-14", "Leave", 7], ["2026-10-14", "present", 34], ["2026-10-14", "Remote", 5], ["2026-10-14", "OD", 4], ["2026-10-15", "Leave", 3], ["2026-10-15", "present", 42], ["2026-10-15", "Remote", 4], ["2026-10-15", "OD", 1], ["2026-10-16", "Leave", 4], ["2026-10-16", "present", 38], ["2026-10-16", "Remote", 6], ["2026-10-16", "OD", 2], ["2026-10-19", "Leave", 6], ["2026-10-19", "present", 39], ["2026-10-19", "Remote", 4], ["2026-10-19", "OD", 1], ["2026-10-20", "Leave", 2], ["2026-10-20", "present", 38], ["2026-10-20", "Remote", 6], ["2026-10-20", "OD", 4], ["2026-10-21", "Leave", 2], ["2026-10-21", "present", 40], ["2026-10-21", "Remote", 3], ["2026-10-21", "OD", 5], ["2026-10-22", "Leave", 1], ["2026-10-22", "present", 42], ["2026-10-22", "Remote", 5], ["2026-10-22", "OD", 2], ["2026-10-23", "Leave", 4], ["2026-10-23", "present", 35], ["2026-10-23", "Remote", 10], ["2026-10-23", "OD", 1], ["2026-10-26", "Leave", 3], ["2026-10-26", "present", 38], ["2026-10-26", "Remote", 5], ["2026-10-26", "OD", 4], ["2026-10-27", "Leave", 5], ["2026-10-27", "present", 31], ["2026-10-27", "Remote", 11], ["2026-10-27", "OD", 3], ["2026-10-28", "Leave", 7], ["2026-10-28", "present", 35], ["2026-10-28", "Remote", 5], ["2026-10-28", "OD", 3], ["2026-10-29", "Leave", 2], ["2026-10-29", "present", 37], ["2026-10-29", "Remote", 9], ["2026-10-29", "OD", 2], ["2026-10-30", "Leave", 6], ["2026-10-30", "present", 36], ["2026-10-30", "Remote", 6], ["2026-10-30", "OD", 2], ["2026-11-02", "Leave", 5], ["2026-11-02", "present", 36], ["2026-11-02", "Remote", 7], ["2026-11-02", "OD", 2], ["2026-11-03", "Leave", 2], ["2026-11-03", "present", 41], ["2026-11-03", "Remote", 4], ["2026-11-03", "OD", 3], ["2026-11-04", "Leave", 3], ["2026-11-04", "present", 40], ["2026-11-04", "Remote", 2], ["2026-11-04", "OD", 5], ["2026-11-05", "Leave", 2], ["2026-11-05", "present", 42], ["2026-11-05", "Remote", 5], ["2026-11-05", "OD", 1], ["2026-11-06", "Leave", 3], ["2026-11-06", "present", 42], ["2026-11-06", "Remote", 1], ["2026-11-06", "OD", 4], ["2026-11-09", "Leave", 6], ["2026-11-09", "present", 32], ["2026-11-09", "Remote", 12], ["2026-11-10", "Leave", 2], ["2026-11-10", "present", 39], ["2026-11-10", "Remote", 8], ["2026-11-10", "OD", 1], ["2026-11-11", "Leave", 6], ["2026-11-11", "present", 32], ["2026-11-11", "Remote", 8], ["2026-11-11", "OD", 4], ["2026-11-12", "Leave", 2], ["2026-11-12", "present", 39], ["2026-11-12", "Remote", 5], ["2026-11-12", "OD", 4], ["2026-11-13", "Leave", 5], ["2026-11-13", "present", 35], ["2026-11-13", "Remote", 9], ["2026-11-13", "OD", 1], ["2026-11-16", "Leave", 6], ["2026-11-16", "present", 34], ["2026-11-16", "Remote", 7], ["2026-11-16", "OD", 3], ["2026-11-17", "Leave", 3], ["2026-11-17", "present", 39], ["2026-11-17", "Remote", 2], ["2026-11-17", "OD", 6], ["2026-11-18", "Leave", 5], ["2026-11-18", "present", 37], ["2026-11-18", "Remote", 7], ["2026-11-18", "OD", 1], ["2026-11-19", "Leave", 3], ["2026-11-19", "present", 38], ["2026-11-19", "Remote", 6], ["2026-11-19", "OD", 3], ["2026-11-20", "Leave", 4], ["2026-11-20", "present", 40], ["2026-11-20", "Remote", 4], ["2026-11-20", "OD", 2], ["2026-11-23", "Leave", 4], ["2026-11-23", "present", 34], ["2026-11-23", "Remote", 8], ["2026-11-23", "OD", 4], ["2026-11-24", "Leave", 7], ["2026-11-24", "present", 30], ["2026-11-24", "Remote", 9], ["2026-11-24", "OD", 4], ["2026-11-25", "Leave", 7], ["2026-11-25", "present", 36], ["2026-11-25", "Remote", 3], ["2026-11-25", "OD", 4], ["2026-11-26", "Leave", 5], ["2026-11-26", "present", 38], ["2026-11-26", "Remote", 4], ["2026-11-26", "OD", 3], ["2026-11-27", "Leave", 8], ["2026-11-27", "present", 30], ["2026-11-27", "Remote", 9], ["2026-11-27", "OD", 3], ["2026-11-30", "Leave", 3], ["2026-11-30", "present", 35], ["2026-11-30", "Remote", 11], ["2026-11-30", "OD", 1], ["2026-12-01", "Leave", 5], ["2026-12-01", "present", 36], ["2026-12-01", "Remote", 5], ["2026-12-01", "OD", 4], ["2026-12-02", "Leave", 8], ["2026-12-02", "present", 33], ["2026-12-02", "Remote", 6], ["2026-12-02", "OD", 3], ["2026-12-03", "Leave", 4], ["2026-12-03", "present", 37], ["2026-12-03", "Remote", 5], ["2026-12-03", "OD", 4], ["2026-12-04", "Leave", 4], ["2026-12-04", "present", 39], ["2026-12-04", "Remote", 5], ["2026-12-04", "OD", 2], ["2026-12-07", "Leave", 3], ["2026-12-07", "present", 40], ["2026-12-07", "Remote", 5], ["2026-12-07", "OD", 2], ["2026-12-08", "Leave", 6], ["2026-12-08", "present", 30], ["2026-12-08", "Remote", 10], ["2026-12-08", "OD", 4], ["2026-12-09", "Leave", 5], ["2026-12-09", "present", 38], ["2026-12-09", "Remote", 5], ["2026-12-09", "OD", 2], ["2026-12-10", "Leave", 3], ["2026-12-10", "present", 37], ["2026-12-10", "Remote", 6], ["2026-12-10", "OD", 4], ["2026-12-11", "Leave", 2], ["2026-12-11", "present", 37], ["2026-12-11", "Remote", 5], ["2026-12-11", "OD", 6], ["2026-12-14", "Leave", 6], ["2026-12-14", "present", 40], ["2026-12-14", "Remote", 3], ["2026-12-14", "OD", 1], ["2026-12-15", "Leave", 2], ["2026-12-15", "present", 38], ["2026-12-15", "Remote", 8], ["2026-12-15", "OD", 2], ["2026-12-16", "Leave", 8], ["2026-12-16", "present", 35], ["2026-12-16", "Remote", 6], ["2026-12-16", "OD", 1], ["2026-12-17", "Leave", 3], ["2026-12-17", "present", 38], ["2026-12-17", "Remote", 7], ["2026-12-17", "OD", 2], ["2026-12-18", "Leave", 5], ["2026-12-18", "present", 39], ["2026-12-18", "Remote", 5], ["2026-12-18", "OD", 1], ["2026-12-21", "Leave", 4], ["2026-12-21", "present", 34], ["2026-12-21", "Remote", 6], ["2026-12-21", "OD", 6], ["2026-12-22", "Leave", 8], ["2026-12-22", "present", 35], ["2026-12-22", "Remote", 3], ["2026-12-22", "OD", 4], ["2026-12-23", "Leave", 3], ["2026-12-23", "present", 42], ["2026-12-23", "Remote", 4], ["2026-12-23", "OD", 1], ["2026-12-24", "Leave", 3], ["2026-12-24", "present", 36], ["2026-12-24", "Remote", 7], ["2026-12-24", "OD", 4], ["2026-12-25", "Leave", 2], ["2026-12-25", "present", 38], ["2026-12-25", "Remote", 7], ["2026-12-25", "OD", 3], ["2026-12-28", "Leave", 3], ["2026-12-28", "present", 38], ["2026-12-28", "Remote", 3], ["2026-12-28", "OD", 6], ["2026-12-29", "Leave", 3], ["2026-12-29", "present", 38], ["2026-12-29", "Remote", 7], ["2026-12-29", "OD", 2], ["2026-12-30", "Leave", 1], ["2026-12-30", "present", 38], ["2026-12-30", "Remote", 6], ["2026-12-30", "OD", 5], ["2026-12-31", "Leave", 2], ["2026-12-31", "present", 42], ["2026-12-31", "Remote", 3], ["2026-12-31", "OD", 3] ]; display(Inputs.table(data.map(([Date, Type, Count]) => ({Date, Type, Count})))); 34:T85b,const manifest = { "name": "Calendar Pie v1.6 \u2014 ZohoCharts", "icon": "icon.png", "dependencies": [ "https://static.zohocdn.com/zcharts/cdn/3.7.0/d3.js", "https://static.zohocdn.com/zcharts/cdn/3.7.0/zc.min.js" ], "structure": [ [ "Date", "single", "DIMENSIONAL", "" ], [ "Category", "single", "DIMENSIONAL", "" ], [ "Value", "single", "MEASURE", "" ], [ "Filter", "single", "DIMENSIONAL", "" ] ], "settings": { "Calendar": [ { "uniqueName": "weekStart", "type": "dropdown", "label": "Week starts on", "defaultValue": "Monday", "options": [ "Monday", "Sunday" ] }, { "uniqueName": "showEmptyLabel", "type": "toggle", "label": "Show empty days", "defaultValue": false }, { "uniqueName": "dateOrder", "type": "dropdown", "label": "Date input format", "defaultValue": "DD/MM/YYYY", "options": [ "DD/MM/YYYY", "MM/DD/YYYY", "Excel serial" ] } ], "Pie": [ { "uniqueName": "innerRadius", "type": "dropdown", "label": "Donut hole", "defaultValue": "42%", "options": [ "0%", "42%", "65%" ] }, { "uniqueName": "showLabels", "type": "toggle", "label": "Slice values", "defaultValue": true }, { "uniqueName": "showTotals", "type": "toggle", "label": "Centre totals", "defaultValue": true } ], "Legend": [ { "uniqueName": "showLegend", "type": "toggle", "label": "Show legend", "defaultValue": true }, { "uniqueName": "colorMode", "type": "dropdown", "label": "Category colors", "defaultValue": "Reference", "options": [ "Reference", "Dashboard" ] } ] } }35:T5691,function createCalendarVisual() { "use strict"; /* Analytics supplies the real utility. Observable uses only this preview fallback. */ var ZAViz_Utils = window.ZAViz_Utils || { getFormattedValue: function (columnIndex, value) { return value == null ? "" : String(value); }, getSuitableStyle: function (key) { var previewStyles = {background:"#ffffff",fontColor:"#222222",legendColor:[]}; return previewStyles[key] || null; } }; /* Keep SDK globals local so Observable does not resolve them as notebook cells. */ var $ZC = window.$ZC; var d3 = window.d3; var serial = 0; function safeStr(v) { return v == null ? "" : String(v).trim(); } function gs(cs, k, d) { var v = cs && cs[k]; return v == null || v === "" ? d : v; } function tog(v, d) { if (v === true || v === "true" || v === 1) return true; if (v === false || v === "false" || v === 0) return false; return d; } function idx(c) { if (!c) return -1; var i = c.dataindex; if (i == null) i = c.dataIndex; if (i == null) i = c.colIndex; if (i == null) i = c.columnIndex; if (i == null) i = c.__metaOrder; i = Number(i); return isFinite(i) ? i : -1; } function colsByBox(md, name) { return (md.columns || []).map(function (c, i) { var cp = {}; Object.keys(c || {}).forEach(function (k) { cp[k] = c[k]; }); cp.__metaOrder = i; return cp; }).filter(function (c) { return safeStr(c.dropBoxName) === name; }).sort(function (a, b) { return idx(a) - idx(b); }); } function colByBox(md, name) { return colsByBox(md, name)[0] || null; } function resolveFields(md) { var cols=(md.columns||[]).map(function(c,i){var out={};Object.keys(c||{}).forEach(function(k){out[k]=c[k];});out.__metaOrder=i;return out;}); function time(c){return !!(c && (c.time || /^(time|date|datetime)$/i.test(safeStr(c.datatype))));} function numeric(c){return !!(c && (c.numeric || /^(numeric|number|integer|decimal|double)$/i.test(safeStr(c.datatype))));} function only(list){return list.length===1?list[0]:null;} var date=colByBox(md,"Date"),value=colByBox(md,"Value"),category=colByBox(md,"Category"),filter=colByBox(md,"Filter"); if(!date || numeric(date)) date=only(cols.filter(time)); if(!value || time(value) || (value.datatype && !numeric(value))) value=only(cols.filter(numeric)); var dimensions=cols.filter(function(c){return (!date || idx(c)!==idx(date)) && (!value || idx(c)!==idx(value)) && !time(c) && !numeric(c);}); if(!category || time(category) || numeric(category)) { category=only(dimensions.filter(function(c){return /^(type|status|category|attendance type)$/i.test(safeStr(c.parentcolumnname||c.columnname));})) || only(dimensions); } if(!filter || time(filter) || numeric(filter) || (category && idx(filter)===idx(category))) filter=only(dimensions.filter(function(c){return !category || idx(c)!==idx(category);})); return {date:date,category:category,value:value,filter:filter}; } function inputError(container,message) { var panel=el("div","calendar-input-error",null,container); panel.setAttribute("data-calendar-pie-version","1.6");panel.style.cssText="font:13px Arial,sans-serif;padding:12px;line-height:1.6"; el("strong","","Calendar Pie v1.6 — input check",panel); el("p","",message,panel); el("p","","Date: full daily date. Category: Type. Value: SUM(Count). Filter: Employee Name (optional).",panel); var details=el("details","",null,panel);el("summary","","Current input details",details); var pre=el("pre","",JSON.stringify(container.__calendarPieDiagnostics,null,2),details);pre.style.cssText="white-space:pre-wrap;max-height:240px;overflow:auto;font-size:11px"; } function rowVal(r, c) { return Array.isArray(r) ? unwrap(r[idx(c)]) : r && c ? unwrap(r[c.columnname] != null ? r[c.columnname] : r[idx(c)]) : null; } function fmtVal(c, v) { try { if (typeof ZAViz_Utils !== "undefined" && c) return String(ZAViz_Utils.getFormattedValue(idx(c) + 1, v)); } catch (e) {} return safeStr(v); } function style(k, d) { try { return ZAViz_Utils.getSuitableStyle(k) || d; } catch (e) { return d; } } function pad(n) { return (n < 10 ? "0" : "") + n; } function dayKey(d) { return d.getFullYear() + "-" + pad(d.getMonth() + 1) + "-" + pad(d.getDate()); } function calendarDate(y, m, d) { var date = new Date(Number(y), Number(m) - 1, Number(d)); return date.getFullYear() === Number(y) && date.getMonth() === Number(m) - 1 && date.getDate() === Number(d) ? date : null; } function unwrap(v) { if (v && typeof v === "object" && !(v instanceof Date)) { if (v.value != null) return v.value; if (v.rawValue != null) return v.rawValue; if (v.actualValue != null) return v.actualValue; } return v; } /* Do not interpret YEAR(Date)=2026 or MONTH(Date)=9 as epoch milliseconds. */ function parseDate(raw, order) { var v = unwrap(raw), text = safeStr(v), m, n, date; if (v instanceof Date) return isNaN(v.getTime()) ? null : calendarDate(v.getFullYear(), v.getMonth()+1, v.getDate()); m = /^(\d{4})[-\/](\d{1,2})[-\/](\d{1,2})(?:$|[T\s])/.exec(text); if (m) return calendarDate(m[1],m[2],m[3]); m = /^(\d{4})(\d{2})(\d{2})$/.exec(text); if (m) return calendarDate(m[1],m[2],m[3]); m = /^(\d{1,2})[-\/](\d{1,2})[-\/](\d{4})(?:$|\s)/.exec(text); if (m) return order === "MM/DD/YYYY" ? calendarDate(m[3],m[1],m[2]) : calendarDate(m[3],m[2],m[1]); m = /^(\d{1,2})[-\s]([a-z]{3,9})[-\s,]+(\d{4})(?:$|\s)/i.exec(text); if (m) { n = ["jan","feb","mar","apr","may","jun","jul","aug","sep","oct","nov","dec"].indexOf(m[2].slice(0,3).toLowerCase()); return n < 0 ? null : calendarDate(m[3],n+1,m[1]); } if (/^[-+]?\d+(?:\.\d+)?$/.test(text)) { n = Number(text); if (order === "Excel serial" || (n >= 20000 && n <= 100000)) { date = new Date(Date.UTC(1899,11,30) + Math.floor(n)*86400000); return calendarDate(date.getUTCFullYear(),date.getUTCMonth()+1,date.getUTCDate()); } if (n < 100000000) return null; date = new Date(n < 100000000000 ? n*1000 : n); return isNaN(date.getTime()) ? null : calendarDate(date.getFullYear(),date.getMonth()+1,date.getDate()); } return null; } function el(tag, cls, text, parent) { var n = document.createElement(tag); if (cls) n.className = cls; if (text != null) n.textContent = text; if (parent) parent.appendChild(n); return n; } function clearCharts(s) { s.charts.forEach(function (c) { try { c.destroy(); } catch (e) {} }); s.charts = []; } function dispose(s) { if (!s) return; s.disposed=true; s.renderToken=(s.renderToken||0)+1; clearTimeout(s.timer); clearCharts(s); if (s.ro) s.ro.disconnect(); if (s.resize) window.removeEventListener("resize", s.resize); } function highlightChart(chart, category, enabled) { var index=(chart.__calendarPieCategories||[]).indexOf(category); var component=chart.legend && chart.legend.component; var values=chart.seriesdata && chart.seriesdata[0] && chart.seriesdata[0].data[0]; if(index<0 || !values || !values[index] || !component || typeof component.highlightSeries!=="function") return; component.highlightSeries(null,values[index],index,chart.systemConf.legend,chart,enabled); } function keepChart(result, s, token, container, notice, categoryKeys) { function ready(chart) { if (s.disposed || s.renderToken !== token || container.__calendarPieState !== s) { try { if(chart && chart.destroy) chart.destroy(); } catch(e) {} return; } s.pending=Math.max(0,s.pending-1); if(chart) {chart.__calendarPieCategories=categoryKeys.slice();s.charts.push(chart);if(s.hoverCategory) highlightChart(chart,s.hoverCategory,true);} } function failed(error) { if (s.disposed || s.renderToken !== token) return; s.pending=Math.max(0,s.pending-1); notice.textContent="ZohoCharts render error: "+String(error && error.message || error); } if(result && typeof result.then === "function") { s.pending++;result.then(ready,failed); } else ready(result); } function makeConfig(values, colors, fg, settings, diameter) { return { canvas: {background:{color:"transparent",alpha:0},border:{show:false},shadow:{show:false}, title:{show:false}, subtitle:{show:false}, fontColor:fg, fontSize:11}, legend: {enabled:false, colors:colors}, tooltip: {maxWidth:320}, metadata: {axes:{x:[0], y:[[1]], tooltip:[0,1]}, columns:[{dataindex:0,columnname:"Category",datatype:"ordinal"},{dataindex:1,columnname:"Value",datatype:"numeric"}]}, seriesdata: {chartdata:[{type:"pie",data:[values]}]}, chart: {plot:{plotoptions:{pie:{animation:{enabled:false},innerRadius:gs(settings,"innerRadius","42%"), outerPadding:3, maxRadius:diameter/2, sliceOutHeight:0, strokeWidth:1, datalabels:{show:false,innerLabel:{show:tog(gs(settings,"showLabels",true),true),showAs:"y",fontSize:11,fontWeight:"bold",textOverlap:"hidden"}}}}}} }; } function generateCustomVisual(container, data, metaData) { var previous = container.__calendarPieState, remembered = previous && {month:previous.month,filter:previous.filter,hidden:previous.hidden}; dispose(previous); container.innerHTML = ""; metaData = metaData || {}; var fields=resolveFields(metaData),dateCol=fields.date,catCol=fields.category,valCol=fields.value,filterCol=fields.filter,settings=metaData.customSettings||{}; container.__calendarPieDiagnostics={version:"1.6",columns:metaData.columns||[],sampleRows:Array.isArray(data)?data.slice(0,3):data,resolvedFields:{date:dateCol&&dateCol.columnname,category:catCol&&catCol.columnname,value:valCol&&valCol.columnname,filter:filterCol&&filterCol.columnname}}; if(!dateCol || !catCol || !valCol) { inputError(container,"Could not identify a date field, category and numeric value from the supplied fields. Check the drop areas below.");return; } var dateGrouping=safeStr(dateCol.time && dateCol.time.subfunction || dateCol.operation).toUpperCase(); if(/^(YEAR|MONTH|QUARTER)$/.test(dateGrouping)) { inputError(container,"Analytics is sending "+dateGrouping+"-grouped dates ("+safeStr(dateCol.columnname)+"). These rows contain period totals, not daily attendance. Open the Date field menu in the chart builder and select a full daily date; then refresh this report.");return; } var s = {charts:[], month:remembered && remembered.month, filter:remembered && remembered.filter || "", hidden:remembered && remembered.hidden || Object.create(null), id:++serial}; container.__calendarPieState=s; var rows = [], months = Object.create(null), cats = Object.create(null), filters = Object.create(null), skipped = 0; (Array.isArray(data) ? data : []).forEach(function (r) { var rawDate = rowVal(r,dateCol), d = parseDate(rawDate, gs(settings,"dateOrder","DD/MM/YYYY")), rawValue = rowVal(r,valCol), value = Number(rawValue), cat = rowVal(r,catCol), f = filterCol ? rowVal(r,filterCol) : null; if (!d || rawValue == null || safeStr(rawValue) === "" || !isFinite(value) || value < 0 || cat == null || safeStr(cat) === "") { skipped++; return; } var key=dayKey(d), name=safeStr(cat), fk=filterCol ? JSON.stringify([typeof f,f]) : ""; rows.push({key:key,month:key.slice(0,7),cat:name,value:value,rawCategory:cat,rawDate:rawDate,filterKey:fk}); months[key.slice(0,7)] = true; cats[name] = cat; if(filterCol) filters[fk]=f; }); var monthKeys=Object.keys(months).sort(), categories=Object.keys(cats).sort(function(a,b){var rank={leave:0,present:1,remote:2,od:3,training:3};var aa=rank[a.toLowerCase()],bb=rank[b.toLowerCase()];return (aa==null?99:aa)-(bb==null?99:bb)||a.localeCompare(b);}), fg=style("fontColor","#222222"), bg=style("background","#ffffff"), palette=style("legendColor",[]), colors=Object.create(null); var reference={leave:"#5e6de2",present:"#b4d723",remote:"#62617e",training:"#f2a51b",od:"#f2a51b"}, fallbacks=["#5e6de2","#b4d723","#62617e","#f2a51b","#36a9ae","#dc6b8b"]; categories.forEach(function(c,i) { colors[c] = gs(settings,"colorMode","Reference") === "Dashboard" && Array.isArray(palette) && palette.length ? palette[i%palette.length] : reference[c.toLowerCase()] || fallbacks[i%fallbacks.length]; }); if (!monthKeys.length) { inputError(container,"No valid daily dates and numeric values were found in the supplied rows. Expand Current input details to see the fields and first rows received by this visual."); return; } if (monthKeys.indexOf(s.month)<0) s.month=monthKeys[monthKeys.length-1]; if(filterCol && !Object.prototype.hasOwnProperty.call(filters,s.filter)) s.filter=""; var root=el("div","zcp",null,container); root.setAttribute("data-calendar-pie-version","1.6");root.style.color=fg; var css=el("style","",null,root); css.textContent=".zcp{font:12px Arial,sans-serif;height:100%;display:flex;flex-direction:column;box-sizing:border-box}.zcp *{box-sizing:border-box}.zcp .toolbar{display:flex;align-items:center;gap:10px;min-height:34px;padding:2px 7px;flex-wrap:wrap}.zcp label{display:flex;align-items:center;gap:5px;font-weight:bold}.zcp select{font:inherit;color:inherit;border:1px solid #dfe1e4;border-radius:5px;height:25px;min-width:140px;padding:2px 7px;cursor:pointer}.zcp .reset{font:inherit;color:inherit;background:transparent;border:0;padding:2px 5px;cursor:pointer}.zcp .legend{margin-left:auto;display:flex;gap:8px;align-items:center}.zcp .legend li.zc-legend-series{cursor:pointer;white-space:nowrap}.zcp .legend li.zc-legend-series[aria-pressed=false]{opacity:.35;text-decoration:line-through}.zcp .legend ul{padding:0!important;margin:0!important}.zcp .viewport{flex:1;min-height:0;overflow:auto;padding:0 1px}.zcp .calendar{min-width:700px;display:grid;grid-template-columns:repeat(7,minmax(0,1fr));grid-template-rows:24px;}.zcp .weekday{text-align:center;font-size:11px;position:relative;display:flex;align-items:center;justify-content:center}.zcp .monthtitle{height:24px;min-width:700px;display:flex;align-items:center;font-size:12px;font-weight:bold;white-space:nowrap}.zcp .day{border:1px solid var(--border);border-right:0;border-bottom:0;position:relative;background:var(--cell);overflow:hidden}.zcp .day:nth-child(7n){border-right:1px solid var(--border)}.zcp .day:nth-last-child(-n+7){border-bottom:1px solid var(--border)}.zcp .day.blank{background:transparent}.zcp .date{position:absolute;top:4px;left:4px;font-size:10px}.zcp .donut{position:absolute;left:50%;top:50%;transform:translate(-50%,-50%);width:136px;height:136px;overflow:hidden}.zcp .chart{position:absolute;inset:0;background:transparent}.zcp .total{position:absolute;inset:0;display:flex;align-items:center;justify-content:center;pointer-events:none;font-weight:bold;font-size:9px}.zcp .empty{display:flex;height:100%;align-items:center;justify-content:center;opacity:.5}.zcp .notice:empty{display:none}.zcp .notice{padding:4px;font-size:11px}.zcp .sdkerror{padding:12px;border:1px solid #f2a51b}"; root.style.setProperty("--border", "#e8eaed"); root.style.setProperty("--cell", "#f8f9fb"); var toolbar=el("div","toolbar",null,root), label=el("label","","Month ",toolbar), monthSelect=el("select","",null,label); monthSelect.setAttribute("aria-label","Month"); monthSelect.style.background=bg; function monthLabel(key) { return new Date(Number(key.slice(0,4)),Number(key.slice(5,7))-1,1).toLocaleDateString("en",{month:"long",year:"numeric"}); } monthKeys.forEach(function (k) { var o=el("option","",monthLabel(k),monthSelect); o.value=k; }); monthSelect.value=s.month; if(filterCol) { var fl=el("label","",safeStr(filterCol.columnname)+" ",toolbar), fs=el("select","",null,fl); fs.setAttribute("aria-label","Filter"); fs.style.background=bg; var all=el("option","","All",fs); all.value=""; Object.keys(filters).sort(function(a,b){return safeStr(filters[a]).localeCompare(safeStr(filters[b]));}).forEach(function(k){var o=el("option","",fmtVal(filterCol,filters[k]),fs); o.value=k;}); fs.value=s.filter; fs.onchange=function(){s.filter=fs.value;draw();}; } var reset=el("button","reset","Reset",toolbar); reset.type="button"; reset.style.display="none"; var legend=el("div","legend",null,toolbar), viewport=el("div","viewport",null,root), title=el("div","monthtitle",null,viewport), grid=el("div","calendar",null,viewport), notice=el("div","notice","",root); var sdk=typeof $ZC!=="undefined" ? $ZC : null; if(!sdk || typeof sdk.charts!=="function") { el("div","sdkerror","ZohoCharts is not loaded. Add the approved ZohoCharts CDN URL to ZAViz_Manifest.json dependencies, then re-import the visual.",root); return; } function hoverCategory(category) { if(s.hoverCategory===category) return; var previous=s.hoverCategory; s.hoverCategory=category; s.charts.forEach(function(chart){ if(previous) highlightChart(chart,previous,false); if(category && !s.hidden[category]) highlightChart(chart,category,true); }); } function drawLegend() { legend.innerHTML=""; if(!tog(gs(settings,"showLegend",true),true)) return; try { var width=categories.reduce(function(sum,c){return sum+Math.max(70,safeStr(cats[c]).length*8+28);},0); legend.style.width=width+"px";legend.style.height="24px"; var Component=sdk.getComponent("listLegend"); var component=new Component({ data:categories.map(function(c){return safeStr(cats[c]);}), bound:{maxWidth:width,maxHeight:24}, config:{title:{show:false},border:{show:false},layout:"horizontal",itemMargin:3,textPadding:5,marginLeft:0,marginRight:0, list:{marker:{fillColor:function(value,index){return colors[categories[index]];},strokeWidth:0},label:{fontSize:12,fontColor:fg,padding:5}}}, globalFont:{fontColor:fg,fontFamily:"Arial",fontSize:12} }); component.create();component.draw(d3.select(legend));s.legendComponent=component; d3.select(legend).selectAll("li.zc-legend-series").each(function(value,index){ var c=categories[index],item=this; item.setAttribute("role","button");item.setAttribute("tabindex","0"); item.setAttribute("aria-label",safeStr(cats[c]));item.setAttribute("aria-pressed",s.hidden[c]?"false":"true"); item.onmouseenter=function(){if(!s.hidden[c]) hoverCategory(c);}; item.onmouseleave=function(){hoverCategory(null);}; item.onfocus=item.onmouseenter;item.onblur=item.onmouseleave; item.onclick=function(){s.hidden[c]=!s.hidden[c];draw();}; item.onkeydown=function(event){if(event.key==="Enter" || event.key===" "){event.preventDefault();item.onclick();}}; }); } catch(e) { legend.textContent="Legend error";legend.title=String(e && e.message || e);s.legendError=legend.title; } } function draw() { s.renderToken=(s.renderToken||0)+1; s.pending=0; s.hoverCategory=null; clearCharts(s); grid.innerHTML=""; s.legendError=""; drawLegend(); reset.style.display=(s.filter || Object.keys(s.hidden).some(function(c){return s.hidden[c];}))?"":"none"; var grouped=Object.create(null), active=categories.filter(function(c){return !s.hidden[c];}), year=Number(s.month.slice(0,4)), month=Number(s.month.slice(5,7))-1, monday=gs(settings,"weekStart","Monday")==="Monday", offset=(new Date(year,month,1).getDay()+(monday?6:0))%7, days=new Date(year,month+1,0).getDate(), count=Math.ceil((offset+days)/7)*7; rows.forEach(function(r) { if(r.month!==s.month || (s.filter && r.filterKey!==s.filter) || s.hidden[r.cat]) return; if(!grouped[r.key]) grouped[r.key]=Object.create(null); grouped[r.key][r.cat]=(grouped[r.key][r.cat]||0)+r.value; }); title.textContent=monthLabel(s.month); (monday?["Mon","Tue","Wed","Thu","Fri","Sat","Sun"]:["Sun","Mon","Tue","Wed","Thu","Fri","Sat"]).forEach(function(w){el("div","weekday",w,grid);}); var cellHeight=Math.max(100,Math.floor(((viewport.clientHeight||700)-48)/(count/7))), failed=0; for(var i=0;i=1 && day<=days, cell=el("div","day"+(valid?"":" blank"),null,grid);cell.style.height=cellHeight+"px";if(!valid) continue; el("span","date",day,cell);var key=dayKey(new Date(year,month,day)), dayValues=grouped[key]||Object.create(null), values=active.map(function(c){return [c,dayValues[c]||0];}), total=values.reduce(function(a,v){return a+v[1];},0); cell.setAttribute("aria-label",key+", total "+fmtVal(valCol,total)); if(total===0) { if(tog(gs(settings,"showEmptyLabel",false),false)) el("div","empty","No data",cell);continue; } var wrap=el("div","donut",null,cell), host=el("div","chart",null,wrap); var diameter=Math.max(66,Math.min(cellHeight-12,cell.clientWidth-12));wrap.style.width=diameter+"px";wrap.style.height=diameter+"px"; try { var chart=sdk.charts(host,makeConfig(values,active.map(function(c){return colors[c];}),fg,settings,diameter));keepChart(chart,s,s.renderToken,container,notice,active); } catch(e) { failed++;el("div","empty","Chart unavailable",wrap); } if(tog(gs(settings,"showTotals",true),true)) el("div","total",fmtVal(valCol,total),wrap); } notice.textContent=(skipped?skipped+" rows excluded: check Date uses full daily dates and Value is numeric. ":"")+(s.legendError?"ZohoCharts legend error: "+s.legendError+". ":"")+(failed?failed+" daily charts failed; check the SDK build. ":"")+(active.length===0?"All categories are hidden. Click a legend item or Reset.":""); } monthSelect.onchange=function(){s.month=monthSelect.value;draw();}; reset.onclick=function(){s.filter="";s.hidden=Object.create(null);if(filterCol) fs.value="";draw();}; draw();var lastWidth=container.clientWidth,lastHeight=container.clientHeight; s.resize=function(){var w=container.clientWidth,h=container.clientHeight;if(w===lastWidth && h===lastHeight) return;lastWidth=w;lastHeight=h;clearTimeout(s.timer);s.timer=setTimeout(draw,120);}; if(typeof ResizeObserver!=="undefined") {s.ro=new ResizeObserver(s.resize);s.ro.observe(container);} else window.addEventListener("resize",s.resize); } return {render:generateCustomVisual, dispose:dispose}; } 36:[] 30:{"id":"9ea82bb18ce8039b","slug":"calendar-pie-visual-zohocharts","title":"Calendar Pie Visual - Zohocharts","thumbnail":"3d367a03e96ca5667c3ac7416546135201c6b299bc4d5485414e85038393cc1d","access_level":"public","create_time":"$D2026-10-08T11:47:04.004Z","update_time":"$D2026-10-09T09:52:46.454Z","view_time":null,"first_public_time":"$D2026-10-09T10:16:35.281Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"d35f3a197cca459d","login":"aarthis","name":"AarthiS","avatar_url":"https://avatars-next.observableusercontent.com/3956bd194b7bd4896349863e3f564e1f0a7ded67897da804060947df0cc2d00f","tier":"starter_2024","bio":""},"version":41,"publish_version":41,"role":null,"authored":false,"authors":[{"type":"individual","id":"8632663b754cfa42","login":"aarthi-s-1238","name":"Aarthi-s-1238","avatar_url":"https://avatars-next.observableusercontent.com/3cd617519ef493ade5eb1079d7fbc37ebdd39c91edfc6af9909f7bd89be85bd0","tier":null,"bio":""}],"members":[{"type":"team","id":"d35f3a197cca459d","login":"aarthis","name":"AarthiS","avatar_url":"https://avatars-next.observableusercontent.com/3956bd194b7bd4896349863e3f564e1f0a7ded67897da804060947df0cc2d00f","tier":"starter_2024","role":"editor"}],"comments":[],"custom_thumbnail":true,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Calendar Pie Visual - Zohocharts","cells":[{"id":1,"value":"# Calendar Pie Visual - Zohocharts\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":8,"value":"$32","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5,"value":"$33","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":10,"value":"const metadata = {\n \"columns\": [\n {\n \"dropBoxName\": \"Date\",\n \"columnname\": \"Date\",\n \"datatype\": \"time\",\n \"operation\": \"DATE\",\n \"time\": {\n \"subfunction\": \"DATE\",\n \"inputformat\": \"yyyy-MM-dd\"\n },\n \"dataindex\": 0\n },\n {\n \"dropBoxName\": \"Category\",\n \"columnname\": \"Type\",\n \"datatype\": \"ordinal\",\n \"dataindex\": 1,\n \"operation\": \"GROUPBY\"\n },\n {\n \"dropBoxName\": \"Value\",\n \"columnname\": \"Count\",\n \"datatype\": \"numeric\",\n \"dataindex\": 2,\n \"operation\": \"SUM\"\n }\n ],\n \"customSettings\": {}\n}\n","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":9,"value":"$34","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":6,"value":"$35","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W36","stdlib":"2"}} 31:"$30:body"