7 Replies Latest reply: May 23, 2018 10:34 AM by Sunny Talwar RSS

    Color mix expression with if condition

    Pranahitha nellutla

      Hi I am trying to give a gradient color using if stmt and color mix func to a barchart iam working on. can i get some help here. I cant get the code right its not working for me.

       

      if(year([Applied Date])=year(today()), colormix1(rank(total column(1))/noofrows(TOTAL), rgb(255, 0, 102), rgb(255, 204, 224)))

       

      bar.png

      color expression.png

      this is my data

       

      year([date field])month([date field])measure
      2017May67,718
      2017Jun84,459
      2017Jul84,692
      2017Aug86,536
      2017Sep75,714
      2017Oct83,916
      2017Nov78,621
      2017Dec54,663
      2018Jan105,698
      2018Feb87,395
      2018Mar92,941
      2018Apr77,395
      2018May54,646

       

      thanks