Best practices: expressions or slices?

[Ms_Margo]

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!

[Marc_Dillon]

Generally, if you’ll need to re-use the same filtered set many times, then set up a slice for it.

[MultiTech]

Marc_Dillon:

if you’ll need to re-use the same filtered set many times, then set up a slice for it.

Agreed,

Grant_Stead:

has a really good explanation

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.

[Grant_Stead]

@MultiTech_Visions has a really good explanation on this that I shouldn’t try to reproduce. Maybe he’ll grace us with some words.