Visibility agent for a specific selection

I have tested a lot, unfortunately I also have no idea. Therefore, I am also interested in a possible solution ;)

Hi Michael,

The condition, less than 1.000€, is that for any individual month value? Or is it for the Total value?

And is it only '8000 ...' row that should be hidden? Or is it the full customer row that should be hidden?

And what about the Totals - should they be recalculated afterwards to reflect what is left visible?

Based on the already attached screenshot, can you make a mockup (maybe in Excel) that shows exactly what you want to achieve?

Best regards, Ole

Hi Ole,

the condition is meant for the monthly value. So if I am below a certain value (or vice versa) I don't want to see the value in the specific month column. The customer row should stay since the value changes over each month.

The totals should be recalculated. I think that is not hard as I can develop a calculation that only takes the visible elements into account and not simply all elements. My main issue is currently to get a conditional visibility for one specific cost type.

As an addendum would it be possible to add a condition that says "only show the cost centre when it is below or above a certain value ANd another cost centres has a value"?

Here is the requested Excel mockup

Kind regards

Michael

Hi Michael,

You can try with a visibility agent with this condition:

allcount(d1, all(c), m1) = 0 and allcount(d1, d1:0(s), m1) = 1 and value < 1000

Now, this will only work if cost type 8000 is always the first row for each customer.

Let me know if this will work, otherwise I may have another idea.

BR / Ole

Hi Ole,

thank you for the advice. I will try working with this for now but I might come back to it. Is there a documentary for the visibility agent and the possible conditions I can use for it? I usually only use very simple conditions for the agent and the one you suggested is "uncommon" for me

Kind regards,

Michael

Hi Michael,

Generally, visibility agents (and color agents) works with conditions that are evaluated as either "true" or "false".

The simplest version is the condition "1" that always evaluates as "true", and "0" that always evaluates as "false".

The slightly more advanced version is something like "value > 1000".

And going a step further, it could be something like "sum(d1, 0, m1) > 1000". Already here we have started using a (simple) calculation as part of the condition.

Breaking down my (complex) example:

• allcount(d1, all(c), m1) = 0. This part makes sure that the agent will only work on the lowest level of the dimensions on the vertical axis, because this is the level that have no children.
• allcount(d1, d1:0(s), m1) = 1. This part makes sure that the agent will only work on the first among siblings. In your screenshot, 8000 will always be sibling 1, while 8700 will always be sibling 2.
• value < 1000. This part makes sure that the agent will only work on values less than 1000.

All three parts, due to the and's, will need to be true for the whole statement to be true.

BR / Ole