Hello,
I am attempting to add some colour blocks to a pivot table in an attempt to make the table easier to read. Here is an example (I throw this together in 1 minute)
My problem in doing this is that some fields in my table have a null value (blank cells), which results in unstyled gaps.
My question: Is it possible to add a ‘null’ value range to a legend using the maintenance app?
I see your point. The legend works if if the value is zero but it doesn’t work if it’s “null” as you mentioned.
No, but I’ll triage this to see what additional insights I might get… Thanks!
Hi @Gassim and @jamiecarter7 did you find out if it’s possible to highlight a blank cell? That would be really helpful.
@lnunez it is currently not possible to highlight a null field in a table using the legend options.
Noted, thank you!
Hi Gassim, thanks I have exactly the same question. I understand it is currently not possible. Has anybody opened a request for the roadmap or is there an open JIRA ticket?
My use case is to present stockouts (stock on hand = 0) but differentiate from items which are not stocked at all which are represented by blank fields.
In my case the “null” values are simply white (as all other values have colours assigned) which is quite a good work around actually.
