Is it possible that the interactive bar chart node has a bug?
I’m plotting the returned quantities from several customer (category) filtered by year.
Everythings is ok if I select a view where all years are selected, if I select the data visualization on the interactive bar chart by single year, there are no corrispondence between the category on the x-axis and the real Bar data: i.e. on the x-axis in corrispondence of the customer “A” there is the bar corresponding to returned quantitie in the selected year of customer “D”.
Is it a bug or a my error?
Many thanks for any kind explanation.
Hello @Guglielmo -
I’m having a hard time understanding the problem based on your description. Could you upload a small workflow and dataset that shows what you’ve tried so far, and add some screenshots highlighting what you think is wrong?
I understand that it is difficult to understand especially with my very bad English! I’m sorry but I cannot share dataset and relative workflow as there are confidential data and informations of my company, by the way I built a simplified picture that describe the problem, see below.
I experience this problem with all the bar charts I generated.
The view is correct for the year 2019, but moving to 2020, 2021 tec. the views are not correct.
So if I understand you correctly, when you deselect categories for your bar chart in the legend that correspond to calendar years, the mouseover value shown for the classes is incorrect.
I’m not able to reproduce this on my side, so I can’t tell yet if this is a bug or something specific to your own configuration. For example, as best I can tell, this is all correct:
Is it possible for you to upload a workflow example using some fake data that would reliably recreate the problem?
I’ll try to recreate the situation with some fake data. Thank you for your kind attention and reply.
I individuate the problem, it stays in the data set!!!
The data set generated trough data cleaning and pivoting is constituted by row where there are some missing value. In that case deselect categories for the bar chart in the legend that correspond to calendar years, the mouseover value shown for the classes is incorrect.
If I substitute the missing value with “zero” the bar chart work well! I don’t fully understand why but it seems to be the problem.
Test_BarChart.knwf (16.0 KB)
This is a simple workflow that show the issue.
Sounds like missing values are not being handled properly then? Interesting.
Can you either 1) repost the sample WF in an executed state or 2) post the Excel spreadsheet? Right now I can’t actually execute the nodes in your WF since I don’t have the file.
here I’ll try to resend the workflow in the executed state.
Test_BarChart.knwf (61.6 KB)
Here below you’ll find also the two excel files used for testing bar chart: “Prova” contain the missing values and “Prova1” are the same where missing values has been substitute with “zero”.
prova.xlsx (8.8 KB)
prova1.xlsx (10.7 KB)
Actually I’ll tested the bar-chart node both in “group” and “stacked” configuration and the above reported issue happen only in the group configuration.
Hi @Guglielmo -
Thanks for your patience and for uploading the WF and files. I see the issue now with the labeling of the class when missing values are present (for example, A34 is not A10!)
This definitely seems like a bug and I will bring it to the attention of the dev team. In the meantime, it seems that you have already found a workaround by setting your missing values to zero, which is a good idea in this situation anyway
Thanks again for your feedback!
Update: ticket created (AP-19009) for future reference
Are you fixing the bug?
Not yet - for the moment I was just updating the thread with the ticket number. It will be up to the development team to determine when/if this gets implemented in a future release. If there’s an update we’ll share it here.