41:null 42:["$","title",null,{"children":"Doctor 360 | Abhishek Nilewad | Observable"}] 48:Tbbf,barChartSmall = function (dataMap) { const width = 280, height = 180, margin = { top: 6, right: 6, bottom: 6, left: 6 }; const svg = d3.create("svg").attr("viewBox", `0 0 ${width} ${height}`); // 1. Array map sorting rule for Map Entries [key, value] const entries = Array.from(dataMap.entries()).sort((a, b) => b[1] - a[1]); // 2. Pass the safely sorted entries directly into your custom color scale const color = blueScale(entries); // 3. Construct hierarchical structure const rootData = { name: "root", children: entries.map(([key, value]) => ({ name: key, value: value })) }; const root = d3 .hierarchy(rootData) .sum((d) => d.value) .sort((a, b) => b.value - a.value); // 4. Compute layout boxes d3 .treemap() .size([ width - margin.left - margin.right, height - margin.top - margin.bottom ]) .padding(2)(root); // Create a unique ID prefix for our clipping paths to avoid document collisions const clipIdPrefix = "clip-" + Math.floor(Math.random() * 10000) + "-"; const g = svg .append("g") .attr("transform", `translate(${margin.left},${margin.top})`); // 5. Build group canvas containers const cell = g .selectAll("g") .data(root.leaves()) .join("g") .attr("transform", (d) => `translate(${d.x0},${d.y0})`); // 6. FIX: Create invisible clipping masks matching the exact width/height of each rectangle cell .append("clipPath") .attr("id", (d, i) => clipIdPrefix + i) .append("rect") .attr("width", (d) => d.x1 - d.x0 - 4) // 4px padding safety zone .attr("height", (d) => d.y1 - d.y0 - 2); // 7. Draw the visible color block rectangles cell .append("rect") .attr("width", (d) => d.x1 - d.x0) .attr("height", (d) => d.y1 - d.y0) .attr("fill", (d, i) => { const targetIndex = Math.min(i, 2); // Prevents colors from over-fading return color(entries[targetIndex][1]); // Targets the numerical data value explicitly }) .attr("rx", 3); // 8. FIX: Assign the clipping path directly to the text group so it never cuts into neighboring blocks const textGroup = cell .append("text") .attr("clip-path", (d, i) => `url(#${clipIdPrefix + i})`) .attr("x", 5) .attr("y", 14) .attr("font-size", 9) .attr("font-weight", "bold") .attr("fill", "#FFFFFF") .style("pointer-events", "none"); // First Line text layer (City Name) textGroup.append("tspan").text((d) => d.data.name); // Second Line text layer (Value Counter) textGroup .append("tspan") .attr("x", 5) .attr("dy", "11px") .attr("font-weight", "normal") .attr("fill", "rgba(255, 255, 255, 0.85)") .text((d) => { const blockHeight = d.y1 - d.y0; // Safety threshold: If the block is shorter than 26px (like Erbil), // hide the second line count so text never overflows past the rectangle base return blockHeight > 26 ? `(${d.data.value})` : ""; }); return svg.node(); }49:T9b4,donutSmall = function (dataMap, centerLabel) { const width = 280, height = 180, r = 60; const svg = d3.create("svg").attr("viewBox", `0 0 ${width} ${height}`); // Sort entries descending by numerical value const entries = Array.from(dataMap.entries()).sort((a, b) => b[1] - a[1]); const total = d3.sum(entries, (d) => d[1]); const color = blueScale(entries); const pie = d3 .pie() .value((d) => d[1]) .sort(null)(entries); const arc = d3 .arc() .innerRadius(r * 0.55) .outerRadius(r); const g = svg .append("g") .attr("transform", `translate(${r + 15},${height / 2})`); // Color controller: Provides step distinction but keeps it well above invisible white const getDistinctColor = (i, dValue) => { // If it's a binary chart (like Gender Ratio), give the second item a visible light-blue step if (entries.length === 2 && i === 1) { return "#93C5FD"; // A highly visible, crisp light blue shade } // For general charts, let items 1-3 behave normally if (i < 3) { return color(dValue); } // For the 4th item and beyond, create a controlled lighter shade step instead of going white return "#BFDBFE"; // Soft, clearly visible pastel blue that contrasts with white backgrounds }; g.selectAll("path") .data(pie) .join("path") .attr("d", arc) .attr("fill", (d, i) => getDistinctColor(i, d.data[1])) .attr("stroke", "#fff") .attr("stroke-width", 2); g.append("text") .attr("text-anchor", "middle") .attr("dy", "-0.1em") .attr("font-family", "serif") .attr("font-size", "18px") .attr("font-weight", "700") .text(total); g.append("text") .attr("text-anchor", "middle") .attr("dy", "1.3em") .attr("font-size", "8px") .attr("fill", "#8B93A6") .text(centerLabel); const legend = svg .append("g") .attr( "transform", `translate(${r * 2 + 35},${height / 2 - (entries.length * 20) / 2 + 5})` ); entries.forEach((d, i) => { const pct = Math.round((d[1] / total) * 100); const row = legend.append("g").attr("transform", `translate(0,${i * 20})`); row .append("rect") .attr("width", 10) .attr("height", 10) .attr("rx", 2) .attr("fill", getDistinctColor(i, d[1])); row .append("text") .attr("x", 15) .attr("y", 9) .attr("font-size", 11) .text(`${d[0]}: ${pct}% (${d[1]})`); }); return svg.node(); }4a:T7a5,divisionChartClickable = { const divCounts = d3.rollup( doctors, (v) => v.length, (d) => d.Division ); const width = 280, height = 180, margin = { top: 6, right: 30, bottom: 6, left: 70 }; const svg = d3.create("svg").attr("viewBox", `0 0 ${width} ${height}`); const entries = Array.from(divCounts.entries()).sort((a, b) => b[1] - a[1]); const color = blueScale(entries); const y = d3 .scaleBand() .domain(entries.map((d) => d[0])) .range([margin.top, height - margin.bottom]) .padding(0.3); const x = d3 .scaleLinear() .domain([0, d3.max(entries, (d) => d[1])]) .range([0, width - margin.left - margin.right]); const g = svg.append("g").attr("transform", `translate(${margin.left},0)`); g.selectAll("rect") .data(entries) .join("rect") .attr("y", (d) => y(d[0])) .attr("height", y.bandwidth()) .attr("x", 0) .attr("width", (d) => x(d[1])) // FIX: Base color on index position (0 to 3) so everything past the 4th item retains high visibility .attr("fill", (d, i) => { const targetIndex = Math.min(i, 3); return color(entries[targetIndex][1]); }) .attr("opacity", (d) => !selectedDivisionForFilter || selectedDivisionForFilter === d[0] ? 1 : 0.35 ) .attr("rx", 3) .style("cursor", "pointer") .on("click", (event, d) => { mutable selectedDivisionForFilter = selectedDivisionForFilter === d[0] ? null : d[0]; }); g.selectAll("text.l") .data(entries) .join("text") .attr("x", -8) .attr("y", (d) => y(d[0]) + y.bandwidth() / 2 + 4) .attr("text-anchor", "end") .attr("font-size", 11) .text((d) => d[0]); g.selectAll("text.v") .data(entries) .join("text") .attr("x", (d) => x(d[1]) + 6) .attr("y", (d) => y(d[0]) + y.bandwidth() / 2 + 4) .attr("font-size", 10) .attr("fill", "#55627A") .text((d) => d[1]); return svg.node(); }4b:Taaf,specialityDonut = { const byLegacyFiltered = new Map(); filteredDoctors.forEach((d) => { if (!byLegacyFiltered.has(d["Legacy Code"])) byLegacyFiltered.set(d["Legacy Code"], d); }); const peopleFirst = Array.from(byLegacyFiltered.values()); const counts = d3.rollup( peopleFirst, (v) => v.length, (d) => d.Speciality ); // Sort entries descending by value so largest slices map cleanly to top colors const entries = Array.from(counts.entries()).sort((a, b) => b[1] - a[1]); const total = d3.sum(entries, (d) => d[1]); const color = blueScale(entries); const width = 300, height = 180, r = 60; const svg = d3.create("svg").attr("viewBox", `0 0 ${width} ${height}`); const pie = d3 .pie() .value((d) => d[1]) .sort(null)(entries); const arc = d3 .arc() .innerRadius(r * 0.55) .outerRadius(r); const g = svg .append("g") .attr("transform", `translate(${r + 15},${height / 2})`); // Explicit label-based color filter for Specialities & Classes const getClassColor = (label, value) => { if (label === "C" || label === "Class C" || label === "c") { return "#A2D2FF"; // Clear, beautiful, slightly fainter blue shade for Class C } return color(value); // Uses standard blueScale for A, B, and all others }; g.selectAll("path") .data(pie) .join("path") .attr("d", arc) .attr("fill", (d) => getClassColor(d.data[0], d.data[1])) .attr("stroke", "#fff") .attr("stroke-width", 2); g.append("text") .attr("text-anchor", "middle") .attr("dy", "-0.1em") .attr("font-family", "serif") .attr("font-size", "18px") .attr("font-weight", "700") .text(total); g.append("text") .attr("text-anchor", "middle") .attr("dy", "1.3em") .attr("font-size", "8px") .attr("fill", "#8B93A6") .text("DOCTORS"); const legend = svg .append("g") .attr( "transform", `translate(${r * 2 + 36},${height / 2 - (entries.length * 20) / 2 + 5})` ); entries.forEach((d, i) => { const pct = Math.round((d[1] / total) * 100); const row = legend.append("g").attr("transform", `translate(0,${i * 20})`); row .append("rect") .attr("width", 10) .attr("height", 10) .attr("rx", 2) .attr("fill", getClassColor(d[0], d[1])); // Synchronizes legend swatch color row .append("text") .attr("x", 15) .attr("y", 9) .attr("font-size", 11) .text(`${d[0]}: ${pct}% (${d[1]})`); // Appends the raw number count next to percentage }); return chartCard( "Speciality Mix (unique doctors)" + (selectedDivisionForFilter ? " — " + selectedDivisionForFilter : ""), svg.node() ); }4c:T67e,overallDoctorDataTab = { const filteredByLegacyCode = new Map(); filteredDoctors.forEach((d) => { if (!filteredByLegacyCode.has(d["Legacy Code"])) filteredByLegacyCode.set(d["Legacy Code"], []); filteredByLegacyCode.get(d["Legacy Code"]).push(d); }); const peopleFirstRows = Array.from(filteredByLegacyCode.values()).map( (rows) => rows[0] ); const cityByPerson = d3.rollup( peopleFirstRows, (v) => v.length, (d) => d.City ); const genderByPerson = d3.rollup( peopleFirstRows, (v) => v.length, (d) => d.Gender ); const classCounts = d3.rollup( filteredDoctors, (v) => v.length, (d) => d.Class ); return html`

${summaryStrip} ${ selectedDivisionForFilter ? html`

Filtered: ${selectedDivisionForFilter} — click the bar again to clear

` : "" }

${chartCard( "Doctors by City (unique)", barChartSmall(cityByPerson, () => "#146C64") )} ${chartCard( "Division (by engagement) — click to filter", divisionChartClickable )} ${chartCard( "Class Composition (by engagement)", donutSmall(classCounts, "ENGAGEMENTS") )}

${chartCard( "Gender Ratio (unique doctors)", donutSmall(genderByPerson, "DOCTORS") )} ${specialityDonut} ${crmCountCard}

`; }4d:Ta85,avgVisitsChart = function (legacyCode) { const rows = byLegacyCode.get(legacyCode) || []; const monthData = { 4: [], 5: [], 6: [] }; rows.forEach((r) => { (visitsByPcode.get(r.Pcode) || []).forEach((v) => { const m = new Date(v.month).getMonth(); if (monthData[m]) { monthData[m].push(v.visits); } }); }); const points = [4, 5, 6].map((m) => ({ month: ["May", "Jun", "Jul"][m - 4], avg: monthData[m].length ? Math.round(d3.mean(monthData[m])) : 0 })); // Larger canvas to prevent chart clipping const width = 520; const height = 190; const margin = { top: 35, right: 40, bottom: 40, left: 40 }; const x = d3 .scalePoint() .domain(points.map((p) => p.month)) .range([margin.left, width - margin.right]); const maxValue = d3.max(points, (p) => p.avg) || 1; const y = d3 .scaleLinear() .domain([0, maxValue * 1.2]) .nice() .range([height - margin.bottom, margin.top]); const line = d3 .line() .x((p) => x(p.month)) .y((p) => y(p.avg)); const svg = d3 .create("svg") .attr("viewBox", `0 0 ${width} ${height}`) .attr("width", "100%") .attr("height", "auto") .style("display", "block"); // Line svg .append("path") .datum(points) .attr("d", line) .attr("fill", "none") .attr("stroke", "#1D5B8F") .attr("stroke-width", 2.5); // Points svg .selectAll("circle") .data(points) .join("circle") .attr("cx", (p) => x(p.month)) .attr("cy", (p) => y(p.avg)) .attr("r", 5) .attr("fill", "#1D5B8F"); // Rounded values svg .selectAll("text.value") .data(points) .join("text") .attr("x", (p) => x(p.month)) .attr("y", (p) => y(p.avg) - 14) .attr("text-anchor", "middle") .attr("font-size", 14) .attr("fill", "#101827") .attr("font-weight", "600") .text((p) => p.avg); // Month labels svg .selectAll("text.month") .data(points) .join("text") .attr("x", (p) => x(p.month)) .attr("y", height - 12) .attr("text-anchor", "middle") .attr("font-size", 13) .attr("fill", "#8B93A6") .text((p) => p.month); return html`

Average Visits (Across Engagements)

${svg.node()}

`; }4e:T925,investedKpi = function (legacyCode) { const records = data2.filter( (d) => d["Legacy code"] === legacyCode ); const isCrm = records.length > 0; const total = d3.sum( records, (d) => parseFloat(String(d.Spent).replace(/[^0-9.]/g, "")) || 0 ); // Group investment by month const monthlyInvestment = d3.rollups( records, (values) => d3.sum( values, (d) => parseFloat(String(d.Spent).replace(/[^0-9.]/g, "")) || 0 ), (d) => { const date = new Date(d["Month of Activity"]); return date.toLocaleString("en-US", { month: "short", year: "numeric" }); } ); return html`

Total Invested ${ !isCrm ? html` (Not a CRM doctor) ` : "" }

${isCrm ? "$" + total.toLocaleString() : "—"}

${ isCrm ? html`

${monthlyInvestment.map( ([month, amount]) => html`

${month} — $${amount.toLocaleString()}

` )}

` : "" }

`; } 4f:T411,dashboard = { const header = html`

Doctor 360

AJANTA PHARMA — WEST ASIA

${tabBar}

`; let content; if (activeTab === "Overall Doctor Data") content = overallDoctorDataTab; else if (activeTab === "Doctor Profile") content = profileTabWrapper; else if (activeTab === "MR Overview") content = mrOverviewTab; return html`

${header}

${content}

`; }50:Tbf4,mrByDivisionChart = function (legacyCode) { const rows = byLegacyCode.get(legacyCode); const width = 520; const height = 250; const r = 82; const svg = d3 .create("svg") .attr("viewBox", `0 0 ${width} ${height}`) .attr("width", "100%") .attr("height", "auto"); const entries = rows.map((row) => { const visitData = visitsByPcode.get(row.Pcode) || []; const totalVisits = visitData.reduce((sum, m) => sum + (m.visits || 0), 0); return { rep: row.Repname || "Unassigned", division: row.Division, visits: totalVisits }; }); const grandTotal = d3.sum(entries, (e) => e.visits) || 1; const visitValues = entries.map((e) => e.visits); const minV = d3.min(visitValues); const maxV = d3.max(visitValues); const color = minV === maxV ? () => 0.6 : d3.scaleLinear().domain([minV, maxV]).range([0.3, 1]); const shade = (v) => d3.interpolateBlues(color(v)); // Donut const pie = d3 .pie() .value((d) => d.visits) .sort(null)(entries); const arc = d3 .arc() .innerRadius(r * 0.55) .outerRadius(r); // Donut positioned on the left const g = svg.append("g").attr("transform", `translate(135,${height / 2})`); g.selectAll("path") .data(pie) .join("path") .attr("d", arc) .attr("fill", (d) => shade(d.data.visits)) .attr("stroke", "#fff") .attr("stroke-width", 2); // Centre number g.append("text") .attr("text-anchor", "middle") .attr("dy", "-0.1em") .attr("font-family", "serif") .attr("font-size", "22px") .attr("font-weight", "700") .attr("fill", "#101827") .text(entries.length); g.append("text") .attr("text-anchor", "middle") .attr("dy", "1.3em") .attr("font-size", "9px") .attr("fill", "#8B93A6") .text("MRS"); // Legend const legend = svg.append("g").attr("transform", `translate(270,${48})`); entries.forEach((e, i) => { const pct = Math.round((e.visits / grandTotal) * 100); const row = legend.append("g").attr("transform", `translate(0,${i * 30})`); row .append("rect") .attr("width", 11) .attr("height", 11) .attr("rx", 2) .attr("fill", shade(e.visits)); row .append("text") .attr("x", 17) .attr("y", 9) .attr("font-size", 10) .attr("fill", "#101827") .text(`${e.rep} (${e.division})`); row .append("text") .attr("x", 17) .attr("y", 22) .attr("font-size", 9) .attr("fill", "#55627A") .text(`${pct}% • ${e.visits} visits`); }); return html`

Visit Share by MR

${svg.node()}

`; }51:T117a,profileTabWrapper = { // 1. Structural View Scaffolding & Initial Containers const wrap = html`

`; const input = html``; // Dynamic content slots const avgVisitsContainer = html`

`; const investedContainer = html`

`; // Right column: holds Line chart and KPI stacked vertically const rightColumn = html`

`; // CRITICAL FIX: The Master Row wrapper that strictly forces a 50/50 side-by-side grid split with no gap const masterChartsFlexRow = html`

`; // 2. Empty State Dynamic Orchestrator const showEmptyState = () => { profileContainer.innerHTML = `

🔍

No Doctor Selected

Please enter a Doctor's Name, Pcode, or Legacy Code to view profile engagements.

`; mrChartContainer.innerHTML = ""; avgVisitsContainer.innerHTML = ""; investedContainer.innerHTML = ""; }; // 3. User Input Search Evaluation Engine input.addEventListener("input", (e) => { mutable globalSearchValue; const q = e.target.value.trim().toLowerCase(); if (!q) { showEmptyState(); return; } const match = doctors.find( (d) => (d.DrName || "").toLowerCase().includes(q) || (d["Legacy Code"] || "").toLowerCase().includes(q) || String(d.Pcode || "") .toLowerCase() .includes(q) ); if (match) { const isPcodeMatch = String(match.Pcode || "") .toLowerCase() .includes(q); // Update profile cards if (isPcodeMatch) { renderAnimatedProfile(match["Legacy Code"], match.Pcode); } else { renderAnimatedProfile(match["Legacy Code"]); } // Clear inside the donut container mrChartContainer.innerHTML = ""; mrChartContainer.appendChild(mrByDivisionChart(match["Legacy Code"])); // CRITICAL FIX: Every single time a new doctor chart renders, force it to be full-width // inside its 50% grid column block so it cannot drift or generate blank space. mrChartContainer.style.display = "block"; mrChartContainer.style.width = "100%"; mrChartContainer.style.margin = "0"; mrChartContainer.style.padding = "0"; // Clean and inject the requested trend nodes dynamically avgVisitsContainer.innerHTML = ""; avgVisitsContainer.appendChild(avgVisitsChart(match["Legacy Code"])); investedContainer.innerHTML = ""; investedContainer.appendChild(investedKpi(match["Legacy Code"])); } else { profileContainer.innerHTML = `

No matching records found for "${e.target.value}"

`; mrChartContainer.innerHTML = ""; avgVisitsContainer.innerHTML = ""; investedContainer.innerHTML = ""; } }); // 4. Build Fixed Layout Hierarchy — donut and line chart side by side, invested spans full width below masterChartsFlexRow.appendChild(mrChartContainer); // Left 50% masterChartsFlexRow.appendChild(avgVisitsContainer); // Right 50% // 5. Append everything to the main workspace wrapper layout wrap.appendChild(input); wrap.appendChild(profileContainer); wrap.appendChild(masterChartsFlexRow); wrap.appendChild(investedContainer); // full-width, below both columns // 6. Initialize layout frame showEmptyState(); return wrap; } 52:T1505,renderAnimatedProfile = function (legacyCode, specificPcode) { // 1. Fetch all rows linked under this Legacy Code normally let rows = byLegacyCode.get(legacyCode) || []; // FIX: If a specific Pcode search is requested, isolate ONLY that card row record if (specificPcode) { rows = rows.filter( (r) => String(r.Pcode || "").toLowerCase() === String(specificPcode).toLowerCase() ); } // Safety fallback check if array becomes completely empty if (rows.length === 0) return; const identity = rows[0]; const primaryColor = divColors[rows[0].Division] || "#146C64"; const initials = identity.DrName.split(" ") .map((n) => n[0]) .join("") .slice(0, 2) .toUpperCase(); // FIXED: Removed the standalone 'isCrm = crmPcodesAll.has(r.Pcode)' line which broke the runtime const isCrmDoctor = rows.some((r) => crmPcodesAll.has(r.Pcode)); const cardsHtml = rows .map((r, i) => { const isCrm = crmPcodesAll.has(r.Pcode); return `

${r.Division} Class ${ r.Class }

Speciality: ${ r.Speciality || "—" }

MR: ${ r.Repname || "—" }

Location: ${ cleanLocation(r.Location) || "—" }

${isCrm ? "● CRM Doctor" : "○ Non-CRM Doctor"}

${combinedVisitLollipop(r.Pcode, r.VF)}

Pcode: ${
        r.Pcode
      }

`; }) .join(""); const doRender = () => { profileContainer.innerHTML = `

${initials}

${ identity.DrName }

✉ ${identity.Email} Legacy: ${legacyCode} 0 engagements ${isCrmDoctor ? "● CRM Doctor" : "○ Non-CRM Doctor"}

${ rows.length > 1 ? "Engagements across " + rows.length + " divisions" : "Engagement detail" }

${cardsHtml}

`; const inner = profileContainer.querySelector(".profile-inner"); requestAnimationFrame(() => { inner.style.opacity = 1; }); rows.forEach((r, i) => { const el = profileContainer.querySelector(".eng-card-" + i); if (el) { setTimeout(() => { el.style.opacity = 1; el.style.transform = "translateY(0)"; }, 60 * i); } }); const badge = profileContainer.querySelector("#engCountBadge"); const start = performance.now(); function step(now) { const progress = Math.min((now - start) / 500, 1); badge.textContent = Math.round(rows.length * progress) + " engagement" + (rows.length !== 1 ? "s" : ""); if (progress < 1) requestAnimationFrame(step); } requestAnimationFrame(step); }; doRender(); }53:T9ad,combinedVisitLollipop = function (pcode, vf) { const data = visitsByPcode.get(pcode) || []; if (data.length === 0 || vf === undefined) return '

No data

'; const w = 210, h = 60, padTop = 16, padBottom = 16; const plotH = h - padTop - padBottom; const max = Math.max(...data.map((d) => d.visits), vf, 1); const groupW = w / data.length; const stemGap = 10; const monthLabel = (isoStr) => new Date(isoStr).toLocaleString("en-US", { month: "short" }); const items = data .map((d, i) => { const groupCx = groupW * i + groupW / 2; const actualCx = groupCx - stemGap / 2; const targetCx = groupCx + stemGap / 2; const baseY = h - padBottom; const actualH = (d.visits / max) * plotH; const actualY = baseY - actualH; const isOver = d.visits > vf; const isUnder = d.visits < vf; const actualColor = isOver ? "#1D5B8F" : isUnder ? "#B8752E" : "#146C64"; const targetH = (vf / max) * plotH; const targetY = baseY - targetH; return ` ${ d.visits } ${monthLabel( d.month )} `; }) .join(""); return `

Actual vs. Target (VF ${vf})

● On target ● Over ● Under ○ Target

`; }54:T616,miniVisitChart = function (pcode) { const data = visitsByPcode.get(pcode) || []; if (data.length === 0) return '

No visit data

'; const w = 170, h = 56, padTop = 14, padBottom = 16; const plotH = h - padTop - padBottom; const max = Math.max(...data.map((d) => d.visits), 1); const step = w / data.length; const monthLabel = (isoStr) => { const d = new Date(isoStr); return d.toLocaleString("en-US", { month: "short" }); }; const items = data .map((d, i) => { const cx = step * i + step / 2; const barH = (d.visits / max) * plotH; const cy = h - padBottom - barH; const baseY = h - padBottom; return ` ${ d.visits } ${monthLabel( d.month )} `; }) .join(""); return `

Visits (3mo)

`; }55:T8da,mrOverUnderTable = function (status) { const color = status === "over" ? "#1D5B8F" : "#B8752E"; let grandTotal = 0; const monthTotals = mrMonths.map(() => 0); const rowsHtml = mrDivisions .map((div) => { let rowTotal = 0; const cells = mrMonths .map((m, mi) => { const count = mrRecords.filter( (r) => r.division === div && r.month === m && r.status === status ).length; rowTotal += count; monthTotals[mi] += count; return `${count || "—"}`; }) .join(""); grandTotal += rowTotal; return ` ${div} ${cells}${rowTotal} `; }) .join(""); const headCells = mrMonths .map( (m) => `${m}` ) .join(""); const totalRow = ` Total ${monthTotals .map((t) => `${t}`) .join("")} ${grandTotal} `; return html` ${headCells} ${rowsHtml}${totalRow}

Division	Total

`; }56:T81c,mrTrendChart = { const width = 860, height = 260, margin = { top: 20, right: 30, bottom: 30, left: 40 }; const monthlyOver = mrMonths.map( (m) => mrRecords.filter((r) => r.month === m && r.status === "over").length ); const monthlyUnder = mrMonths.map( (m) => mrRecords.filter((r) => r.month === m && r.status === "under").length ); const x0 = d3 .scaleBand() .domain(mrMonths) .range([margin.left, width - margin.right]) .padding(0.3); const x1 = d3 .scaleBand() .domain(["over", "under"]) .range([0, x0.bandwidth()]) .padding(0.15); const y = d3 .scaleLinear() .domain([0, d3.max([...monthlyOver, ...monthlyUnder]) || 1]) .nice() .range([height - margin.bottom, margin.top]); const svg = d3.create("svg").attr("viewBox", `0 0 ${width} ${height}`); const g = svg.append("g"); mrMonths.forEach((m, i) => { const gx = g.append("g").attr("transform", `translate(${x0(m)},0)`); gx.append("rect") .attr("x", x1("over")) .attr("y", y(monthlyOver[i])) .attr("width", x1.bandwidth()) .attr("height", height - margin.bottom - y(monthlyOver[i])) .attr("fill", "#1D5B8F") .attr("rx", 2); gx.append("rect") .attr("x", x1("under")) .attr("y", y(monthlyUnder[i])) .attr("width", x1.bandwidth()) .attr("height", height - margin.bottom - y(monthlyUnder[i])) .attr("fill", "#B8752E") .attr("rx", 2); gx.append("text") .attr("x", x1("over") + x1.bandwidth() / 2) .attr("y", y(monthlyOver[i]) - 6) .attr("text-anchor", "middle") .attr("font-size", 11) .text(monthlyOver[i]); gx.append("text") .attr("x", x1("under") + x1.bandwidth() / 2) .attr("y", y(monthlyUnder[i]) - 6) .attr("text-anchor", "middle") .attr("font-size", 11) .text(monthlyUnder[i]); }); g.append("g") .attr("transform", `translate(0,${height - margin.bottom})`) .call(d3.axisBottom(x0)); g.selectAll(".domain, .tick line").attr("stroke", "#DDE2DC"); return svg.node(); }57:Tf91, mrOverviewTab = { const wrap = html`

`; // Create the search input directly here. // It is NOT connected reactively to globalSearchValue. const input = html``; const content = html`

`; function renderSearchResult() { const q = input.value.trim().toLowerCase(); content.innerHTML = ""; const matchedDoctor = q ? doctors.find( (d) => (d.DrName || "").toLowerCase().includes(q) || (d["Legacy Code"] || "").toLowerCase().includes(q) || String(d.Pcode || "").toLowerCase().includes(q) || (d.Repname || "").toLowerCase().includes(q) ) : null; // ----------------------------- // DOCTOR FOUND // ----------------------------- if (matchedDoctor) { mutable selectedDoctor = matchedDoctor; content.append( html`

${viewof mrMonthCheckboxes}

${mrDoctorDivisionTable( matchedDoctor["Legacy Code"], mrMonthCheckboxes )}

` ); return; } // ----------------------------- // SEARCH BUT NO MATCH // ----------------------------- if (q) { content.append( html`

No matching doctor found for "${input.value}"

` ); return; } // ----------------------------- // NO SEARCH // ----------------------------- content.append( html`

${mrSummaryStrip}

Overvisits by Division & Month

${mrOverUnderTable("over")}

Undervisits by Division & Month

${mrOverUnderTable("under")}

Overvisit vs Undervisit — Month-on-Month

${mrTrendChart}

` ); } // Search changes ONLY the content below the input. // The input itself is never recreated. input.addEventListener("input", renderSearchResult); wrap.append(input, content); renderSearchResult(); return wrap; }58:T11f0,mrDoctorDivisionTable = function (legacyCode, selectedMonths) { const rows = byLegacyCode.get(legacyCode); if (!rows) return html`

No doctor found.

`; const monthsToUse = selectedMonths && selectedMonths.length > 0 ? selectedMonths : mrMonths; const dayCountByWeekday = {}; const bodyRows = rows .map((r) => { let total = 0, over = 0, under = 0; monthsToUse.forEach((m) => { const rawMonth = doctorSheet.find( (d) => d.Pcode === r.Pcode && new Date(d.Month).toISOString().slice(0, 7) === m ); const actual = rawMonth ? rawMonth["No of Visits"] || 0 : 0; total += actual; if (actual > r.VF) over++; if (actual < r.VF) under++; if (rawMonth && rawMonth.Visits) { const match = rawMonth.Visits.match(/$([\d,]*)$/); if (match && match[1]) { match[1].split(",").forEach((dayStr) => { const day = parseInt(dayStr); if (!isNaN(day)) { const dateObj = new Date( m + "-" + String(day).padStart(2, "0") ); const weekday = dateObj.toLocaleDateString("en-US", { weekday: "long" }); dayCountByWeekday[weekday] = (dayCountByWeekday[weekday] || 0) + 1; } }); } } }); return ` ${ r.Division } ${total} ${ under || "—" } ${ over || "—" } `; }) .join(""); const grandTotal = rows.reduce((sum, r) => { return ( sum + monthsToUse.reduce((s, m) => { const rawMonth = doctorSheet.find( (d) => d.Pcode === r.Pcode && new Date(d.Month).toISOString().slice(0, 7) === m ); return s + (rawMonth ? rawMonth["No of Visits"] || 0 : 0); }, 0) ); }, 0); const suggestedDays = Object.entries(dayCountByWeekday) .sort((a, b) => b[1] - a[1]) .slice(0, 3); return html`

MR Division Overview — ${ rows[0].DrName }

${bodyRows}

Division	Total Visits	Undervisit	Overvisit
Total	${grandTotal}

Suggested Visit Days

Based on ${ monthsToUse.length }-month visit pattern

${suggestedDays .map( ([day, count]) => `

${day} — ${count} visits

` ) .join("")}

`; }59:T162f,mrDoctorDivisionTableNew = function (legacyCode, selectedMonths) { const rows = byLegacyCode.get(legacyCode); if (!rows || rows.length === 0) { return html`

No doctor found.

`; } const monthsToUse = selectedMonths && selectedMonths.length > 0 ? selectedMonths : mrMonths; const dayCountByWeekday = {}; // Helper to consistently convert a date into YYYY-MM const getMonthKey = (date) => { return new Date(date).toISOString().slice(0, 7); }; // Find the corresponding visit record from data3 const getVisitRecord = (pcode, month) => { return data3.find( (d) => String(d.Pcode) === String(pcode) && getMonthKey(d.Month) === month ); }; const bodyRows = rows .map((r) => { let total = 0; let over = 0; let under = 0; monthsToUse.forEach((m) => { // NOW GETTING DATA FROM data3 / Dr_List@1 const visitRecord = getVisitRecord(r.Pcode, m); const actual = visitRecord ? Number(visitRecord["No of Visits"]) || 0 : 0; total += actual; // Compare actual visits with VF if (actual > r.VF) over++; if (actual < r.VF) under++; // Suggested visit days also come from data3 if (visitRecord && visitRecord.Visits) { const match = String(visitRecord.Visits).match(/$([\d,]*)$/); if (match && match[1]) { match[1].split(",").forEach((dayStr) => { const day = parseInt(dayStr); if (!isNaN(day)) { const dateObj = new Date( `${m}-${String(day).padStart(2, "0")}` ); const weekday = dateObj.toLocaleDateString("en-US", { weekday: "long" }); dayCountByWeekday[weekday] = (dayCountByWeekday[weekday] || 0) + 1; } }); } } }); return ` ${r.Division} ${total} ${under || "—"} ${over || "—"} `; }) .join(""); // Grand total also comes from data3 const grandTotal = rows.reduce((sum, r) => { const doctorTotal = monthsToUse.reduce((monthSum, m) => { const visitRecord = getVisitRecord(r.Pcode, m); return ( monthSum + (visitRecord ? Number(visitRecord["No of Visits"]) || 0 : 0) ); }, 0); return sum + doctorTotal; }, 0); // Find the top 3 most common visit weekdays const suggestedDays = Object.entries(dayCountByWeekday) .sort((a, b) => b[1] - a[1]) .slice(0, 3); return html`

MR Division Overview — ${rows[0].DrName}

${bodyRows}

Division	Total Visits	Undervisit	Overvisit
Total	${grandTotal}

Suggested Visit Days

Based on ${monthsToUse.length}-month visit pattern

${suggestedDays .map( ([day, count]) => `

${day} — ${count} visits

` ) .join("")}

`; }5a:[{"id":"58a2ce671bdd60cbd1ec8500c3a68b91f016207c5485470f35f33e8390c9950749534d913bd80d3cd1eaa6cc8a56ed6aae2a97590673e5fda1b4dbd266e233ff","href":"https://static.observableusercontent.com/files/58a2ce671bdd60cbd1ec8500c3a68b91f016207c5485470f35f33e8390c9950749534d913bd80d3cd1eaa6cc8a56ed6aae2a97590673e5fda1b4dbd266e233ff","name":"CRM_Dummy@1.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1787216393772.099,"size":11369},{"id":"9e781e21424edab5252ec2b913d05ec8d7110d239c635ad38faaad3cfa1680590dce03957a41ffed00aa542da1d7031a843f6995af858e34e8d083efa79f7bd8","href":"https://static.observableusercontent.com/files/9e781e21424edab5252ec2b913d05ec8d7110d239c635ad38faaad3cfa1680590dce03957a41ffed00aa542da1d7031a843f6995af858e34e8d083efa79f7bd8","name":"Copy of Dr_List.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1787213929299.057,"size":49883},{"id":"09c9e620b17c6f7985a4d7088a3a07d94603511c5e678181e44deeb85cdf93f24edfdb1b56b855187dec8a25fa0e75a33f0bde2bd652b8bad896efba9836cc43","href":"https://static.observableusercontent.com/files/09c9e620b17c6f7985a4d7088a3a07d94603511c5e678181e44deeb85cdf93f24edfdb1b56b855187dec8a25fa0e75a33f0bde2bd652b8bad896efba9836cc43","name":"CRM_Dummy.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1787213929299.057,"size":11020},{"id":"32f84374e9f2f76eef46ad72ec5bcda4a60d12654b981b586c0cf97867f8997ae4cbd982df6376d76d051fbd5f01eb68002e8033c6579c624250cd780a896ad3","href":"https://static.observableusercontent.com/files/32f84374e9f2f76eef46ad72ec5bcda4a60d12654b981b586c0cf97867f8997ae4cbd982df6376d76d051fbd5f01eb68002e8033c6579c624250cd780a896ad3","name":"dvp_test.json","type":"application/json","lastModified":1787213929299.057,"size":263814},{"id":"47b1d33132af4324d1219dcb34808b7ee3aba3564caa58bc260bb85b108ffbc3694b5e1625b267dfb1785cc81fc2ce796ac97871fa9c8c9736a31d932d334256","href":"https://static.observableusercontent.com/files/47b1d33132af4324d1219dcb34808b7ee3aba3564caa58bc260bb85b108ffbc3694b5e1625b267dfb1785cc81fc2ce796ac97871fa9c8c9736a31d932d334256","name":"Copy_of_Dr_List_added_with_visits.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1787216386082.148,"size":95975},{"id":"6a06f8801f767f9596eb7e1370dfef8f0d897f436d345121382b75deabe168ef4ee179cc9145383d72817ecd6198caaaeb522891b0080f564fb9502b7d1446a8","href":"https://static.observableusercontent.com/files/6a06f8801f767f9596eb7e1370dfef8f0d897f436d345121382b75deabe168ef4ee179cc9145383d72817ecd6198caaaeb522891b0080f564fb9502b7d1446a8","name":"Copy of Dr_List@1.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1787213929299.057,"size":140018}] 46:{"id":"aca018d355244119","slug":"doctor-360","title":"Doctor 360","thumbnail":"49e3b8e7b5c25c76853ac31b4ed41e895e2facb91573182f4e68e995d0ccb899","access_level":"public","create_time":"$D2026-08-20T08:18:49.299Z","update_time":"$D2026-10-08T10:20:30.258Z","view_time":null,"first_public_time":"$D2026-08-24T04:57:33.219Z","has_unpublished_edits":null,"fork":true,"stars":0,"starred":false,"owner":{"type":"team","id":"3e1870210c77f482","login":"abhishek-nilewad","name":"Abhishek Nilewad","avatar_url":"https://avatars-next.observableusercontent.com/695c3230e404af5cda543da7b766d0f2510e8a6fb240f2653973973eaeb06409","tier":"starter_2024","bio":"A D3 Aspirant","following":false},"version":553,"publish_version":553,"role":null,"authored":false,"authors":[{"type":"individual","id":"794ba5d4a32b6f2c","login":"abhishek-nilewad","name":"Abhishek Nilewad","avatar_url":"https://avatars-next.observableusercontent.com/695c3230e404af5cda543da7b766d0f2510e8a6fb240f2653973973eaeb06409","tier":null,"bio":"A D3 Aspirant","following":false}],"members":[{"type":"team","id":"3e1870210c77f482","login":"abhishek-nilewad","name":"Abhishek Nilewad","avatar_url":"https://avatars-next.observableusercontent.com/695c3230e404af5cda543da7b766d0f2510e8a6fb240f2653973973eaeb06409","tier":"starter_2024","role":"editor"},{"type":"individual","id":"794ba5d4a32b6f2c","login":"abhishek-nilewad","name":"Abhishek Nilewad","avatar_url":"https://avatars-next.observableusercontent.com/695c3230e404af5cda543da7b766d0f2510e8a6fb240f2653973973eaeb06409","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Doctor 360","cells":[{"id":0,"value":"# Doctor 360","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":5,"value":"doctorMaster = FileAttachment(\"Copy_of_Dr_List_added_with_visits.xlsx\").xlsx()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":6,"value":"doctorMaster.sheetNames","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":7,"value":"data = doctorMaster.sheet(0, {\n headers: true\n // range: \"A1:J10\"\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":10,"value":"// Headers : true ","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":12,"value":"doctorSheet = doctorMaster.sheet(\"Sheet1\", { headers: true })","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":17,"value":"// Loading DVP and CRM","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":23,"value":"dvp_test = FileAttachment(\"dvp_test.json\").json()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":24,"value":"crm = FileAttachment(\"CRM_Dummy@1.xlsx\").xlsx()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":29,"value":"data2 = crm.sheet(\"Sheet1\", { headers: true })","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":25,"value":"crm.sheetNames","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":26,"value":"data1 = crm.sheet(0, {\n headers: true\n // range: \"A1:J10\"\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":27,"value":"data1","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":36,"value":"// Merge — 250 rows = engagements, cleaned","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":38,"value":"doctors = doctorSheet\n .filter(\n (d) =>\n d.Pcode !== null && d.Month !== null && new Date(d.Month).getMonth() === 6\n )\n .map((d) => ({\n ...d,\n Division: (d.Division || \"\").trim(),\n Class: (d.Class || \"\").trim()\n }))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":40,"value":"// CRM lookup (handles the leading-space header issue)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":42,"value":"crmPcodeKey = Object.keys(data2[0]).find((k) => k.trim() === \"Pcode\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":311,"value":"crmMonthKey = Object.keys(data2[0]).find(\n (k) => k.trim() === \"Month of Activity\"\n)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":44,"value":"crmPcodes = new Set(\n data2\n .filter((d) => new Date(d[crmMonthKey]).getMonth() === 6)\n .map((d) => d[crmPcodeKey])\n)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":46,"value":"// Group engagements by real doctor","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":48,"value":"byLegacyCode = {\n const map = new Map();\n\n const seenDoctorDivision = new Set();\n\n doctors.forEach((d) => {\n const legacyCode = String(d[\"Legacy Code\"] || \"\").trim();\n const division = String(d.Division || \"\").trim();\n const pcode = String(d.Pcode || \"\").trim();\n\n if (!legacyCode || !division || !pcode) return;\n\n // One Pcode per Division for each doctor\n const key = `${legacyCode}|${division}`;\n\n if (seenDoctorDivision.has(key)) return;\n\n seenDoctorDivision.add(key);\n\n if (!map.has(legacyCode)) {\n map.set(legacyCode, []);\n }\n\n map.get(legacyCode).push(d);\n });\n\n return map;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":50,"value":"// Colors","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":52,"value":"divColors = ({\n Cardicare: \"#C0392B\",\n Metacare: \"#2E7D6B\",\n Myocare: \"#6C4F9C\",\n Gencare: \"#B8752E\",\n Lifecare: \"#1D5B8F\"\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":56,"value":"blueScale = function (entries) {\n const values = entries.map((d) => d[1]);\n const scale = d3\n .scaleSequential(d3.interpolateBlues)\n .domain([d3.min(values), d3.max(values)]);\n return (val) => scale(val);\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":58,"value":"// Summary card + strip ","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":60,"value":"makeSummaryCard = function (value, label) {\n return html`

${value}

${label}

\n ${makeSummaryCard(totalDoctors, \"Total Doctors\")}\n ${makeSummaryCard(crmLinked, \"CRM-Linked\")}\n ${makeSummaryCard(divisions, \"Divisions\")}\n ${makeSummaryCard(cities, \"Cities Covered\")}\n

${title}

${node}

`;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":91,"value":"// Overall doctor tab ","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":108,"value":"// Click state ","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":155,"value":"mutable selectedDivisionForFilter = null","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":159,"value":"mutable activeTab = \"Overall Doctor Data\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":153,"value":"filteredDoctors = selectedDivisionForFilter\n ? doctors.filter((d) => d.Division === selectedDivisionForFilter)\n : doctors","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":112,"value":"// clickable division bar chart ","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":114,"value":"$4a","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":136,"value":"// CRM count card ","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":138,"value":"crmCountCard = {\n const filteredLegacyCodes = new Set(\n filteredDoctors.map((d) => d[\"Legacy Code\"])\n );\n const count = Array.from(crmLegacyCodesJuly).filter((lc) =>\n filteredLegacyCodes.has(lc)\n ).length;\n return html`

${count}

CRM-Linked (July)${\n selectedDivisionForFilter ? \" — \" + selectedDivisionForFilter : \"\"\n }

`;\n tabs.forEach((t) => {\n const btn = html`${t}`;\n btn.onclick = () => {\n mutable activeTab = t;\n };\n bar.appendChild(btn);\n });\n return bar;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":322,"value":"// Average-visits line chart, person-level, in Tab 2:","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":333,"value":"$4d","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":324,"value":"totalInvestedFor = function (legacyCode) {\n const records = data2.filter((d) => d[\"Legacy code\"] === legacyCode);\n const total = d3.sum(\n records,\n (d) => parseFloat(String(d.Spent).replace(/[^0-9.]/g, \"\")) || 0\n );\n return total;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":337,"value":"$4e","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":101,"value":"// Full dashboard assembly ","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":103,"value":"$4f","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":195,"value":"// Doctor profile - Tab 2","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":197,"value":"// search input ","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":389,"value":"mutable mrSearchValue = \"\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":391,"value":"mrFilteredRecords = {\n const q = (globalSearchValue || \"\").trim().toLowerCase();\n if (!q) return mrRecords;\n return mrRecords.filter(\n (r) =>\n (r.drName || \"\").toLowerCase().includes(q) ||\n (r.legacyCode || \"\").toLowerCase().includes(q) ||\n (r.repname || \"\").toLowerCase().includes(q)\n );\n}\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":393,"value":"mrSearchInput = {\n const input = html``;\n\n input.addEventListener(\"input\", (e) => {\n mutable globalSearchValue = e.target.value;\n });\n\n return input;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":203,"value":"profileContainer = html`

`","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":399,"value":"// Mutable global search value ","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":397,"value":"mutable globalSearchValue = \"\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":431,"value":"mutable selectedDoctor = null","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":438,"value":"$50","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":457,"value":"$51","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":220,"value":"cleanLocation = function (loc) {\n return (loc || \"\").replace(/^TERRITORY-/i, \"\").trim();\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":222,"value":"$52","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":228,"value":"// Adding graph (small) in the engagement card for MR visits","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":232,"value":"workbook = FileAttachment(\"Copy of Dr_List@1.xlsx\").xlsx()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":233,"value":"workbook.sheetNames","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":234,"value":"data3 = workbook.sheet(0, {\n headers: true\n // range: \"A1:J10\"\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":235,"value":"data3","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":237,"value":"visitsByPcode = {\n const map = new Map();\n data3.forEach((r) => {\n if (!map.has(r.Pcode)) map.set(r.Pcode, []);\n map.get(r.Pcode).push({ month: r.Month, visits: r[\"No of Visits\"] || 0 });\n });\n for (const arr of map.values())\n arr.sort((a, b) => new Date(a.month) - new Date(b.month));\n return map;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":353,"value":"// Combined visit ","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":351,"value":"$53","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":247,"value":"$54","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":263,"value":"// Donut to show division wise how many MR the doctor is meeting","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":359,"value":"// MR Overview ","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":361,"value":"mrRecords = doctorSheet\n .filter((d) => d.Pcode !== null && d.Month !== null)\n .map((d) => {\n const visits = d[\"No of Visits\"];\n const vf = d.VF;\n const status = visits > vf ? \"over\" : visits < vf ? \"under\" : \"on\";\n return {\n month: new Date(d.Month).toISOString().slice(0, 7),\n division: (d.Division || \"\").trim(),\n status,\n drName: d.DrName,\n legacyCode: d[\"Legacy Code\"],\n repname: d.Repname\n };\n })","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":363,"value":"mrMonths = Array.from(new Set(mrRecords.map((r) => r.month))).sort()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":365,"value":"mrDivisions = Array.from(new Set(mrRecords.map((r) => r.division))).sort()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":367,"value":"// Summary strip ","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":369,"value":"mrSummaryStrip = {\n const over = mrRecords.filter((r) => r.status === \"over\").length;\n const under = mrRecords.filter((r) => r.status === \"under\").length;\n const onTarget = mrRecords.filter((r) => r.status === \"on\").length;\n return html`

\n ${makeSummaryCard(over, \"Overvisits\")}\n ${makeSummaryCard(under, \"Undervisits\")}\n ${makeSummaryCard(onTarget, \"On Target\")}\n ${makeSummaryCard(mrRecords.length, \"Total Records\")}\n

`;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":371,"value":"// Division × Month table builder (used for both Over and Under)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":373,"value":"$55","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":375,"value":"// Trend chart (grouped bars, over vs under per month):","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":377,"value":"$56","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":379,"value":"// Assemble the tab","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":423,"value":"// mutable month filter","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":443,"value":"mrMonthLabels = ({\n [mrMonths[0]]: \"May\",\n [mrMonths[1]]: \"June\",\n [mrMonths[2]]: \"July\"\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":425,"value":"viewof mrMonthCheckboxes = Inputs.checkbox(mrMonths, {\n value: mrMonths,\n label: \"Months\",\n format: (m) => mrMonthLabels[m] || m\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":453,"value":"$57","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":415,"value":"// MR Division doctor table","pinned":false,"hidden":false,"mode":"js","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":417,"value":"$58","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":444,"value":"dashboard","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":449,"value":"$59","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W5a","stdlib":"1"}} 47:"$46:body"