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
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.
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.
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! →
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!
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?
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?
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
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.
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.