2 Replies Latest reply: Feb 5, 2016 1:57 PM by Hirish V RSS

    Bar Chart with variable bar

    Fernando Martini

      Hi everyboy,

       

      I need to create a bar chart with a variable bar depending on a setted value through an input box.

      Example:

      Each month of 2016 (green bar) should be the same value of 2015 plus 10%.

      Is this possibe? Any suggestions?

      Sem título.png

        • Re: Bar Chart with variable bar
          Stefan Wühl

          Try a bar chart with dimension Month and 4 expressions ,like

           

          =Sum({<Year = {2013}>} Sales)

          =Sum({<Year = {2014}>} Sales)

          =Sum({<Year = {2015}>} Sales)

          =Sum({<Year = {2015}>} Sales) * (1+vPercentage)

           

          vPercentage being your variable set in the input box

          • Re: Bar Chart with variable bar
            Hirish V

            Hi,

            May be like this,

             

            INPUTFIELD InputVar;
            Data:
            LOAD *,
            0 as InputVar
             INLINE [
                Customer , Sales
                1, 2200
                2, 1100
                3, 1200
                4, 1100
                5, 2100
                6, 12000
            ];
            

             

            Front end :

            Bar Chart with,

            Dimension :

            Customer
            =ValueList('Sales')
            

            Expressions:

            =if(ValueList('Sales'),'Sales',Sum(Sales))
            =if(ValueList('Sales'),'Sales',InputVar)
            

             

             

            By Using Value list will call both of the expression into a bar like this,

             

            Bar Chart with Input Variable-204505.PNG

             

            Hope this Helps,

            PFA,

            Hirish