Dynamic content if no values
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
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. :)