I have a chart that shows current week and previous week's data. It is a vertical bar chart, on X axis it shows the following labels:
Agent - Current Week
Self Service - Current Week
Agent - Previous Week
Self Service - Previous Week
The formula i use on change of for the graph is as follows:
if ({tickets.open_date} >={?01StartDate} and {tickets.open_date} <= {?02EndDate})
then
if isnull({tickets.source}) or {tickets.source} <= 0
then "Agent - '{?01StartDate}' to '{?02EndDate}'"
else "Self Service - Current Week"
else if ({tickets.open_date} >=({?01StartDate}-7) and {tickets.open_date} < {?01StartDate})
then
if isnull({tickets.source}) or {tickets.source} <= 0
then "Agent - Previous Week"
else "Self Service - Previous Week"
My question is there a way to replace previous week and current week with the actual date range that is entered in?
Agent - Current Week
Self Service - Current Week
Agent - Previous Week
Self Service - Previous Week
The formula i use on change of for the graph is as follows:
if ({tickets.open_date} >={?01StartDate} and {tickets.open_date} <= {?02EndDate})
then
if isnull({tickets.source}) or {tickets.source} <= 0
then "Agent - '{?01StartDate}' to '{?02EndDate}'"
else "Self Service - Current Week"
else if ({tickets.open_date} >=({?01StartDate}-7) and {tickets.open_date} < {?01StartDate})
then
if isnull({tickets.source}) or {tickets.source} <= 0
then "Agent - Previous Week"
else "Self Service - Previous Week"
My question is there a way to replace previous week and current week with the actual date range that is entered in?