Dashboard Charts
How the 50+ interactive charts work, the chart types you'll see (with examples), and a full catalog with the calculation behind each.
Charts are controls, not just pictures
The Follow-Up Dashboard turns your portfolio into more than 50 interactive charts. Every chart is built from the trials currently in view, and clicking a chart filters the whole dashboard. As you click, charts recalculate so each one always reflects the current selection.
- Each chart counts or sums the trials in your portfolio grouped by some attribute — for example "number of trials per phase" or "total spending per drug".
- Click a bar, slice, cell, or bubble to filter every other chart (and the table and map) to that value.
- Selections stack across charts, so you can isolate a precise slice (e.g. Phase 3 + Recruiting + one sponsor).
- Click the same element again, or use Clear Filters, to remove a selection.
Chart tools
Common controls available on the dashboard and on individual charts:
- Info (ⓘ) — every chart has an info button that explains, in plain language, exactly what it counts, which data it draws on, and what clicking does. The catalog below mirrors that text.
- Chart search bar — search by chart title ("Patent Cliff") or by a data value (a drug, sponsor, condition, or country); picking a suggestion filters the dashboard to it.
- Maximize — expand any chart full-screen to see all items (charts show a top-N by default and the rest when maximized).
- Export — copy a chart's data (with percentages) to the clipboard, or copy the chart as an image for slides.
- Hide / show — hide charts you don't need; a bar at the top lets you restore them.
- Some charts add their own toggles, such as a date-field selector or a label/colour toggle.
How the numbers are computed
Every chart is a live count or sum over the trials currently in view — nothing is pre-baked. Two patterns cover almost all of them:
- Count of trials grouped by an attribute (status, phase, sponsor, condition…). A trial that has several values for an attribute (two phases, sites in three countries) is counted once per value, so percentages can add up to more than 100%.
- Sum or rank of a linked measure (spending, patents, adverse events…). These match your trials to the relevant FDA / EMA / CMS public records through the drugs and devices linked to each trial.
- Because a trial can be linked to several drugs or devices, the same trial can contribute to more than one drug or device row.
- Each catalog table below states, per chart, both what it shows and how it's calculated (which data it draws on and how it's grouped or scored).
Chart types you'll see
ClinicaLister uses a handful of chart types. Here's what each looks like and when it's used. (Examples below use sample numbers.)
Pie / donut
Shows how a whole splits into parts — the most common type, used for status, study type, phases, ages, regions, drug source, dosage form, device class, submission type, roles, validation status, MRI safety, and more. Each slice is a category; its size is the share of the portfolio. Click a slice to filter.
- Completed(48%)
- Recruiting(32%)
- Terminated(12%)
- Active(8%)
Vertical bar
Compares counts across categories or over time — top conditions, facilities and sponsors, drug & device names, the patent-cliff and approval-lag timelines, and designation activity. Click a bar to filter.
Horizontal bar
Used when items have long names or there are many to rank — pharmacologic class, approval status, spending (Part D, Open Payments, ASP), NADAC cost, loss of exclusivity, comparator threats, molecule saturation, top diseases, and supply-chain geography. Click a bar to filter.
Area (trend)
One chart, Trial Start Activity, uses a filled area to plot how many of your trials started each year. Hover for a year's value. It's read-only — it shows a trend rather than acting as a filter.
Matrix, heatmap & data grid
The Pipeline Matrix cross-tabulates top sponsors (rows) against phases (columns); each cell counts trials and a darker cell means more. Click a cell to filter by that sponsor and phase together, or a row/column header to filter by just one. The Patent Cliff & Spend chart is a related heatmap that pairs patent-expiry timing with spend, and a data-grid layout (Molecular Properties) lists per-item values rather than a single number.
| P1 | P2 | P3 | P4 | |
|---|---|---|---|---|
| Sponsor A | 2 | 5 | 8 | 1 |
| Sponsor B | 4 | 3 | 2 | |
| Sponsor C | 1 | 6 | 4 | 3 |
Scatter / bubble
Plots items on two axes, with bubble size adding a third measure — Countries Distribution, and the drug and device safety-signal plots (PRR vs ROR). Click a bubble to filter to it.
Stat & alert cards
Some signals are shown as a short alert list rather than a chart — drug shortages, boxed warnings, and device recalls. Each entry is clickable to filter to that drug or device, and is colour-coded by seriousness.
Trial metadata charts
The core view of your portfolio — who, what, where, and when. All counts are over the trials currently in view.
| Chart | Type | What it shows & how it's calculated |
|---|---|---|
| Overall Status | Pie | Trials grouped by recruitment status; each trial has exactly one status. |
| Study Type | Pie | Interventional vs Observational vs Expanded Access, from each trial's design. |
| Phases | Pie | Trials per phase (Early Phase 1 → Phase 4, or N/A); a Phase 1/Phase 2 trial is counted in both. |
| Ages | Pie | Eligible age groups (Child 0–17, Adult 18–64, Older Adult 65+); a trial can span several. |
| Top Conditions | Vertical bar | Counts trials per condition listed on each trial. |
| Last Update | Vertical bar | Trials grouped by the month they last posted an update — spot active vs stale trials. |
| Top Facilities | Vertical bar | Counts your trials per site, from each trial's listed locations; respects any country/region selection. |
| Countries Distribution | Bubble | Trials per country from their site locations; a trial with sites in several countries counts in each. |
| Regions Distribution | Pie | Trial countries grouped into world regions, then counted. |
| Lead Sponsors | Vertical bar | Counts trials per lead sponsor. |
| Pipeline Matrix | Matrix | Top sponsors (rows) × phases (columns); each cell is the trial count, darker = more. Click to filter by both. |
| Trial Start Activity | Area (trend) | Counts trials by the year they started (read-only). |
MONDO disease charts
Your trials' conditions mapped to standardized disease terms (the MONDO disease ontology).
| Chart | Type | What it shows & how it's calculated |
|---|---|---|
| MONDO Top Diseases | Grouped horizontal bar | Per disease: "Following" = how many of your trials map to that disease term; "Total linked" = all trials for the term across the whole database. Click to filter your portfolio to the disease. |
| MONDO Rare vs Non-rare | Pie | Your distinct diseases split by whether each is flagged a rare disease. |
| MONDO Disease Match Method | Pie | How each trial's condition was matched to a standard disease term — exact name, alias, or AI-inferred — a rough indicator of mapping confidence. |
Drug & device charts
Built from the FDA/EMA drugs and FDA devices linked to your trials.
| Chart | Type | What it shows & how it's calculated |
|---|---|---|
| Drug Source | Pie | Linked drugs split by registry — FDA vs EMA. |
| Drug Names | Vertical bar | Top drugs by number of linked trials; biosimilar variants are grouped under the parent molecule. |
| Dosage Form | Pie | FDA drugs by form (tablet, capsule, injectable…). |
| Pharmacologic Class | Horizontal bar | Drugs grouped by mechanism/class (from FDA classifications, WHO ATC codes, or EMA therapeutic areas). |
| Drug Approval Status | Horizontal bar | Drugs by FDA marketing status (e.g. prescription, OTC, discontinued) or EMA authorisation status. |
| Therapeutic Area | Pie | EMA-listed drugs by therapeutic area. |
| Device Class | Pie | Devices by FDA risk class (I / II / III). |
| Submission Type | Pie | Device clearance pathway — 510(k), PMA, De Novo, HDE. |
| Device Names | Vertical bar | Top devices by number of linked trials. |
| Advisory Committee | Pie | Devices by the FDA advisory committee that reviewed them. |
| Medical Specialty | Pie | Devices by their medical-specialty classification. |
| FAERS Severity Events | Stacked horizontal bar | Adverse-event reports from the FDA's FAERS system per drug, split into death / hospitalization / life-threatening / disability. |
| MAUDE Event Types | Pie | Device adverse-event reports from the FDA's MAUDE database by type — malfunction, injury, death, other. |
| Drug Shortage Alerts | Alert card | Drugs with a current FDA shortage, with the reason and classification. |
| Boxed Warnings | Alert table | Drugs carrying an FDA boxed (black-box) warning, taken from the approved label. |
| NADAC Cost by Dosage Form | Horizontal bar | Average drug acquisition cost (the Medicaid NADAC benchmark) per unit, grouped by form, for the latest period. |
| Drug Signal Detection (PRR/ROR) | Scatter + table | A safety-signal calculation: for each drug it builds a 2×2 table of how often a serious adverse event appears in trials with that drug vs all other trials, then plots the disproportionality (PRR on the x-axis, ROR on the y-axis). Points are flagged significant by a chi-squared test (p < 0.05); bigger points = more trials. Drawn from trial adverse-event data. |
| Device Signal Detection (PRR/ROR) | Scatter + table | The same disproportionality method applied to device adverse-event reports. |
Financial intelligence charts
Spending, pricing, and patent economics for the drugs and devices in your portfolio.
| Chart | Type | What it shows & how it's calculated |
|---|---|---|
| Medicare Part D Spending | Horizontal bar | Total Medicare Part D spending matched to each drug, ranked (top drugs). |
| CMS Open Payments | Horizontal bar | Manufacturer payments to healthcare providers (from CMS Open Payments) tied to your drugs, broken down by payment type. |
| ASP Pricing | Horizontal bar | Medicare Part B average sales price per billing code, for injected/infused drugs (updated quarterly). |
| Patent Cliff Timeline | Vertical bar | Counts drug patents expiring per year (this year → +10), from each drug's patent records, coloured by urgency. |
| Loss of Exclusivity | Horizontal bar | Drugs whose market exclusivity ends within 24 months, in <6 / 6–12 / 12–24-month buckets. |
| Patent Cliff & Spend | Heatmap | Pairs each drug's exclusivity-expiry year with its spending (bubble size = linked trials) to flag high-spend drugs facing near-term generic competition. |
| Device Recalls | Alert card | Recent FDA recalls for your devices, grouped by recall class. |
Regulatory & designation charts
| Chart | Type | What it shows & how it's calculated |
|---|---|---|
| Regulatory Designations | Vertical bar | Counts drugs per FDA/EMA special designation — orphan, fast track, breakthrough, accelerated approval, REMS, and EMA equivalents. |
| Designation Velocity | Vertical bar | FDA special designations granted per year, plotted over time. |
| EMA-FDA Approval Lag | Vertical bar | For drugs approved in both regions, the gap between the FDA approval and EMA authorisation dates, bucketed. |
Advanced & competitive charts
Deeper competitive, data-quality, and supply-chain views.
| Chart | Type | What it shows & how it's calculated |
|---|---|---|
| Comparator Threat Matrix | Horizontal bar | How often each comparator drug is tested against a primary drug, counted by trial (using each trial's drug roles). |
| Molecule Saturation | Horizontal bar | The number of distinct sponsors developing each molecule (competitive crowding), coloured by intensity. |
| EU Trial Linkage | Pie | Share of your trials that also have an EU (CTIS) registration. |
| Drug Role in Trial | Pie | Drugs by their role in the trial — primary, comparator, concomitant, background, exclusion (extracted from protocols). |
| Device Role in Trial | Pie | Devices by their role in the trial. |
| Drug Validation Status | Pie | Drug–trial links by validation status — verified, uncertain, rejected, pending. |
| Device Validation Status | Pie | Device–trial links by validation status. |
| Molecular Properties | Data grid | Linked molecules by substance class (chemical, protein, mixture, polymer) and chemistry-reference coverage. |
| MRI Safety | Pie | Devices by MRI status — MR safe, conditional, unsafe, or no info (from the device's registration listing). |
| Supply Chain Geography | Horizontal bar | Countries with registered FDA manufacturing sites for your devices. |
| Recall Trend | Stacked vertical bar | Device recalls per year, stacked by recall class (I / II / III). |