topic Filters on years in Data Movement & Streaming

Filters on years

Stefan564 — Wed, 09 Apr 2025 12:57:54 GMT

Don't know if this is the right place to ask this, but i have a question about my filter. i have 2 different tabels in a dashboard that sort on year, my filter only works for 1 dataset, is there a way i can make it work for both?

If this is not the place to ask this, could you point me to the right direction?

Thanks in advance!

this is the filter with the code

And i want it to also work on

Re: Filters on years

marcus_sommer — Wed, 09 Apr 2025 16:14:17 GMT

You could reference a selection-state within an expression, for example:

sum({< Year2 = p(Year1) >} Value)

Re: Filters on years

BrandonFontes — Thu, 10 Apr 2025 11:52:35 GMT

Existem algumas formas:

Relacionar as tabelas para que funcione os filtros. Ou seja, você filtra uma tabela e ela relaciona na outra.
Criar uma LinkTable para relacionar as tabelas e usar o calendário para poder filtrar ambas as tabelas
Usar no objeto que você queira interagir o SetAnalysis para corresponder o filtro de ambas as tabelas.
1. Usar o filtro da Tabela 1 onde tem o campo Ano1
2. Tabela 1: Sum({< Year1 = p(Ano1) >} Value)
3. Tabela 2: Sum({< Year2 = p(Ano1) >} Value2)