Ideally in the metrics we could remove 0 metric values if it is ok with the analysis to remove those cells
[FILTER: Currentvalue<>0]
Also usually we add the “Hide empty rows and columns” - but is there possible to remove those empty cells by formula? Or does it give something regarding performance wise?
Question
Remove not Filter Blank cells?
- Apprentice Author
- Employee
Hi Krete,
At the moment, Pigment does not support removing empty cells using a formula. The FILTER function can be used to filter out certain values, but it does not remove cells. The Hide empty rows and columns feature is the best way to manage the visibility of empty cells in Pigment.
As for performance, it's important to note that Pigment performs better with sparse data. Therefore, having empty cells (as opposed to filling them with zeros or other values) can actually improve performance as blank is not a value.
I hope this helps ! 🙂
Please, let us know in case of any further questions!
Log into the Pigment Community
No account yet? Create an account
Single Sign-On Need help?
Log in with your Pigment accountEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.