6 Replies Latest reply: Apr 8, 2017 3:56 PM by adarsh chaubey RSS

    Need Help

    adarsh chaubey

      Hi All,

       

      Greetings,

       

      I want to show % Change (this year vs last year) Positives values to be highlighted in Green and negatives in Red in horizontal bar chart. Can anyone help me.

       

      Regards

      Adarsh

        • Re: Need Help
          Sunny Talwar

          Would you be able to share a sample to show what you have?

            • Re: Need Help
              adarsh chaubey

              here this is the chart..............on right sidecaaa.png

                • Re: Need Help
                  neelam sehrawat

                  If its about changing the color then you can use 'Background Color' option when you expand your expression and use calculation.

                  If((your_Calculation)>0, green(), Red()).Capture.PNG

                    • Re: Need Help
                      adarsh chaubey

                      if(GetSelectedCount(Year)=0 and GetSelectedCount(Month)=0 ,

                       

                       

                       

                       

                      (Count( DISTINCT {< Year=,Month=, [Invoice Date] = {">=$(=YearStart(Max([Invoice Date])))<=$(=Max([Invoice Date]))"}>}Customer_Name)-

                      Count( DISTINCT {< Year=,Month=, [Invoice Date] = {">=$(=AddYears(YearStart(Max([Invoice Date])),-1))<=$(=AddYears(Max([Invoice Date]),-1))"}>}Customer_Name))/

                      (Count( DISTINCT {< Year=,Month=, [Invoice Date] = {">=$(=AddYears(YearStart(Max([Invoice Date])),-1))<=$(=AddYears(Max([Invoice Date]),-1))"}>}Customer_Name)),

                       

                       

                      (Count( DISTINCT {< Year=,Month=, [Invoice Date] = {">=$(=Min([Invoice Date]))<=$(=Max([Invoice Date]))"}>}Customer_Name)-

                      Count( DISTINCT {< Year=,Month=, [Invoice Date] = {">=$(=AddYears(Min([Invoice Date]),-1))<=$(=AddYears(Max([Invoice Date]),-1))"}>}Customer_Name))/

                      (Count( DISTINCT {< Year=,Month=, [Invoice Date] = {">=$(=AddYears(Min([Invoice Date]),-1))<=$(=AddYears(Max([Invoice Date]),-1))"}>}Customer_Name))

                       

                       

                      )>0,RGB(77,167,65),RGB(255,113,113)..

                       

                       

                      I am trying this but it is not working

                • Re: Need Help
                  Anil Babu Samineni

                  What was the expression you defined for +ve and -ve values?

                    • Re: Need Help
                      adarsh chaubey

                      if(GetSelectedCount(Year)=0 and GetSelectedCount(Month)=0 ,

                       

                       

                       

                       

                      (Count( DISTINCT {< Year=,Month=, [Invoice Date] = {">=$(=YearStart(Max([Invoice Date])))<=$(=Max([Invoice Date]))"}>}Customer_Name)-

                      Count( DISTINCT {< Year=,Month=, [Invoice Date] = {">=$(=AddYears(YearStart(Max([Invoice Date])),-1))<=$(=AddYears(Max([Invoice Date]),-1))"}>}Customer_Name))/

                      (Count( DISTINCT {< Year=,Month=, [Invoice Date] = {">=$(=AddYears(YearStart(Max([Invoice Date])),-1))<=$(=AddYears(Max([Invoice Date]),-1))"}>}Customer_Name)),

                       

                       

                      (Count( DISTINCT {< Year=,Month=, [Invoice Date] = {">=$(=Min([Invoice Date]))<=$(=Max([Invoice Date]))"}>}Customer_Name)-

                      Count( DISTINCT {< Year=,Month=, [Invoice Date] = {">=$(=AddYears(Min([Invoice Date]),-1))<=$(=AddYears(Max([Invoice Date]),-1))"}>}Customer_Name))/

                      (Count( DISTINCT {< Year=,Month=, [Invoice Date] = {">=$(=AddYears(Min([Invoice Date]),-1))<=$(=AddYears(Max([Invoice Date]),-1))"}>}Customer_Name))

                       

                       

                      )>0,RGB(77,167,65),RGB(255,113,113)..

                       

                       

                      I am trying this but it is not working