[New plugin] Beautiful Customizable Charts and Graphs (ApexCharts.js)

Let’s take the following situation:

  • I load the data and with the Do when… I add the series (Deleted the “Remove All Appended…” part) (Runs only once)

Everything appears correct and loads fast
(See Screenshot 1)

  • I change with a dropdown and instead of seeing it by date, I want to see it by offices.

The whole design goes down the drain.
(See Screenshot 2)

What could be happening?


When you append data series they are static and do not update when the data changes. As you have a filter dropdown to change the data of the chart you should leave your Do when… as it is as it runs only once. When a filter changes you need a separate workflow that removes all the appended series and append new ones with the correct data. Also, (not sure if this is true for your case, but) do not forget that your category series also need to change as otherwise the data will not match up.

It is hard for me to judge your situation from screenshots, if you need more help, please send me a PM here on the forum and share your editor link with editing capabilities so I can take a look :slight_smile:

Hello again, still loving this plugin!

I’m wondering if there is a way of highlighting a particular point on the x axis of an area chart through workflows instead of / in addition to clicking or hovering a point on the graph.

For example, when displaying the weather for each day of the week, there is an area graph that shows the temperature in degrees on the y axis, the days of the month on the x axis, and then based on the current date / time, one of the points along the x axis is selected / highlighted, in the same way it would be if you clicked on it or hovered over it.

Also wondering how the min and max are established for the 2nd y axis. how can i set the scale for this second y axis? Thank you

yes the comma separated option should work, but I don’t see that option in the element settings for either the donut or the pie chart

Hi @Thimo ,
I’m looking for a way to add annotations/labels to a chart based on dynamic values in the data. For example, I have a series where the Y axis is account balance and the X axis is months. Also included in the data is a “withdrawal_amount” field which is normally 0 except in months when a withdrawal occurs. Along with this there’s a “withdrawal_label” field which contains text describing the withdrawal.

There could be 0 to many withdrawal events in a given list, so I need some way to add a list of annotations/labels to the chart that occur at specific X/Y points.

Something like this (only one withdrawal in this example):

With the existing Add a Y Annotation action today you can only specify one or two annotations, and at specific Y points. This doesn’t always work because there could be multiple Y values that are the same in the line, but you only want to annotate a specific one.

Thanks!

This is not supported at this time.

The min and max boundaries were only supported for the main Y-axis, however I just pushed an update (6.107.0) for you that also adds that feature to the 2nd Y-axis! →

That is odd. Are you on the latest version of the plugin? As you can see in the screenshot, those fields should be there.

You can actually add unlimited annotations to the chart, and the start and end point can be dynamic. However, annotating a specific point is at this time not supported. I will need to investigate if that would be possible to implement!

Hi @Thimo

Is it possible to have a workflow action to remove a SINGLE appended data series? Currently the only option is to remove ALL of them.

This would allow users to be able to show and hide series to compare against eachother.

image

It works well with null items (after you get around Bubble deleting / collapsing nulls). Is it possible to have the number here show nothing? Maybe even hide the tooltip?

I can’t get the rotation to work. The automatic one works, but the manual one doesn’t.

Hi @rico.trevisan!

You could try to create a custom tooltip (see demo page for a custom tooltip example) that you make invisible (opacity = 0) for certain data points?

You have to enable both options as the first options enables rotation in general →

1 Like

@Atomily I just pushed an update (6.108.0) that adds a workflow action to remove a single appended data series for the bar and area charts! →

1 Like

You’re a legend! Works great

On the Gantt chart, is it possible to color individual entries based on the value of a field tied to that entry? For example, I have a field called Status that I’d like to use to conditionally color each bar (blue = on track, yellow = at risk, red = delayed, etc). Is this possible?

Thank you!

Hi @2706mason The colors can be set per series. Maybe you can use a data series by color in your case (blue = on track, yellow = at risk, red = delayed, etc). That way your gantt colors get represented by your color labels :slight_smile:

Unfortunately that won’t work as I have more states than allowable data series (which I believe is 4 or 5 for Gantt charts). I was hoping for some conditional formatting capabilities on the data series and/or titles. I may be able to accomplish something similar with a custom tool-tip that shows this information instead.

Hi @Thimo , I think there’s something wrong with Clear Annotations.

  • A line chart has an annotation
  • I update some data then run a workflow
  • Clear Annotations is run and the annotation disappears
  • New data is set for the chart via a custom state on the chart
  • The annotation reappears
    This happens in real time and when I step through it in Debug mode.

Not sure how I would manually update the plugin, says current version 5.0/5.0, but yeah those option for comma separated list are not visible to me on the pie chart or donut chart.

Thank you for this!

Any plans for this in the future?

Here you can see those comma separated fields are not visible to me:
Screenshot 2023-09-09 020946