Discussions

 View Only
  • 1.  Goal Line(s) Bar Graphs

    Posted 06-05-2022 19:05
    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.
    ------------------------------


  • 2.  RE: Goal Line(s) Bar Graphs

    Posted 06-06-2022 09:51
    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
    ------------------------------



  • 3.  RE: Goal Line(s) Bar Graphs

    Posted 06-06-2022 13:08
    John, I have created a new chart to show 30 days past of patient encounters using a line bar chart. I set up a variable called goalLine set initially to zero. 

    But I don't know how to access it in the customize chart.

    ------------------------------
    Bob T.
    ------------------------------



  • 4.  RE: Goal Line(s) Bar Graphs

    Posted 06-06-2022 13:29
    Hi Bob,
    It looks like you created a Global Variable. You will need to create a Report Formula with Formula - Numeric or a Formula - Numeric field inside of the table. The formula needs to be something like If(DayofWeek(ToDate([Date Created]))=5, 450, 900), then you can choose that  field as the basis of the line on the chart.
    Thank you,
    John


    ------------------------------
    John Crosland
    ------------------------------



  • 5.  RE: Goal Line(s) Bar Graphs

    Posted 06-06-2022 13:51
    I just tested it. Unfortunately, if you use the line and bar chart, then there will be a different scale for the two different types. So, You would be better off plotting a goal bar or a line and another bar or line on the same scale by selecting the + next to the # of Encounters, and selecting Goal.

    ------------------------------
    John Crosland
    ------------------------------



  • 6.  RE: Goal Line(s) Bar Graphs

    Posted 06-06-2022 14:28
    John, I'm not sure how to plot a goal bar on the line-bar chart. But will work on it.

    ------------------------------
    Bob T.
    ------------------------------