Data Visualisation Options

Ask for Help
1

Hey everyone! :waving_hand:

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! :folded_hands:

2

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

3

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

4

Thank you guys will check it out!