Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi community,
I have a issue.
I needed count "discharge id´s" excluding filter of date in a bar chart, because should count id´s inside the time interval, and id´s outside the time interval.
The functional say this:
“Filtered min date” <= SOLI_FEC_BEGIN <= “Filtered maxdate”
OR
“Filtered min date” <= SOLI_FEC_END <= “Filtered max date”
OR
(SOLI_FEC_BEGIN <= “Filtered min date” AND SOLI_FEC_END >= “Filtered min date”)
I create this expression, and works:
(count (DISTINCT{<Indicador= {'Disparos Intempestivos'}>} [Número Externo de Descargo])
+
count( DISTINCT{ <Indicador= {'Disparos Intempestivos'},[Fecha de Fin Descargo]={">=$(=MakeDate(Año,min(Mes),01))"}>*<Indicador= {'Disparos Intempestivos'},[Fecha de Fin Descargo]={"<=$(=MakeDate(Año,max(Mes),$(vUltimoDiaMaxMes)))"}>}[Número Externo de Descargo])
+
count( DISTINCT{1 <Indicador= {'Disparos Intempestivos'},[Fecha de Inicio Descargo]={"<=$(=MakeDate(Año,min(Mes),01))"}, [Fecha de Fin Descargo]={">=$(=MakeDate(Año,min(Mes),01))"}, AñoDesc=P(Año)>}[Número Externo de Descargo]))
OK.
The issue is next: I need show this id´s, with another fields, in a straight table, but I don´t know how exclude filters and show each id. Count yes, but show... I think that can show with aggr function, but I don´t know...
Help me, please.
Any idea? Help me, please.