|800|Edit View|

@Name

@Name
|801|apply changes| |7660|save changes|
|803|Layout| |804|Filters| |805|Settings| |32823|Pivot|

|28905|Graph Options|

|25957|Refresh|
|40660|Use a calculated field|
|25168|X Axis|
@XAisInnerText

|40660|Use a calculated field|
|25169|Y Axis|
@YAxisInnerText
|40660|Use a calculated field|
|25170|Series|
@SeriesInnerText

{{:dp@searchError}}

|39341|Groups|

|807|group| |39342|calculated group|
|806|Add a grouping to your report to create subtotals for a specific group. This does not combine rows together, but creates a visual heirachy|
{{:item.name}}{{if:u.obn(item.calculated)}}{{if:}} @dataTypeLabel @innerText

|39344|Columns|

|811|column| |2185|calculated column| |7661|Locked Columns|
|810|Add a column to your report. If you group rows together, there will be one unique row for each combination of columns that has the group by option set on it.|
{{:item.name}}{{if:u.obn(item.calculated)}}{{if:}} @displayHeading @sortLabel @sortOrder:i {{if:item.dataType === 'string'}} @wordWrap:yesno {{if:}} {{if:item.dataType === 'string'}} {{if:}} @dataTypeLabel @innerText @groupByLabel

|25958|Metrics|

|38266|metric| |25959|add a calculated metric|
|38267|Add a column to your Key Metrics table.|
{{:item.name}}{{if:u.obn(item.calculated)}}{{if:}} @displayHeading {{:u.obs(item.groupByLabel)}}

|39345|Before grouping rows together|

|0|Add a filter|

|0|Filter| |25171|calculated filter|
|25961|These filters are applied to every row of data. Typically these would be things like date range filters or for specific project types.
{{:format(item.leftParenthesis)}} {{:item.name}} {{:item.conditionName}}{{if:u.obn(item.calculated)}}{{if:}} @prompt:checkbox ( @prompt=='1'? @promptText: @values == 2 ? format( @parameter1, @dataType === 'DateTime' ? 'd' : @dataType === 'Date' ? 'd' :'s') + ' - ' + format( @parameter2, @dataType === 'DateTime' ? 'd' : @dataType === 'Date' ? 'd' : 's') : @conditionName === 'Any Of' ? format( @parameter1, 'selectlist') : format( @parameter1, @dataType === 'DateTime' ? 'd' : @dataType === 'Date' ? 'd' : 's') ) {{:format(item.rightParenthesis)}} {{:format(item.andOrLabel)}}

|39346|After grouping rows together|

|25171|calculated filter|
|25962|These filters are applied after the main query completes so you can remove rows after the detail has been summed. These filters would typically be used to remove rows where the total is equal to 0. You may only use fields in the main query.|
{{:format(item.leftParenthesis)}} {{:item.name}} {{:item.conditionName}}{{if:u.obn(item.calculated)}}{{if:}} @prompt:checkbox ( @prompt=='1'? @promptText: @values == 2 ? format( @parameter1, @dataType === 'DateTime' ? 'd' : 's') + ' - ' + format( @parameter2, @dataType === 'DateTime' ? 'd' : 's') : @conditionName === 'Any Of' ? format( @parameter1, 'selectlist') : format( @parameter1, @dataType === 'DateTime' ? 'd' : 's') ) {{:format(item.rightParenthesis)}} {{:format(item.andOrLabel)}}
@dataset
@LastModified:D
@apiKey
|39347|Copy to Clipboard|
|829|If you make a view private, only the selected Owner will be able to view it|

|830|Visible To|

|831|No groups have access to this view|
|848|Security Groups|
  1. {{:item.GroupName}}
|42295|People|
  1. {{:item.DisplayName}}
@dataset
|26876|Using these options can set a visual target that you are looking to measure against on your graph.|
|26878|Add a descriptive label below the X axis|
|26880|Add a descriptive label to the left of the Y axis|
@LastModified:D

|830|Visible To|

|38268|No groups have access to this graph|
  1. {{:item.GroupName}}
|32824|Click a field to add it to the Rows, Columns, or Values area to build the pivot. Only fields added on the Layout tab (Columns and Groups) are available here.|

|850|Calculated Field|

|39348|Field Definition|

|25175|Checking this box will cause this calculation to happen after the main query which allows you to do formulas on the results. You can then calculate percentages of totaled values. You can only use field names that are in the query currently as either grouping fields or the columns.|
|853|Save| |854|Cancel|

|855|Available Fields|

|856|Click on a field to add it to the calculation|
  1. {{:item.name}}
  1. {{:item.name}}

|38270|Calculated Metric|

|39349|Metric Definition|

|38271|Checking this box will cause this calculation to happen after the main query which allows you to do formulas on the results. You can then calculate percentages of totaled values. You can only use field names that are in the query currently as either grouping fields or the columns.|
|853|Save| |854|Cancel|

|855|Available Fields|

|856|Click on a field to add it to the calculation|
  1. {{:item.name}}
|818|show advanced options||819|hide advanced options|

|848|Security Groups|

|849|All security groups have been added to the report|
  1. {{:item.GroupName}}

|850|Calculated Field|

|39348|Field Definition|

|853|Save| |854|Cancel|

|855|Available Fields|

|856|Click on a field to add it to the calculation|
  1. {{:item.name}}

|19643|Calculated Condition|

|39350|Condition Definition|

|19644|This option only works in Platinum. If you set this option and memorize the report, you will no longer be able to edit the conditions in the classic screens|
|818|show advanced options||819|hide advanced options|
|853|Save| |854|Cancel|

|855|Available Fields|

|856|Click on a field to add it to the calculation|
  1. {{:item.name}}

|38272|Calculated Filter|

|39350|Condition Definition|

|818|show advanced options||819|hide advanced options|
|853|Save| |854|Cancel|

|855|Available Fields|

|856|Click on a field to add it to the calculation|
  1. {{:item.name}}