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

Dynamic content if no values

Bo Steinbeck ·

Is it possible to create dynamic content on user measures that has no values?

I have a situation where I would like to create a chart that shows me all 4 quarters of a year regardless there are no values yet.

The Dynamic content works for the quarters with values, if I don't include empty members. 
If I do include empty members, i just get the first year i my period table, for all four quarters.

 

I have added the criteria Year to previous month, because values for current month are not valid.
But if i remove this criteria, is it then possible to add a period criteria for one measure only? I have actual and budget values. If so this would solve my problem.

The Actual GMS for Q2 should not be shown, since we are still in April.

 

0

Comments

1 comment
Sort by DateVotes
  • Bo Steinbeck

    Ok. Sorted it myself:

    I know that my revenue for actual month has a positive value until the period end processes has been completed, so i made a criteria in visibility agent that if the revenue value is positive, is has to hide the Actual GMS % value.

    If anyone has a solution where I do not have to assume something about values, please let me know. I would like to use the dynamic time as a criteria if possible.

    EDIT: let's see if the rule applies when we enter the third month of the quarter. :)

     

    0
Please sign in to leave a comment.