Group Filter Template

Used to specify the filter that will be used when dynamically retrieving content. Use variables if you do not want to specify static column content.

Example: [<%Group%>]='<%GroupName%>'

Example: ([<%Group%>]='<%GroupName%>' AND [<%ChildGroup%>]='<%ChildGroupName%>')

<%ChildGroup%>

Used to identify the Child Group Name specified in the Group Column Name property.

<%ChildGroupName%>

As data is collected, this variable will be replaced with the content that is dynamically found. For instance, for each status, this variable will be replaced with each status, and analysis will be completed against the filtered content.

For external documentation about Expressions, see Add Column XML.

<%Group%>

Used to identify the Group Name specified in the Group Column Name property.

<%GroupName%>

As data is collected, this variable will be replaced with the content that is dynamically found. For instance, for each status, this variable will be replaced with each status, and analysis will be completed against the filtered content.

Supported Variables

•      %ME% – The currently logged in user

•      %Today% – Today's date

•      %CurrentWeekStart% – The first day in the current week

•      %CurrentWeekEnd% – The last day in the current week

•      %CurrentMonthStart% – The first day in the current month

•      %CurrentMonthEnd% – The last day in the current month

•      %CurrentYearStart% – The first day in the current year

•      %CurrentYearEnd% – The last day in the current year

•      %Quarter1Start% – The first day in the first quarter of the current year

•      %Quarter1End% – The last day in the first quarter of the current year

•      %Quarter2Start% – The first day in the second quarter of the current year

•      %Quarter2End% – The last day in the second quarter of the current year

•      %Quarter3Start% – The first day in the third quarter of the current year

•      %Quarter3End% – The last day in the third quarter of the current year

•      %Quarter4Start% – The first day in the fourth quarter of the current year

•      %Quarter4End% – The last day in the fourth quarter of the current year

•      %OneWeekAgoStart% – The first day of the previous week

•      %OneWeekAgoEnd% – The last day of the previous week

•      %TwoWeeksAgoStart% – The first day of the week before last

•      %TwoWeeksAgoEnd% – The last day of the week before last

•      %OneWeekFromNowStart% – The first day of next week

•      %OneWeekFromNowEnd% – The last day of next week

•      %TwoWeeksFromNowStart% – The first day of the week after next

•      %TwoWeeksFromNowEnd% – The last day of the week after next

•      %OneMonthAgoStart% – The first day of last month

•      %OneMonthAgoEnd% – The last day of last month

•      %OneMonthFromNowStart% – The first day of next month

•      %OneMonthFromNowEnd% – The last day of next month

Back to Top