Waterfall Visualization Displays Blanks with Exact Variance of Category Can't Remove
Hi All, Running into an issue in creating a waterfall visualization. I'm trying to create a waterfall with a starting and ending EBITDA and the variance displayed as breakdown staking. However I'm running into an issue where random blank columns with the exact variance between the Category values appear. This makes the waterfall unusable and I can't understand what is going on. As you can see below blanks appear with the variance between the Category appear. I've set up the starting and ending EBITDA values and EBITDA drivers as seperate tables with a one to many relationship to the table that contains the variance values linked by driver name, I have the variance values as Y-Axis and the Category as EBIDA driver Breakdown as Non-EBITDA Those blank values do not exist anywhere in the tables and what is stranger is that when I remove the blanks via filtering the waterfall removes all data from the visualization. Or if I remove it for EBITDA for instance, only the blanks for driver are shown. I've been at this for several hours and cannot determine where I've gone wrong.
How to get a column with 0 value inside the table
Anonymous Under Column Incident Priority, there are mainly four values, 1-Critical, 2-High, 3-Moderate, 4-Low There are no critical incidents reported for the selected period. And hence when I drag this column into the table, it simply doesn't show 1-Critical. However, the client want to see all priorities regardless there is any incidents reported or not. I tried selecting option 'Show Items with no data' but that doesn't work. Does someone know any other option?
