
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.
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