Hey team -
When I add a new dimension - my whole chart is grayed out. This is due to the conditional formatting from the sum(cumulative net bias) dimension - but when I add ScrollIndex(which is an index()) function, the chart is grayed out because its counting the missing values as 0 (which is considered grey in my conditional format). Without the ScrollIndex dimension - the chart is normal with now. Please see pictures attached
Pre - ScrollIndex Dimension
Post ScrollIndex Dimension
How do I add the ScrollIndex dimension but not grey out the cells? Thanks!
1 answer
