Hi All -
TL;DR - are there any guides / best practices on when to use expressions vs slices?
I have seen a few ways to filter a reference but wondering which method is best for apps. For this example, we can focus on active vs inactive employees.
Method one: Make a slice and then build a reference off the slice.
Method two: Updated the tables Valid_id expression to filter: FILTER(“team”,([status]=“Yes”)
Pretty sure you can also do this with the select expression but either way - are there any general hygiene or best practices when picking a method?
Thanks!
Generally, if you’ll need to re-use the same filtered set many times, then set up a slice for it.
Agreed,
Not sure to what you’re referring there @Grant_Stead? Marc nailed it; it’s all about not having to redo calculations if you don’t have to, or limiting calculations for other formulas.
@MultiTech_Visions has a really good explanation on this that I shouldn’t try to reproduce. Maybe he’ll grace us with some words.
User | Count |
---|---|
44 | |
31 | |
29 | |
14 | |
14 |