Measuring the size of an application

  • 14 September 2023
  • 2 replies

Userlevel 1
Badge +2

Hello here!

I hope that you are well.

Please, is there a way to evaluate the size of an application (like Mb for excel) or the number of calculations made in a Metrics? 

Sometimes, the calculations take time and I would like to know from where I can remove complexity/heaviness.


Many thanks


Best answer by Nathan 15 September 2023, 09:28

View original

2 replies

Userlevel 6
Badge +12

you can use COUNTOF(metric) to know how many cells there is.

Pigment being a sparse engine, it is important to not fill more cells than there actually is.
For example the classic ISDEFINED(metric, result, 0) is a problem, filling every empty cell with 0


See some principles here

Top Tips for modeling in Pigment - Part 2: Performance Optimisation | Community (

Userlevel 1
Badge +2

Many thanks Nathan!