Video for version 2017
Working With Criteria
Exercise 1 (simple)
Exercise Analysis 2 (challenging)
Basic Analyzing Techniques
Drill Down Criteria
Create new analysis
The Criteria Bar
Formatting graphical objects
Labels and automatic coloring
As global criteria
From the criteria editor
From the criteria bar
Calculations and color agents
Customized color agents
Data Service ad-hoc data
Updating the source file
Tips and Tricks Videos
New Object Types
The Calculation Syntax
Create lists with hidden members
Customize the order of names
Create gauges in crosstabs
Create top lists based on numbers
Add new translation language
Dynamic Dates Definition
Dynamic criteria from the Criteria Editor
Open the Criteria Editor from Smartpad Criteria by clicking the “Add”” button.
With the Criteria Editor opened, we can now go directly to dynamic criteria by clicking the related button in the lower left corner of the dialogue box.
We will now see a large number of pre-defined dynamic criteria, depending on the structure of the time dimension.
Notice that the time dimension in TARGIT demo data contains a hierarchy with four levels: Year, Quarter, Month and Date. The same four levels are reflected in the options we are offered as pre-defined dynamic criteria.
Also, notice the text in parenthesis after each of the pre-defined dynamic criteria. The text tells us what we currently can expect from each criteria option, based on today’s date. The box Dynamic date origin is used for simulating another today’s date. When used, the results on the right hand side will change accordingly.
Let us try the Year-to-date option.
The dialogue box will then show us how this dynamic criterion has in fact been set up. You may even change these settings before applying the criterion.
If we just accept it as it is and click OK, we will get this result:
This result is based on Dynamic date origin set to July 7, 2015. Furthermore, in the bar chart, the time dimension has been expanded to the date level.
Courage to Act
© 2017 TARGIT. All Rights Reserved.