i am trying to create a horizontal bar chart that display the count of opened tickets in my front end system.
i receive the data from a database, where i run a query to provide me with the count of opened events and i group them based on the event types, hence my bar chart should display the type of the events and the count of each type.
the chart works well when i add a new type (label) along with its data, and works well when the number of count is updated, however i am facing an issue when label does not have any counts (the query in the database does not return the type since the count of it is zero) and the bar chart keeps on showing the last value of this type, it does not remove it nor change the count to 0.
is there is a way to solve this by making the bar chart only show what payload i provide to it?
i tried to send a empty array before updating but this looks really unprofessional because the chart keep on jittering with every update.
thanks in advance.
P.S.: i am not able to share my flow as its confidential.