1. TARGIT Community
  2. Community
  3. Frontend, Designer and Consumer

Visibility agent for a specific selection

Avatar
Michael Arens

Hello,

i have the following problem: I created a new crosstab which looks like this

Now I want to add a visibility agent that removes cost types when they are below a certain value (for example 1.000 €) This in itself isn't hard but I also want to use it for only one cost type (in this case cost type 8000 Umsatzerlöse) Is this possible? I haven't found an option for this in the visibility agent as I can only check for the general value. I tried to use user dimensions but if I try that I only get one of my cost types. Is the idea I want to use even possible? I am currently using the Controlling 2019

Kind regards

Michael

 

 

 

 

0

Comments

6 comments
Sort by Date Votes
  • Avatar
    Marlene Knaup

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

    0
  • Avatar
    Ole Dyring

    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

    0
  • Avatar
    Michael Arens

    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

    0
  • Avatar
    Ole Dyring

    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

    0
  • Avatar
    Michael Arens

    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

    0
  • Avatar
    Ole Dyring
    (Edited )

    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

    0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post