The only way that I can think that you would be able to do this is by using a bar and line chart type, and then set a Goal Line Variable and use that as the value of the Line. You can use something like: If(DayofWeek(ToDate([Date Created]))=5, 450, 900) as a Report Formula. Instead of totaling those to make your line, then you are going to want to show the average, maximum, or minimum.
------------------------------
John Crosland
------------------------------
Original Message:
Sent: 06-05-2022 19:05
From: Bob Thomas
Subject: Goal Line(s) Bar Graphs
I know how to show a goal line in bar charts. A feedback ticket asked how to have two goal lines, as Monday-Thursday we have a goal of 900 patient encounters. But on Friday some clinics are open just half a day and the goal line suggested is 450.
Is there a way to do this?
------------------------------
Bob T.
------------------------------