Apex chart - Line chart - Display 0 data

[lunomis]

Hi,

I’ve been using the apex chart plugin to display revenue, grouped by billing dates.
I want to display all months, even if there is no order, I want to display 0€.
The configuration works well for the multiple series area chart. I use an option set display all months.

For the line chart, even if I select “do not skip empty groups”, since the “series category” is based on the results, I don’t manage to display the empty values, so there are gaps between months.

Could you please help me get around this problem?

Best regards,
Luno

[mina.rotari]

Hi @lunomis ,

Thanks for reaching out!

To ensure your line chart displays all months, even when there’s no data, you’ll need to handle missing data manually. You can try the following approach:

1. Ensure the x-axis includes all the months you want to display, even if there’s no data. You can create a static list of all months or use a repeating group to generate them.

2. If the chart isn’t showing 0€ for missing months, you might need to adjust your data before sending it to the chart. Use a workflow to add 0€ entries where there’s no data.

3. If necessary, use chart options like “replace null” in the advanced settings to make sure the chart doesn’t skip or incorrectly connect empty values.
   

   

For more complex setups or additional guidance, I recommend checking out the Bubble forum where users discuss similar challenges with chart plugins.

Hope that helps!

Best regards,
Support Team
Browse all Zeroqode Plugins for bubble

[lunomis]

Dear @mina.rotari,

Thank you for your thorough reply. I’ll follow these steps and see if It works for me.

Have a great day

Best regards,
Luno

[mina.rotari]

Hi @lunomis,

Just wanted to check in — were you able to try the suggestions we shared for displaying all months in your line chart? Is everything working as expected now?

Best regards,
Support Team
Browse all Zeroqode Plugins for bubble