Skip to content

Change a report's dates and export it

How-to5 minFoundation

Before you start

Open a report, then ask it a narrower question: only this month, only one vendor. Your changes affect what you see and export. They don’t change the saved report, so nobody else is affected.

  1. Open a report from Reports.
  2. Above the chart, choose All time, This month or Last 30 days.
  3. Or click Custom. Pick a Field, then a From date, a To date, or both, and click Apply.
A line chart report titled Deals Value Chart. Above the chart: All time, This month, Last 30 days, Custom and a Filter button. The Export menu is open with Chart image and CSV.
    These buttons set the date range.
    Custom opens a window for your own dates.
    Filter adds a condition on any field.
    Refresh runs the report again with the latest data.
    Export saves the chart or its data.
    Data behind this chart opens the grouped numbers the chart is drawn from.

Leave From or To empty for an open-ended range. If the start is after the end, Beezr says The start date is after the end date. The line under the title says when the report last ran, for example Ran now.

Click Filter, choose a field, then set a value. The window you get depends on the field:

Field kindYou choose
A list, such as statusOne or more values, with a search box
TextContains, Is or Is not, and a value
A numberIs, Is not, At least, At most or Between
A dateFrom and To

Each filter becomes a chip. Click a chip to change it, or its x to remove it. Clear all removes everything at once.

Click Export and choose a format.

FormatWhen it’s offeredYou get
Chart image (.png)Chart reportsThe chart as shown, as an image
CSV (.csv)Every reportThe report’s grouped data, with your filters and sort
Excel (.xlsx)Custom tablesA spreadsheet of the table

Reports download straight to your browser. A list export from a module’s records is different: it arrives by email. See Export records.

The CSV holds the grouped data the chart shows, one row per bar or slice. For the individual records, export the module’s list instead.

Beezr writes your dates and filters into the page address. Copy the address from your browser and send it to a colleague who can open the report. They see the same view.

Check yourself

Layla sets Last 30 days on a report and exports it as a CSV. What does the CSV hold?
Show the answer

The report's grouped data for the last 30 days. A chart's CSV exports its grouped data, and filters and dates apply. It isn't a dump of every record.

Omar sets a filter on a report, then closes it. The next day he opens it from the library. What does he see?
Show the answer

The report as saved, without his filter. Filters and dates in the viewer change only what you see now. They are kept in the page address, not in the saved report.

What's next

Last checked