Skip to main content

[Beta] Creating Smart Charts

Describe the data you want to see, and Monograph builds the chart.

⭐️ This feature is currently only available to a limited beta audience. Availability and functionality may change prior to general release.

Feature Available To: ✅ Grow Plan ❌ Track Plan ❌ Free Plan

Charts turn the data already in Monograph into bar, line, and pie charts and tables, without exporting to a spreadsheet. Describe what you want to see in plain language, for example, "billable hours by project this year" or "outstanding invoice balance by client". Monograph finds the right data, runs the numbers, and draws the chart.

Saved charts live on one Charts page that every Admin in the firm can open. Each chart recalculates when it's opened, so a chart for "this month" always shows the current month.


🚨 Only Admins can create, view and manage charts.


How Charts Work

Each chart starts as a request written in plain language. Monograph reads the request, works out which of your firm's data it needs, and runs a query against that data. The numbers come from your firm's records, not from estimates.

Use Charts to:

  • See hours logged by project, phase, person or activity over any timeframe

  • Compare planned (allocated) hours with hours actually logged

  • Track invoiced, paid and outstanding amounts by client or month

  • Follow pipeline health: lead counts, estimated budgets and win rate

  • Review what your firm owes consultants and what has been passed to client invoices

Field, filter, and grouping changes don't happen through menus. You describe them in words, the same way you'd ask a colleague. The only direct controls are Timeframe and the chart type.


Creating a Chart

Go to Analytics > Charts and click New chart. To start from anywhere in Monograph, open quick search and choose Create chart.

  1. Under What data do you want to visualize?, describe the chart you want. To start from an example, click one of the Suggested prompts.

  2. Choose a Timeframe. The default is This year.

  3. Under Select an output format, choose Bar, Line, Horizontal bar, Pie or Table.

  4. Click Generate chart.

  5. Review the chart, its title, and the short summary under it that explains what was measured.

  6. Click Save to add the chart to the Charts page.

Note: Nothing is saved until you click Save. Cancel returns to the Charts page and discards the chart.


📷Screenshot: New chart panel showing the prompt box, Timeframe and output formats

Writing a Good Request

The clearer the request, the closer the first chart will be to what you want. A good request names three things:

  • What to measure, such as hours, billed amount, outstanding balance or number of leads

  • How to break it down, such as by project, client, person, phase, week or month

  • Any filter, such as one client, billable time only or the top 5

Examples that work well:

  • "Billable hours by phase for the Riverside Library project, by month"

  • "Planned vs logged hours by team member by week"

  • "Outstanding invoice balance by client, largest first"

  • "Win rate by month"

  • "Amount owed to consultants by consultant company"

Use project, client, and team member names exactly as they appear in Monograph. Projects are matched by name; project numbers aren't supported yet.


💡Leave dates out of the request and set them with Timeframe instead. The preset timeframes stay current every time the chart opens. A phrase like "last quarter" in the request is converted to fixed dates and won't move forward.


Answering Clarifying Questions

When a request could mean more than one thing, Monograph asks before it builds the chart. This often happens when a project, client or person name doesn't exactly match a record. Monograph then offers the closest matches.

For each question, choose an answer, choose Other to type your own, or choose Skip to let Monograph make its best guess. Answering usually gives a more accurate chart.


📷Screenshot: A clarifying question with answer options, Other and Skip

Creating a Chart from Ask Monograph

When an Ask Monograph answer would work well as a chart, a Generate a chart button appears under the answer. Clicking it opens a new chart with your question already filled in as the request.


Refining a Chart

After a chart is generated, or when you click Edit on a saved chart, the right panel becomes Edit graph. Under Describe a change, type what should be different. Monograph makes the smallest change that matches the request and redraws the chart.

Changes you can ask for include:

  • Adding or removing a filter ("only billable time", "exclude archived leads")

  • Changing the breakdown ("break this down by team member", "group by week")

  • Limiting the results ("limit this to the top 5")

  • Comparing periods ("compare this to the previous period")

  • Measuring something else or switching the chart type

Some changes have direct controls under Customizations, above the chart:

  • Default display sets whether the chart opens as a bar, line, horizontal bar, pie or table.

  • Timeframe changes the date range and re-runs the chart.

Click Save to keep your changes. Saving overwrites the existing chart. To keep the original, use Save as new chart from the Charts page first (see below).


📷Screenshot: Edit graph panel with Customizations above the chart


Managing Saved Charts

The Charts page lists every saved chart in the firm. Each chart shows its timeframe under the title. Use Sort by to order charts by Date created or Alphabetical title.

The ⋯ menu on each chart has these options:

  • Edit name - Renames the chart.

  • Save as new chart - Creates a copy that you can change without touching the original.

  • Archive - Removes the chart from the main list.

Charts can't be deleted, only archived. To find an archived chart, click Show archived charts at the bottom of the page, then choose Unarchive from its ⋯ menu.

Use the Graph | Table toggle at the bottom of a chart to switch between the chart and the rows behind it.


📷Screenshot: Chart card with the ⋯ menu open


Exporting a Chart

Click Export as on any chart to choose a format:

  • Export as PDF - Downloads the chart as a PDF. Long horizontal bar charts continue across pages.

  • Copy as PNG - Copies an image of the chart to your clipboard, ready to paste into an email, slide or document.

  • Export as CSV - Downloads the underlying rows. Switch the chart to Table first; this option only appears in Table view.


What You Can Chart

Charts can use the following data. Monograph chooses the right source based on your request, and can combine sources in one chart, for example logged hours against capacity.

Data

What it covers

Examples of what to ask for

Time logged

Hours on timesheets, including project and overhead time

Total hours, billable hours, billable value; by person, project, phase, activity, week

Allocations

Planned weekly hours from resource planning

Allocated hours by person, project or week

Capacity

Each person's weekly available hours, time off and holidays

Capacity hours, time off hours

Invoices

Sent invoices (drafts excluded)

Billed, paid, outstanding, written off; by client, status, issue or due date

Billed items

Individual invoice line items

Billed amount by category (phase fees, consultants, expenses, retainers, taxes)

Projects

Active, proposed, paused, completed, and canceled projects

Number of projects, total fee, budget, consultants' fees

Pipeline

Leads, including archived leads

Number of leads, estimated budget, win rate; by status or stage

Consultant bills

Bills consultants sent to your firm

Billed by consultants, paid, owed, passed to a client invoice

Understanding the Numbers

Find below how numbers are calculated:

  • Billable value is hours times the billing rate on every time entry, billable or not. To see billable value only, ask to filter to billable time.

  • Capacity hours are the full weekly hours before time off and holidays are taken out. Ask for time off to be subtracted if you want available hours.

  • Utilization is calculated from logged hours and capacity, so it can differ from the built-in Utilization report. Say exactly how to calculate it, for example "billable hours divided by capacity hours minus time off".

  • Win rate counts only leads marked Closed Won or Closed Lost. Open, paused and disqualified leads are left out.

  • Allocations are the weekly hours planned in resource planning, not the role budgets set on a phase.

  • Consultant bills that are partially paid count as unpaid until they are paid in full.

  • Budget on a project is your firm's own fee, without consultants. Total fee includes consultants and markup.


🚨 The following can't be charted yet: profit, cost or margin; phase and role budgets; remaining fee and percent complete; unbilled work (WIP); expenses; and project number, category or project manager.


Timeframes

Preset timeframes recalculate each time a chart opens, using your firm's time zone:

  • Today and Yesterday

  • Last 7 days - Today and the six days before it

  • This month - The full calendar month

  • Last 6 months - The six months up to today (a rolling window, not six full calendar months)

  • This year - January 1 to December 31 of the current year

  • Custom - Fixed start and end dates that don't change

When a chart breaks results down by week, weeks start on Monday.


Chart Display Limits

  • Vertical bar charts draw up to 10 bars. The full list appears in a table under the chart.

  • Pie charts show the 7 largest slices and group the rest as Other. Pie charts can't show negative values, so these charts switch to a bar chart.

  • Each chart draws one measure. When a request includes more than one, the rest appear in Table view.

  • A chart returns up to 100 rows unless you ask for more, up to 1,000.


Frequently Asked Questions

Why don't I see Charts under Analytics?

Charts is available to Admins in firms that are part of the beta, on a paid or trial plan.

Can other team members see the charts I create?

Every Admin in the firm sees every saved chart. Team members without Admin access can't see charts yet. The conversation used to build a chart is visible only to the person who wrote it.

Why do two Admins see different numbers on the same chart?

Each chart runs with the access of the person viewing it. When two Admins have different access to projects or invoices, the numbers can differ.

Is the AI making up numbers?

No. Monograph turns your request into a query against your firm's data and draws the chart from the results. When there isn't data for a request, the chart says so instead of estimating.

Why does my chart say there's no data?

The timeframe may not contain any matching records, or a name in the request may not match a record. Widen the Timeframe, or check the spelling of the project, client or person.

Why does my bar chart only show 10 bars?

Bar charts draw the first 10 results. The full list appears in the table under the chart, or ask to "limit this to the top 10" to keep the chart focused.

Does "This year" update on its own?

Yes. Preset timeframes recalculate each time the chart opens. Custom dates stay fixed.

How do I delete a chart?

Archive it from the chart's ⋯ menu. Archived charts can be restored from Show archived charts.

Can I schedule a chart to be emailed, or share a link to it?

Not yet. Use Export as to send a PDF, an image or a CSV.

Can I build a dashboard?

Not yet. Saved charts appear in a single list on the Charts page.

Is Charts available in the mobile app?

No. Charts is available on the web app only.

Did this answer your question?