topic Re: Filtering in Dimension in App Development

Filtering in Dimension

ClareChinonye — Wed, 10 Jan 2024 09:26:39 GMT

i wrote this set expression in my dimension to filter out the following substatus names from my chart, but i keep getting invalid dimension

={<SubStatusName -= {'Booked On', 'End of Day, Run Complete', 'Shift Change', 'Startup Checks'}>},

and this

=Sum({<SubStatusName -= {'Booked On', 'End of Day', 'Run Complete', 'Shift Change', 'Startup Checks'}>} TimeInMinutes)

for the measure. the measure works for other charts, but the dimension says invalid

please what could i be doing wrong in the dimension?

Re: Filtering in Dimension

Parthiban — Wed, 10 Jan 2024 09:43:11 GMT

Hi,

Try this in your dimension,

if(SubStatusName<>'Booked On' and SubStatusName<>'End of Day' and SubStatusName<>'Run Complete' and SubStatusName<>'Shift Change' and SubStatusName<>'Startup Checks',SubStatusName)

Re: Filtering in Dimension

Anil_Babu_Samineni — Wed, 10 Jan 2024 13:52:50 GMT

@ClareChinonye For dimension you can do like this

=Aggr(Sum(If(Not Wildmatch(SubStatusName, 'Booked On', 'End of Day', 'Run Complete', 'Shift Change', 'Startup Checks'), TimeInMinutes), SubStatusName)

Re: Filtering in Dimension

ClareChinonye — Wed, 10 Jan 2024 14:15:57 GMT

This worked, thanks!