I am facing an issue with the Waterfall Chart Widget where, in my InfoTable, I have 13 different fields, and while not all fields have corresponding values in the xx axis, I would like all the changes in all the fields to be accounted for in the final bar (Total). However, the total is only taking into account the first field of the InfoTable, despite showing the variations across the other fields in the chart correctly. I attached a picture of this issue.
Is there something I could be doing wrong or should I manipulate the InfoTable in some other way?
Can you export your infotable with data so we can take a look at it? We need to see what you data looks like.
I apologize, I should have posted the InfoTable in the original post. Here it is attached,
EDIT: I actually added a new Field to the InfoTable since I first created this post so attached is the updated Waterfall Chart as well.
Hi @MP_10287512 ,
I noticed in your infotable that you have many undefined values. For example, the values for "Gobs Cut" in S1-S12 are all undefined. Try setting values like these to zero for all rows, except for the final "Lehr In" row. Let me know if the chart works as expected after making this change.