Skip to main content

Hi all,

Thinking about a question I got. For a certain set of data, I need to show the lowest number for a given attribute for All resources. This is easy doable with an LOD fixed and MIN. However, then I need to show only the active resources only, BUT the LOD should stay the same, just filtering out the numbers of the not active . Normally, the LOD would recalculate, but I don't want it to, it should just filter out the non active resources.

 

I know this might sound a bit blurry and I haven't got real data yet as this was a question I got and was thinking how I should do it.

답변 4개
  1. 2025년 5월 22일 오전 11:37

    Hi @Inneke Beirnaert​ 

    Normally your LOD wouldn't change. Unless your filter is a context filter?

    So {FIXED [attribute]: MIN([number])} is going to be the same regardless of any normal dimension filtering on [status]='Active'. You'd need that filter added to context, or [status] added into the list of dimensions you're fixing by in order for it to affect the result of the FIXED LOD.

    I suspect I'm misunderstanding your question though, so please do post back! Some example data and expected output would definitely help.

    Ta, Steve