Services Plugins FAQs

🔍 Help with AirChart Pro - Alignment of data series/categories

Help Needed
#1

:mag: Help with AirChart Pro - Alignment of data series/categories

:bar_chart: Context Creating a bar chart showing the number of invoices by status for each establishment, filtered by the connected user’s brands. The data between categories and my group by don’t match so there’s a mismatch… I don’t know how to make this kind of graph and I’m completely stuck… Maybe another way to make queries and link everything…

I made a vocabulary index for a better understanding french to english.

Here’s how it looks:

:memo: DB Structure • Invoices Table → Client Status (“To verify”, “Validated”, “Paid”) → Relationship with Establishment

• User Table (Office) → Multiple relationship with Brand table

• Establishment Table → Name (text)

• Brand Table → Name → List of establishments (multiple relationship)

:dart: Graph Objective

  • X Axis: List of establishments
  • Y Axis: Number of invoices
  • 3 series by status

:gear: Current Configuration Series Category:

current user brand list establishment list’s establishment name (text list)

Series 1:

Search for invoice constraint: brand constraint: registered Grouped by establishment Count aggregation

Series 2 & 3: Same with status change in the constraints

:x: Problem See screenshots:
• Graph: misaligned data •
Inspector: data present but wrong matching

:question: Questions

How to properly align data/categories? Better structure for groupings?

:memo: Notes •
Plugin: AirChart Pro •
DB truncated for example •
Screenshots = test data

Thanks in advance for your help

:books: Index Vocabulaire Français → English

Base de données / Database:

  • Facture → Invoice
  • Établissement → Establishment
  • Marque → Brand
  • Utilisateur → User

Statuts / Status:

  • Ă€ vĂ©rifier → To verify

  • ValidĂ© → Validated

  • RĂ©glĂ© → Paid

  • EnregistrĂ© → Registered

  • Liste → List

  • Relation → Relationship

  • Relation multiple → Multiple relationship

  • Contrainte → Constraint

  • GroupĂ© par → Grouped by

  • AgrĂ©gation → Aggregation

  • Nombre → Count

  • Graphique en barres → Bar chart

  • Axe → Axis

  • SĂ©rie → Series

  • CatĂ©gorie → Category

  • Liste de marques → Brand list

  • Nom Ă©tablissement → Establishment name

  • Liste de texte → Text list

  • Rechercher → Search for

  • Utilisateur actuel → Current user

Capture d'Ă©cran 2025-01-29 202030
Capture d'Ă©cran 2025-01-29 2020301572Ă—913 82.8 KB

Uploading: Capture d’écran 2025-01-29 190957.png…
Capture d'Ă©cran 2025-01-29 145608
Capture d'Ă©cran 2025-01-29 145608751Ă—382 7.27 KB

Capture d'Ă©cran 2025-01-29 143610
Capture d'Ă©cran 2025-01-29 1436101707Ă—1035 79.6 KB

#2

Hello @pierre.pluton,

Thanks for reaching out to us.

I see from your message that you’ve described your use case in detail. However, it’s still not entirely clear what the specific issue is—you mentioned that the dates between your categories and series don’t match- is my understanding correct?

To answer your questions, we first need to clarify how the plugin works. The “Series data” and “Categories” are default Bubble fields that expect a list of numbers (for series) or texts (for categories)—essentially arrays (e.g., series1: [a1, a2, a3…], categories: [c1, c2, c3…]). The plugin simply uses these arrays to display them on the chart without altering the data in any way.

Please try adding a simple text element that uses the same expression as the series field in the chart. You should see the same result, confirming that the plugin is just displaying the data it receives.

We at Zeroqode support can provide general advice and fix any potential bugs, but we unfortunately cannot do custom in-app modifications.

Thanks for understanding, and if you have any other specific questions, please let me know.

Best regards,
Support Team
Browse all Zeroqode Plugins for Bubble
Banner_Last3