LinkedIn
Twitter
Hello everyone,
I need help and guidance.
I have a table containing the main information.
The second table only has the months of the year for statistical purposes (counting the values from the main table).
In this table I need to count these values per month, however, with a third table performing the filter.
The count of all values per month is working, but I can't create a filter for the year.
I've tried several ways:
Directly on the field or with Slice, but nothing works.
See....
This table contais month to statistics:
And this are filter
On table BD_ESTATISTICA are 2 fields [QTD_PROC_TOTAIS_MES_ATIVOS] that on view is TOTAL ATIVOS MÊS and [QTD_PROC_TOTAIS_MES] that on view is TOTAL MÊS.
App formula on field [QTD_PROC_TOTAIS_MES]
IFS([_THISROW].[MES] = "TOTAL",
COUNT(BD_PROC_JUDICIAL[N_PROCESSO]),
[_THISROW].[MES] = "JANEIRO",
COUNT(SELECT(BD_PROC_JUDICIAL[N_PROCESSO],
[MES] = TEXT([DATA_EXPEDICAO], "MMMM"))),
[_THISROW].[MES] = "FEVEREIRO",
COUNT(SELECT(BD_PROC_JUDICIAL[N_PROCESSO],
[_THISROW].[MES] = TEXT([DATA_EXPEDICAO], "MMMM"))),
[_THISROW].[MES] = "MARÇO",
COUNT(SELECT(BD_PROC_JUDICIAL[N_PROCESSO],
[_THISROW].[MES] = TEXT([DATA_EXPEDICAO], "MMMM"))),
[_THISROW].[MES] = "ABRIL",
COUNT(SELECT(BD_PROC_JUDICIAL[N_PROCESSO],
[_THISROW].[MES] = TEXT([DATA_EXPEDICAO], "MMMM"))),
[_THISROW].[MES] = "MAIO",
COUNT(SELECT(BD_PROC_JUDICIAL[N_PROCESSO],
[_THISROW].[MES] = TEXT([DATA_EXPEDICAO], "MMMM"))),
[_THISROW].[MES] = "JUNHO",
COUNT(SELECT(BD_PROC_JUDICIAL[N_PROCESSO],
[_THISROW].[MES] = TEXT([DATA_EXPEDICAO], "MMMM"))),
[_THISROW].[MES] = "JULHO",
COUNT(SELECT(BD_PROC_JUDICIAL[N_PROCESSO],
[_THISROW].[MES] = TEXT([DATA_EXPEDICAO], "MMMM"))),
[_THISROW].[MES] = "AGOSTO",
COUNT(SELECT(BD_PROC_JUDICIAL[N_PROCESSO],
[_THISROW].[MES] = TEXT([DATA_EXPEDICAO], "MMMM"))),
[_THISROW].[MES] = "SETEMBRO",
COUNT(SELECT(BD_PROC_JUDICIAL[N_PROCESSO],
[_THISROW].[MES] = TEXT([DATA_EXPEDICAO], "MMMM"))),
[_THISROW].[MES] = "OUTUBRO",
COUNT(SELECT(BD_PROC_JUDICIAL[N_PROCESSO],
[_THISROW].[MES] = TEXT([DATA_EXPEDICAO], "MMMM"))),
[_THISROW].[MES] = "NOVEMBRO",
COUNT(SELECT(BD_PROC_JUDICIAL[N_PROCESSO],
[_THISROW].[MES] = TEXT([DATA_EXPEDICAO], "MMMM"))),
[_THISROW].[MES] = "DEZEMBRO",
COUNT(SELECT(BD_PROC_JUDICIAL[N_PROCESSO],
[_THISROW].[MES] = TEXT([DATA_EXPEDICAO], "MMMM")))
)
