# Data Visualisation Options

**URL:** <https://community.noloco.io/t/data-visualisation-options/2000>\
**Category:** Ask for Help\
**Created:** [June 22, 2025, 12:35pm UTC](https://community.noloco.io/t/data-visualisation-options/2000 "2025-06-22T12:35:28Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Oscar](https://avatars.discourse-cdn.com/v4/letter/o/22d042/32.png) [@Oscar](https://community.noloco.io/u/Oscar)\
**Post date:** [June 22, 2025, 12:35pm UTC](https://community.noloco.io/t/data-visualisation-options/2000/1 "2025-06-22T12:35:28Z")

</div>

Hey everyone! 👋

I’m hitting some limitations with Noloco’s current features for building a proper KPI dashboard:

**Current Issues:**

- KPI highlight **size restrictions** (can’t make them prominent enough)
- **Text size limitations**
- **Chart color options** are very limiting
- **No % change from previous month** functionality
- Overall lack of customization for dashboard aesthetics

## My Question:

Are you sticking with **Noloco’s native features** for dashboards, or are you **going external**?

If external - **what software are you using?**

**Just wondering if anyone has a solution for this?**

Any **recommended setups** using external tools that embed well via iframe? What’s working for you?

_(Nothing against Noloco - love the platform! Just exploring all options for this specific use case)_

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:** [June 23, 2025, 8:28am UTC](https://community.noloco.io/t/data-visualisation-options/2000/2 "2025-06-23T08:28:15Z")

</div>

We use mysql backend, so I can work around some of these limitations by using queries for more complex data such as your point above regarding % changes, it works well for our needs. (quick example below)

Never have managed to work out the css for chart colours but I agree it is much needed to keep on brand.

I have used Zoho Analytics previously which is great but never tried embedding into Noloco.

Shows current month to date (23/06/25) compared to same period in previous years (23/06/24 etc etc)

> SELECT  
> FLOOR(RAND() \* 1000000) AS ghlid,  
> ‘This Month’ AS period,  
> SUM(CASE WHEN YEAR(Compdate) = YEAR(CURDATE())  
> AND MONTH(Compdate) = MONTH(CURDATE())  
> AND DAY(Compdate) \<= DAY(CURDATE()) THEN IFNULL(pension\_fee,0) + IFNULL(broker\_fee,0) + IFNULL(comms,0) + IFNULL(commissionFee,0) + IFNULL(investment\_fee,0) + IFNULL(conveyancing\_fee,0) ELSE 0 END) AS Fees,
> 
> ```
> COUNT(CASE WHEN YEAR(Compdate) = YEAR(CURDATE()) 
> AND MONTH(Compdate) = MONTH(CURDATE()) 
> AND DAY(Compdate) <= DAY(CURDATE()) THEN 1 END) AS count_value
> 
> ```
> 
> FROM tbl\_lead  
> UNION ALL  
> SELECT  
> FLOOR(RAND() \* 1000000) AS ghlid,  
> ‘Last Year’ AS period,  
> SUM(CASE WHEN YEAR(Compdate) = YEAR(CURDATE()) - 1  
> AND MONTH(Compdate) = MONTH(CURDATE())  
> AND DAY(Compdate) \<= DAY(CURDATE()) THEN IFNULL(pension\_fee,0) + IFNULL(broker\_fee,0) + IFNULL(comms,0) + IFNULL(commissionFee,0) + IFNULL(investment\_fee,0) + IFNULL(conveyancing\_fee,0) ELSE 0 END) AS Fees,  
> COUNT(CASE WHEN YEAR(Compdate) = YEAR(CURDATE()) - 1  
> AND MONTH(Compdate) = MONTH(CURDATE())  
> AND DAY(Compdate) \<= DAY(CURDATE()) THEN 1 END) AS count\_value  
> FROM tbl\_lead  
> UNION ALL  
> SELECT  
> FLOOR(RAND() \* 1000000) AS ghlid,  
> ‘2 years ago’ AS period,  
> SUM(CASE WHEN YEAR(Compdate) = YEAR(CURDATE()) - 2  
> AND MONTH(Compdate) = MONTH(CURDATE())  
> AND DAY(Compdate) \<= DAY(CURDATE()) THEN IFNULL(pension\_fee,0) + IFNULL(broker\_fee,0) + IFNULL(comms,0) + IFNULL(commissionFee,0) + IFNULL(investment\_fee,0) + IFNULL(conveyancing\_fee,0) ELSE 0 END) AS Fees,  
> COUNT(CASE WHEN YEAR(Compdate) = YEAR(CURDATE()) - 2  
> AND MONTH(Compdate) = MONTH(CURDATE())  
> AND DAY(Compdate) \<= DAY(CURDATE()) THEN 1 END) AS count\_value  
> FROM tbl\_lead

---

<div class="post-metadata">

**Author:** ![Pablo10](https://avatars.discourse-cdn.com/v4/letter/p/779978/32.png) [@Pablo10](https://community.noloco.io/u/Pablo10)\
**Post date:** [June 24, 2025, 10:53am UTC](https://community.noloco.io/t/data-visualisation-options/2000/3 "2025-06-24T10:53:24Z")

</div>

> [@garyGHL](#):
>
> Zoho Analytics

FYI

Queries and charting in Google sheets work well with embedding back into Noloco

I have also used Zoho Analytics and embed very successfully into Noloco

---

<div class="post-metadata">

**Author:** ![Oscar](https://avatars.discourse-cdn.com/v4/letter/o/22d042/32.png) [@Oscar](https://community.noloco.io/u/Oscar)\
**Post date:** [June 24, 2025, 12:00pm UTC](https://community.noloco.io/t/data-visualisation-options/2000/4 "2025-06-24T12:00:48Z")

</div>

Thank you guys will check it out!