Solved

Measuring the size of an application

  • 14 September 2023
  • 2 replies
  • 75 views

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

icon

Best answer by Nathan 15 September 2023, 09:28

View original

2 replies

Userlevel 6
Badge +12

Hey
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 (gopigment.com)

Userlevel 1
Badge +2

Many thanks Nathan!

Reply