# Period-over-Period Comparison in Dashboards

**URL:** <https://community.noloco.io/t/period-over-period-comparison-in-dashboards/1895>\
**Category:** Feature Requests\
**Created:** [April 30, 2025, 6:41am UTC](https://community.noloco.io/t/period-over-period-comparison-in-dashboards/1895 "2025-04-30T06:41:11Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![fluxomate](https://dub1.discourse-cdn.com/flex005/user_avatar/community.noloco.io/fluxomate/32/1288_2.png) [@fluxomate](https://community.noloco.io/u/fluxomate)\
**Post date:** [April 30, 2025, 6:41am UTC](https://community.noloco.io/t/period-over-period-comparison-in-dashboards/1895/1 "2025-04-30T06:41:11Z")

</div>

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:

 ![image](https://europe1.discourse-cdn.com/flex005/uploads/noloco/original/2X/7/707148795f2c6351c1d0bb935592b51890de969b.png)

AI Gen Mockup Example:

 ![ChatGPT Image Apr 30, 2025, 07_39_57 AM](https://europe1.discourse-cdn.com/flex005/uploads/noloco/original/2X/b/b1e277d8f7b5e1bd7cabfd0711c873dbf77fd64a.jpeg)

**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!

---

<div class="post-metadata">

**Author:** ![garyGHL](https://dub1.discourse-cdn.com/flex005/user_avatar/community.noloco.io/garyghl/32/555_2.png) [@garyGHL](https://community.noloco.io/u/garyGHL)\
**Post date:** [April 30, 2025, 8:33am UTC](https://community.noloco.io/t/period-over-period-comparison-in-dashboards/1895/2 "2025-04-30T08:33:16Z")

</div>

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;

 ![image](https://europe1.discourse-cdn.com/flex005/uploads/noloco/original/2X/9/9c8c26029c2851761c2104abb356c19542c3cacc.png)

This month to date compared to previous years month to date

 ![image](https://europe1.discourse-cdn.com/flex005/uploads/noloco/original/2X/8/80bbd14b98ba2f42688a058ec27f2707457dd868.png)

---

<div class="post-metadata">

**Author:** ![fluxomate](https://dub1.discourse-cdn.com/flex005/user_avatar/community.noloco.io/fluxomate/32/1288_2.png) [@fluxomate](https://community.noloco.io/u/fluxomate)\
**Post date:** [May 1, 2025, 1:51pm UTC](https://community.noloco.io/t/period-over-period-comparison-in-dashboards/1895/3 "2025-05-01T13:51:15Z")

</div>

> [@garyGHL](#):
>
> y/week/month/qtr/year to show how we are doing co

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!

---

<div class="post-metadata">

**Author:** ![garyGHL](https://dub1.discourse-cdn.com/flex005/user_avatar/community.noloco.io/garyghl/32/555_2.png) [@garyGHL](https://community.noloco.io/u/garyGHL)\
**Post date:** [May 1, 2025, 2:06pm UTC](https://community.noloco.io/t/period-over-period-comparison-in-dashboards/1895/4 "2025-05-01T14:06:19Z")

</div>

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 ☺