Pie chart assistance

Need help App Organization
1

Hi everyone,

I’m trying to set up a native Bubble Pie Chart on a dashboard, but I’m finding the setup confusing and could use some advice.

Here’s what I’m trying to do:

  • I have a Certificate data type.
  • Each Certificate has an Expiry Date field (type: date).
  • I want the Pie Chart to show:
    • Certificates expiring in under 1 month (RED slice)
    • Certificates expiring in under 3 months (YELLOW slice)
    • Certificates expiring after 3 months (GREEN slice)

Basically:

  • <1 month = Critical
  • <3 months = Warning
  • >3 months = Safe

My challenge:
I’m not sure how to build the data source list properly to show these 3 categories using the native Bubble Pie Chart.
I know I’ll need to count certificates based on how close their Expiry Date is to the Current Date, but struggling with how to write this logic in Bubble’s data source field.

Has anyone set up something similar?
Would love a simple breakdown or example if possible!

Thanks so much! :folded_hands:
(Happy to clarify more if needed.)

2

I am sure you have set-up the certificate data type in the DB to collect those info which will obviously have a field storing the expiry date…

haven’t done that, one of the ways you can use to achieve your aim is, get the “counts” of the certificate with expiry date under 1, 3 and after 3month(s) respectively and populate it in the chart…

that’s lemme know if my explanation ain’t ambiguous