Dynamic criteria from the Criteria Bar

You can add global, dynamic criteria directly from the Criteria Bar. First, you will have to add the time dimension to the Criteria Bar, if not already present. Select “Use dynamic periods” when you right-click the Time dimension in the Criteria Bar.


Now, if you open the drop down list from the time dimension in the Criteria Bar you will see all the pre-defined dynamic options – identical to what we saw in the Criteria Editor.


If we pick Previous month from the list, the bar chart will show data of the previous month (screen shot below is based Dynamic date origin set to October 2016).


If you want a handy way to change the Dynamic date origin, you can add it to the Criteria Bar so that it will always be visible while working with the analysis. Right-click somewhere on the Criteria Bar and select “Add dynamic date origin”.


Was this article helpful?
0 out of 0 found this helpful



Please sign in to leave a comment.