topic Re: Making Status as a Filter in App Development

Making Status as a Filter

Raju_6952 — Tue, 20 Feb 2024 18:30:18 GMT

Hi,

I am using =Count (DISTINCT IncidentID) > 0, 'True', 'False') to find the status of it.but I need to set it as Dimension filter to make the selections.

Thanks in advance.

Re: Making Status as a Filter

BrunPierre — Tue, 20 Feb 2024 19:21:11 GMT

Like this

=If(Aggr(Count(DISTINCT IncidentID), IncidentID) > 0, 'True', 'False')

Re: Making Status as a Filter

LRuCelver — Wed, 21 Feb 2024 07:23:46 GMT

If you need to evaluate for another dimension whether IncidentIDs exist, you can use

=Aggr(If(Count(DISTINCT IncidentID) > 0, 'True', 'False'), YourDimension)

to apply a filter to your dimension for all values that do or don't have IncidentIDs.

Re: Making Status as a Filter

stevedark — Wed, 21 Feb 2024 08:04:37 GMT

Hi @Raju_6952

Aggr works for this, but for performance you really want to do this in the load script.

If you just add a new field to the load of your Incident table you can have a filter with just yes:

Incident:
LOAD
IncidentID,
'Yes' as [Has Incident],

If you need to know if a particular site has an incident or not, and you want to have Yes/No filters you can do this with an ApplyMap statement. Assuming you have loaded an Incident table, which has ClientID, ahead of your Site table:

Map_HasIncident:
MAPPING LOAD DISTINCT
ClientID,
'Yes' as Incident
RESIDENT Incident;

Site:
LOAD
SiteID,
ApplyMap('Map_HasIncident', SiteID, 'No') as [Site Has Incident],

Your users will thank you for pre-calculating this in the load, rather than having to evaluate it at run time for a filter pane.

Hope that helps,

Steve

Re: Making Status as a Filter

Raju_6952 — Mon, 26 Feb 2024 12:16:36 GMT

Hi,

=Aggr(If(Count(DISTINCT IncidentID) > 0, 'True', 'False'), YourDimension)

The above formula is working. Thanks for the replies.

Kind regards,

Raju