add manual target line

Afidah
Afidah Member
in Archive

Hi,

Now i have stacked bar. How I can add target line month to month and every month is ddifferent target.

Comments

  • ST_-Superman-_
    ST_-Superman-_ Coach

    If there is any calculation to it, you could potentially create the target line with a beast mode.  Otherwise you would need to add the target values to your data set and then you could use a bullet, line and grouped, symbol and grouped, etc. chart type to display it.


    “There is a superhero in all of us, we just need the courage to put on the cape.” -Superman
  • Afidah
    Afidah Member

    Is the any sample how to write code in beast mode.
    Sample:-
    Target Set
    Jan - 100
    Feb - 200
    Mar - 300

  • ST_-Superman-_
    ST_-Superman-_ Coach

    Case when `month`=‘Jan’ then 100

    when `month`=‘Feb’ then 200

    when `month`=‘Mar’ then 300

    end

     

    however, you should replace ‘Jan’ with whatever your dataset has


    “There is a superhero in all of us, we just need the courage to put on the cape.” -Superman
This discussion has been closed.

Categories