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.