Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
I have an issue for an already existing expression in a dashboard and the user informed that the expression is not displaying the values.I tried to verify the expression ,even though there is no error displayed, it does not give any values.
I was unable to find the error in the expression. Could anyone help?
The below expression should display the yellow highlighted in the box with correct values. But somehow it is not changing and remains at 0.
sum(if(
AGGR(
Sum({$<[Mosquito_Classification]={'Female.Ae.aegypti'},Mosquito_Species=, [Trap Status]={'Functional'}>}No_of_Mosquitoes)
/
count(distinct {$<[Trap Status] = {'Functional'},[Mosquito_Classification]=,Mosquito_Species=>}gravitrap_key),Sector_ID)
>$(vHighGAIThreshold),1,0))
/count(distinct {$<[$(=Concat({1<$Table-={'HDB_Dwelling','EHI Sector','GRC_Constituency','SLA','Vertex_KML','YishunTampines Release Site','YishunTampines SectorID'}>}distinct $Field,']=,[')&']=')>}Sector_ID)
sum(
AGGR(if(
(
Sum({$<[Mosquito_Classification]={'Female.Ae.aegypti'},Mosquito_Species=, [Trap Status]={'Functional'}>}No_of_Mosquitoes)
/
count(distinct {$<[Trap Status] = {'Functional'},[Mosquito_Classification]=,Mosquito_Species=>}gravitrap_key)
)
>$(vHighGAIThreshold),1,0)
,Sector_ID)
)
/
count(distinct
{$<[$(=Concat({1<$Table-={'HDB_Dwelling','EHI Sector','GRC_Constituency','SLA','Vertex_KML','YishunTampines Release Site','YishunTampines SectorID'}>}distinct $Field,']=,[')&']=')>}
Sector_ID)
sum(
AGGR(if(
(
Sum({$<[Mosquito_Classification]={'Female.Ae.aegypti'},Mosquito_Species=, [Trap Status]={'Functional'}>}No_of_Mosquitoes)
/
count(distinct {$<[Trap Status] = {'Functional'},[Mosquito_Classification]=,Mosquito_Species=>}gravitrap_key)
)
>$(vHighGAIThreshold),1,0)
,Sector_ID)
)
/
count(distinct
{$<[$(=Concat({1<$Table-={'HDB_Dwelling','EHI Sector','GRC_Constituency','SLA','Vertex_KML','YishunTampines Release Site','YishunTampines SectorID'}>}distinct $Field,']=,[')&']=')>}
Sector_ID)
Hi @vinieme12 ,
thanks. I suppose you have pasted the expression twice above. It seems to work.