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
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)
+12Hey
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)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
