I’m using the Apex Charts [paid] plugin, and I’m trying to figure out how I would be able to connect the series lines over an area where there is no data. I have two screengrabs, the second is basically what I’d need it to do, just with solid lines rather than dotted lines.
How would I go about doing that? I’m sure there has to be a way – it’s part of why I got the plugin.
Which one are you using?
Also, can you share what you have set for data source?
The plugin is linked below. And the data source is a database in Bubble made from uploaded CSVs of daily reports. Every day has each shift, whether they worked or not, and if they didn’t work, it’s just a blank field. Apex Charts defaults it to have null/undefined displayed as 0, which then takes those spaces and drops them to the X-Axis line rather than connecting them across the spaces.
The X-Axis is the day of the month, the Y-Axis is a production metric achieved for the day per shift.
If you look at the bottom of available settings, you can use options to replace null values. I guess for your case you want to use replace with previous
I’ve tried that, it’s not what we want. That adds values to the spaces that should be without values, which then would make it look like there was production for those shifts on those days. I’m thinking I might have to go with a different plugin, unfortunately
What do you want to show? Previous should do what you was expecting to join both line no? You cannot have a 0 value and expect the line chart to join both line like if there was something and show 0… this just doesn’t make sense (however, in this plugin you can customize tooltip… so this is possible maybe…)!
So you need to choose between having an empty line, show a real value of 0 or show previous value. I don’t think another chart plugins will be different…
From what I can see, there is another plugin that has a connected scatter chart that would allow it to do what I want. I just won’t have the Target annotation line, which sucks. But it is completely doable in something like Excel, so it doesn’t make sense that you can’t do it in these plugins.
As for using the previous, it doesn’t just connect the lines, it adds a value where there wasn’t one. We can’t have that.
Here is the screen grab of the demo from the other plugin that uses a connected scatter. You can see there isn’t data for every day, but it connects across the gaps.
You can always ask ZQ to see if this is an available option.
If both use the same library (APEX), there’s no reason for that do not be available.
Hi @crumberger ,
Thanks for posting on the forum! Just to let you know, I’ve already replied to your query via email with a detailed solution. Please check your inbox, and feel free to reach out if you have any further questions or need additional clarification.
Looking forward to hearing from you!
Best regards,
Support Team
Browse all Zeroqode Plugins for Bubble
Thank you, @ZeroqodeSupport . I did get the email. It doesn’t look like there is a viable option to display the data the way we need based on your response.
It would either need to be that the line chart had the function to smoothly and consistently connect across those null values without needing to replace them, or that the Scatter Chart had the option to connect the entries across a series like the ChartJS plugin from TechBlocks.
Hi @crumberger ,
Thank you for sharing your insights on this.
We completely understand your concern regarding the display of interpolated values for days without production. We will definitely forward this feedback to our development team for consideration. If any updates or changes are made regarding this functionality, we’ll be sure to keep you posted.
We appreciate your input and are here to help if you need anything further. Thanks again for being part of the conversation!
Best regards,
Support Team
Browse all Zeroqode Plugins for Bubble
