How to change color of Area Series based on Bar Series values

CodeRookie
CodeRookie
edited February 11, 2022 in Analytics #1

Good morning, all!

I have a bar chart that also includes a secondary Area Series (see pic). The Bar Series tracks daily count of safety conversations our employees do. We are required to do at least 80 over the course of a week. Basically, if we do 12 per day, we would be safe to reach our goal. What I would like to do, is to have the Area Series change from grey to yellow in color if we fall below the average at any time. So, if we're below 12 on Monday, yellow, if we're at 25 on Tuesday, grey, and so on. Any time the count gets to 80 or above, it would go to grey regardless of the day. Any thoughts on how to script this?

Thanks in advance for the help!!

Scott

Answers

  • CodeRookie
    CodeRookie
    #2

    One other requirement my manager would like to see is that if the count is less than 72 any time on Friday, the bar would be a bright yellow (the Area Series can be a 'dirty' yellow for the above question), and the bar should be red if the count is below 80 at any time on Saturday.

    Thanks,
    Scott

  • jfranken
    jfranken E
    edited July 27, 2018 #3

    Hi Scott,

    Here's an example (see attached). This chart area changes to yellow if behind during the week and orange if behind on Friday. I forgot to add code for Saturday, but it's the same idea.

    Warning No formatter is installed for the format ipb

Categories

image
OpenText CE Products
Magellan Text Mining
Docs & APIs