3 Replies Latest reply on Oct 22, 2018 2:50 AM by Akram Ebrahim

    Change color of line based on avg

    Tableau Learner

      Hi all,

       

      This is what i currently have

       

      My current calculation for KPI: IF COUNTD([Incident Number]) > (Total([# of Incidents]))/30 THEN "Out of Control" ELSE "In Control" END

      I know it's wrong, but not too sure how to do it like this.

      I want it such that whenever it goes above the avg line, it will be red (out of control). If it's below, it will be green (in control).

      Is it possible?

      I cannot attach the workbook since data is sensitive.

       

      Thanks!