squaremeters.ai

Date ranges and filters

Use the date range, quick filters and the date property to see Dashboard figures for the right period and the right agent.

3 min read

The same widget can show very different numbers depending on the date range and filters you choose. The right answer to "how many sales did we complete this month?" depends on picking the right range and the right date property.

Change the date range

Squaremeters AI
Search⌘K
BA

Office overview

01 Sep 2026 – 30 Sep 20261

Calls answered by the assistant

Inbound calls

184

+12% vs last period

Appointments booked

Viewings + valuations

47

+9%

Hot leads

Tag: hot-lead

23

Open pipeline value

Buyers + Sellers

₺6,580,000

Leads by source

212
  • Inbound call · AI46%
  • Meta lead form22%
  • WhatsApp / Instagram18%
  • Website, referral14%

Buyers – by stage

New
Qualified
Booked
Viewing
Offer
Done
  • Today
  • Yesterday
  • Last 7 Days
  • Last 30 Days
  • This Month
  • Last Month
  • This Year
  • Custom
2

September 2026

MTWTFSS-2-101234567891011121314151617181920212223242526272829303132
CancelApply3
All widgets refresh for the selected range.
The date picker: preset ranges, a custom range from the calendar and the Apply button.
  1. Click the date field at the top right of the Dashboard.
  2. Pick a preset from the list on the left (Today, Last 7 Days, This Month, Last Month and so on), or click start and end days on the calendar for a custom range.
  3. Click Apply. Every widget on the dashboard refreshes for the selected range.

Tip

Compare ranges of equal length. Comparing "This Month" on the 10th with a 30-day "Last Month" is misleading; compare "Last 7 Days" with the 7 days before instead.

Quick filters and date property

Squaremeters AI
Search⌘K
BA

Office overview

01 Oct 2026 – 31 Oct 2026
Quick Filters1
Assigned User: Selin Kaya Pipeline: Buyers
2
Clear3

Buyer deals completed

Won

4

Status Change 4
Created On · Status Change · Updated On

Buyers – by stage

New
Qualified
Booked
Viewing
Offer
Done

Filters only change your view; they don't save the dashboard.

The Quick Filters bar: agent and pipeline filters, the Clear link and the widget's date property selector.
  1. Click Quick Filters at the top of the dashboard.
  2. Add filters; they appear as pills. For example Assigned User: Selin Kaya, Pipeline: Buyers. Click the arrow on a pill to change it.
  3. Click Clear to remove all filters.
  4. On some widgets (especially opportunity widgets) you can choose which date property to count by: Created On, Status Change or Updated On.

Quick filters don't change the dashboard permanently; they only narrow your current view. For a permanent filter, use the widget's own Conditions: Customise widgets.

Why the date property matters

Ahmet Demir called the assistant late at night on 18 September; his opportunity was created that day. The viewings happened in October, completion was on 22 October and the opportunity was marked Won. In a "Deals completed in October" widget, Ahmet:

Date propertyShows up in October?When to use it
Created OnNo (created in September)To measure how many new enquiries came in.
Status ChangeYes (Won in October)To measure how many deals closed.
Updated OnYes (updated in October)To see which opportunities were worked on.

Important

For "how many sales did we complete this month?", use Status Change. With Created On, clients who called last month and completed this month don't count, and completions look lower than they are. In property, weeks or months often pass between the first call and completion, so the difference is big.

Time zone

Figures are calculated in the dashboard's time zone. Because the assistant also answers calls close to midnight, a call at 23:50 can be counted on the wrong day if the dashboard is in another time zone. Set the dashboard to Europe/Istanbul with Manage dashboard timezone in the action menu. See Custom dashboards.

Example scenarios

  • Weekly team meeting: Last 7 Days; use Quick Filters to pick each Assigned User in turn and show their figures.
  • Ad campaign review: choose the campaign's start and end dates as a custom range and check the share of Meta lead forms in the lead sources widget. For detail, see Facebook ads report.
  • Month-end close report: Last Month + Status Change on opportunity widgets.

Troubleshooting

Dashboard and Reporting show different numbers. The date range, date property or time zone may differ between the two screens. Make all three the same and compare again.

I removed the filter but the number didn't change. The widget may have a permanent condition in its own Conditions. Open it in edit mode and check.

Didn't solve your problem?

Ask the assistant or message our support team.