4 Replies Latest reply on Nov 20, 2018 10:21 AM by Chester Guerra

    Conditional Formatting on Discrete Values

    Chester Guerra

      Hello,

       

      I am working on a data set and would appreciate some help. The data is hours by week. This is a direct connection to the database, so unfortunately I can't change the data. An example of the dataset is below. Tableau recognizes the hours as numbers of course but in order to show this I converted the weeks to "Discrete" values. This way, I can show the hours by week in rows. However, I am trying to create a calculated field to highlight any hours greater than 45. For example in week1 60 and 80 should be red and so forth. I initially started with an if else statement but running into issues. Any ideas would be greatly appreciated. Thank you!

       

      Week1
      Week2
      Week3
      Week4
      Week5
      4020561256
      6030472445
      4550457623
      80100328045