Skip to main content

Is there a way to filter from the view all metrics in 1 filter to exclude zero values from a table? 

If there is a table with a lot of data & we want to connect it to a gsheet, having many rows with zero values slow down things. 

Hi Marina,

You’re right, keeping unnecessary “0” is generating useless calculation in any system, including Pigment.
To solve this I suggest you to add at the end of the formula of the metrics on the table this expression:


It will filter the “0” from the result of the formula for each metric.

The best practices would be to remove those “0” at the source to prevent unnecessary calculations throughout your model thus improving overall performance. You can look on the import step is you can filter those “0” before loading data in Pigment. If not then you can use the expression above to filter the “0” as early as possible in your dependancy diagram, or after any step that might create new “0” (like allocation for example) and that’s it!

Hope this helps

Hi @Marina! Hope you had a good week - did Gawain’s guidance above help? :)

Reply


Ask your question here!

Terms & ConditionsCookie settings