Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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)
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)
@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)
This worked, thanks!