Currently, Noloco dashboards show real-time data well, but there’s no native way to compare this data to previous time periods (like “This Month vs. Last Month” or “This Week vs. Last Week”).
I’ve added some screenshots of what this could potentially look like
Current Example Dashboard:
AI Gen Mockup Example:
Proposed Solution:
Add a built-in period-over-period comparison feature to visual components (charts, KPIs, gauges), with the ability to:
Choose a comparison window (e.g., previous week/month/quarter/custom range)
Show deltas (absolute or percentage changes)
Display both current and previous data points visually (e.g., bar overlays, line comparisons, or tooltips)
Example Use Cases:
Compare sales this month vs. last month
Monitor weekly call volume changes
Track client onboarding time reduction week-over-week
Let me know what you think, and if there’s a workaround which I’m not aware of, I’d love to know!
2 Likes
I’d love to see this too, essential for reporting, could be quite complex to setup though.
Not sure what data source you use, but if its mysql tables backend you could create something similar with queries in Noloco.
This one is a basic example showing year to date business for the past 3 years, we have some quite complex ones running % from previous periods and cash differences. We run by day/week/month/qtr/year to show how we are doing compared to to the same periods on past years.
Not ideal, as it does increase record count and admin tasks but it gets the job done.
SELECT
YEAR(l.signedupdate) AS year,
SUM(
IFNULL(l.pension_fee, 0) +
IFNULL(l.broker_fee, 0) +
IFNULL(l.comms, 0) +
IFNULL(l.commissionFee, 0) +
IFNULL(l.investment_fee, 0) +
IFNULL(l.conveyancing_fee, 0)
) AS ytd_total,
count (l.signedupdate) As Cases
FROM
mortga01_portal.tbl_lead l
WHERE
l.signedupdate >= DATE_FORMAT(DATE_SUB(CURDATE(), INTERVAL 2 YEAR), ‘%Y-01-01’)
AND l.signedupdate <= CURDATE()
AND DATE_FORMAT(l.signedupdate, ‘%m-%d’) <= DATE_FORMAT(CURDATE(), ‘%m-%d’) – Year-to-date filtering
GROUP BY
YEAR(l.signedupdate)
ORDER BY
year DESC;
This month to date compared to previous years month to date
Oh wow very interesting! This is what we are looking for but at the moment everything is stored on Noloco tables/ Google Sheets
You’ve given me an idea however so thanks!
You could definitely do all the complex stuff in Google sheets and sync it back.
ChatGPT has been a godsend on some of these queries, Id have never worked them out 
1 Like
